How to create and restore a MySQL database backup

Go to the SiteBackup dashboard and click the Add Database button.
You will be taken to the Connection Details to add your database to the scheduler.
  • In the dropdown box choose the MySQL database.
  • Port number will be 3306.
  • The Host name is the full MySQL server domain name.
  • The Database name is the system designated name given to your database.
  • The User name is the database user name for that specific database.
  • Enter the password for your MySQL database.
Once you click the Next button, the system will test the connection, and if successful you will be taken to the database Schedule Backup page.
  • Verify all tables are accounted for.
  • Set the number of backups you want to store in the Retention field. Maximum retention is 30 days.
  • In the Frequency field, define number of times the backup should run.
  • Select the Start time which the backup should run. 
  • Leave the default Time Zone as Pacific Time.
Click Next to finalize the settings and enter a unique Profile name for your database backup schedule.  You can place a check mark on "Start a backup now" to start an immediate backup of your site.
Restoring a MySQL database can be initiated from the Databases section of the SiteBackup dashboard. To get started follow these steps.
  1. Go to the SiteBackup dashboard.
  2. Click the Restore Database button for the database you wish to restore. 
When you click the Restore Database button you will be taken to the Database Restore window. In the Restore Database Restore window, chose the backup you would like to restore from the dropdown list next to Backup date.
In the Tables list, verify that you have all the tables and objects you wish to restore.
Note: You can only restore the entire database and restoring the database on the MySQL server will overwrite existing tables, data, and objects on the server.
Click the Restore button to finalize the database restore procedure.
Note: If you have multiple MySQL databases configured in your SiteBackup dashboard, you will need to specify the database to restore in the Restore to dropdown.