New Plugin: Database Manager Pro (V1.0)

Question

Database Manager Pro (DMP)

This is flexible and powerful auto database maintenance plugin. 

Your server would fight with spam and remove it automatically on your behalf.

Full Document (PDF)

Feature summary:

• Backup tab: Backup, Restore, Download, CRON job, other
• Table tab: Check, Optimize, Repair, Empty, Drop, CRON job, other
• Garbage Collection (GC) tab: GC checker, GC executor
• GC Manager tab: Create, Read, Update, Delete, other
• GC Group Manager tab: Create, Read, Update, Delete, other
• (CRON) Job Manager tab: Create, Read, Update, Delete, other
• (CRON) Job Scheduler
• Event Recorder (Result of job process will be notified with new NP plugin)

Views

Detailed features

• UI: DataTables (Themes: DataTables, jQuery UI, Bootstrap, Foundation)
• Plugin options panel
• Backup database
• Restore database
• Download database
• Delete backup
• Backup scheduler
• Show tables
• Check tables
• Optimize tables
• Repair tables
• Empty tables
• Drop tables
• Table maintenance scheduler
• Garbage Collection Executer
• Garbage Collection Manager
• Pre-installed Garbage Collector (Sub plugins)
  • *** Related cache ***
  • ​Truncate cache
  • ​Delete cache older than one year
  • Delete cache older than one month
  • *** Related eventlog ***
  • ​Truncate eventlog
  • ​Delete eventlog older than one year
  • ​Delete eventlog older than one month
  • Delete eventlog of unregistered users
  • *** Related messages ***
  • ​Truncate messages
  • ​Delete messages older than one year
  • Delete messages older than one month
  • ​Delete messages between unregistered users
  • Delete private messages
  • ​Delete private messages older than one year
  • Delete private messages older than one month
  • ​Delete private messages between unregistered users
  • Delete public messages
  • Delete public messages older than one year
  • Delete public messages older than one month
  • Delete public messages between unregistered users
  • *** Related users ***
  • Delete blocked users
  • Delete blocked users + Hide posts
  • Delete email unconfirmed users who have passed 1 month after registration
  • Delete unloggedin users during 1 year
  • Delete unloggedin users during 1 year + Hide posts
  • Delete unwritten users during 1 month after registration
  • Delete unwritten users during 1 year
  • Delete unwritten users during 1 year + Hide posts
  • *** Related cleanup option (Same as Admin>Stats>Cleanup) ***
  • Reindex content
  • Recount posts
  • Recalc points
  • Refill events
  • Recalc categories
  • Delete hidden posts
• Garbage Collection Group Manager
• (CRON) Job Manager for automatic maintenance

User's benefit

• phpMyAdmin is unnecessary
• Saving disk space
• Automatic remove spam users
• Automatic remove spam posts
• Site performance up

Free Edition

Comments

great work...!
waiting for the launch

---

It would a useful plugin. Nice job sama55... All the very best with it. :-)

---

Nice idea and plugin but will probably be too expensive for many. Good luck none the less!!!

Answer 1

Tips for Linux environment:

When dealing with large databases, time out error may occur during backup and restore. In that case, you might be solved by performing job asynchronously.

Backup command example in option panel:

nohup ^mysqldump -h^host -u^user -p^pw ^db | ^gzip > ^folder^db-^date.sql.gz | >> /dev/null 2>&1 &

Restore command example in option panel:

nohup ^zcat ^file | ^mysql -h^host -u^user -p^pw ^db | >> /dev/null 2>&1 &

 

You may not be able to use this tips in the windows environment.