Configuring Backups, Scheduling, and More with WP-DB Manager
The fourth step in the guide to the WP-DB Manager WordPress plugin will take a look at the options available for your Database, and help you decide which ones you need.
Step 1) From the Dashboard, scroll down the left-hand sidebar until you find ‘Database’, and then click on ‘DB Options’ from the dropdown as shown below.
Step 2) You can set up paths to your SQL and SQL dumps here, but it is best to hit ‘Auto Detect’, or email your server administrator if you are unsure as what to do.
Step 3) You can create a path to your back-up database folder here. You have to ensure that the folder is writable for you to add to it.
Step 4) Use the Maximum Backup Files section to create a limit to the number of files allowed in the backup folder. It is wise to keep this number to a low amount in order to stop the folders from getting too large.
Step 5) Depending on whether your server is Windows or Linux, the path will be slightly different. Read the notes carefully to understand the difference between the two so that you can find the files more easily.
Step 6) Automatic scheduling is important because not everybody has the time to remember to create a backup folder and back their database up securely. You can set up automatic backups, optimisation and repairs, and it is best to do these once a week or every two weeks, just to be on the safe side.
Step 7) When you are creating a backup, enter an email address so that you can have the folder sent to you in a secure email, or leave blank to disable the feature. You can change the ‘From’ and ‘Subject headings’ if you wish, or leave them to default settings.
Step 8) Click ‘Yes’ or ‘No’ to hide admin notices. This means that you disable notifications from the admin, such as if your DB is available to the public. It is safer to leave this as ‘No’ so that you are kept in the loop.