I haven’t mentioned Lester Chan much at this point, undeservedly so.
One of the most prolific and professional wordpress plugin developers his work is excellent and the WP DBManager is only one of a selection of plugins hes created that is absolutely fantastic.
A compliment to the WordPress-Backup plugin this is much more extensive at it serves to backup your whole database and not just the images, plugins and themes covered by WordPress backup.
Installing this particular plugin is a breeze (as usual) but the configuration does require some file moving and server administration to permit access to files and folders, so if you are unsure about this, hire someone to sort the plug-in out. It goes without saying that you should be hiring a trusted professional as you will be allowing them access to moderate your server files, so expensive should not be a factor if you want this done correctly, its worth it.
The plugin itself covers allows you to optimize, repair, backup and restore the database, as well as delete the backup database, drop/empty tables and run selected queries. Most importantly for you, once it is configured it will run an automatic schedule to backup the database every 24 hours, ensuring that, in the event of a disaster, you will not have lost a massive amount of your time, effort and work.
Author: Lester Chan
Download the WP DBManager Plugin.