Backing up a MySQL Database
Using the Hosting Control Center, you can backup and restore MySQL databases as often as you would like. However, you can only initiate a backup after any previous backup or restore request has completed.
When you create a back-up file using the Hosting Control Center, our system names the file using the name of the existing database. However, while you cannot define a filename during the back-up process, you can rename a file once the process is complete.
Note: You must use the the .sql filename extension when renaming any MySQL back-up file.
To Back Up a MySQL Database
- Log in to your Account Manager.
- In the My Products section, select Hosting.
- Click Manage Account next to the hosting account you want to modify.
- In the Databases section of the Hosting Control Center, Click the MySQL icon.
- Click the pencil icon next to the database you would like to back up to open its edit features.
- Click the Backup icon in the menu bar.
- Click OK to backup your database.
Your selected database will be backed up. You may check on the status of the backup progress from the MySQL database information screen in the Hosting Control Center at any time.
For additional information about backing up and restoring your database, see the following articles:
Restoring a MySQL Database
Where are database back-up files saved?