You can back up and restore databases as often as you'd like, however, you can only initiate a restore after any previous backup or restore request has completed.
If you are trying to import third-party MySQL files, see Restore MySQL database from another host.
You can back up MySQL and MSSQL databases from the Database section of the Hosting Control Panel.
This creates and stores your backups in a folder on your hosting account, _db_backups
.
If you encounter an error the first time you attempt to create a backup, you should make sure the directory _db_backups
exists. This directory cannot be seen using the File Manager, as files with an underscore are hidden. However, using an FTP client you can select the option to show hidden files and directories.
When you create a backup file using the Hosting Control Panel, our system names the file using the name of the existing database. While you cannot define a filename during the backup process, you can rename a file once the process is complete.
You can check on the status of your backup from the Database Information screen.
If a database backup fails, click the option to Re-try the backup.
You can restore MySQL and MSSQL databases from the Database section of the Hosting Control Panel.
If you encounter errors while restoring a MySQL database, verify that the Create Database
line is removed or commented out from the database dump (backup file). Normally you can find this code about 10 to 15 lines down from the beginning. It can be removed or commented out by using a text editor of your choice (Notepad++ for example).
You can check on the progress of your restore from the Database Information screen.
If a database backup fails, click the option to Re-try the backup.
When you back up a database, it creates a backup file in the _db_backups
directory, which is located in the hosting account's root.
When you restore a database, you can only select from backup files in the _db_backups
directory.
So, if you want to move the database backup from one hosting account's database to another, you have to download the backup you created in the old account (from the _db_backups
directory), and then upload that file to the new account (into the _db_backups
directory).
These steps apply only to moving a database between two hosting accounts in our system. They might not work with backups created outside our system.
For more information about uploading and downloading files, see: