Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

New Plugin: Database Manager Pro (V1.0)

+5 votes
1,239 views
asked Nov 5, 2014 in Plugins by sama55
edited Apr 29, 2015 by sama55

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: DataTablesjQuery UIBootstrapFoundation)
  • 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

Q2A version: 1.6.x, 1.7
commented Nov 11, 2014 by Sibi
great work...!
waiting for the launch
commented Nov 25, 2014 by Gurjyot Singh
It would a useful plugin. Nice job sama55... All the very best with it. :-)
commented Dec 1, 2014 by Funrunna
Nice idea and plugin but will probably be too expensive for many. Good luck none the less!!!

1 Answer

0 votes
answered Nov 30, 2014 by sama55

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.
...