How to Perform Database Backups with WP-DB Manager
The second part of the guide to the WP-DB Manager WordPress plugin will show you how to backup your database and check the status of it to ensure that it is working to its full potential.
Step 1) On the Dashboard, scroll down the left-hand sidebar until you find ‘Database’ and click on ‘Backup DB’ from the dropdown. This will take you to the Backup DB page, and the first section you will see will be the backup status. Anything in red needs to be addressed as soon as possible so that the backup can function properly.
Step 2) The Backup Database details where, when and under what name and type your backup will take place. You can also create a GZIP Database Backup file, which you can upload if your site has any problems down the road. Hit ‘Yes’ and then ‘Backup’ to get the file downloaded.
Step 3) Choose ‘Manage Backup Database’ from the left-hand sidebar of the dashboard, and from here, you can Download, Restore and Delete backups files, as well as set an email address for receiving any backup files via email.
Step 4) Click on ‘Optimise DB’ on the left-hand sidebar. From here, you can scroll down the list of tables and choose between ‘Yes’ or ‘No’ for which tables you wish to optimise. This should be done at least once a month, and you are likely to keep most tables in the ‘Yes’ column, unless they are not important to you.
Step 5) Scroll down to the bottom of the page and hit ‘Optimise’ when you have finished checking the tables.
Step 6) Choose ‘Repair DB’ from the left-hand sidebar of your Dashboard. From here, you can go through your tables and repair any that have had issues come up on the main Dashboard for the Database. Simply scroll down to the bottom of the page and hit ‘Repair’ when you have made your choices.