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.
Backing Up a MySQL or MSSQL Database
You can back up MySQL and MSSQL databases via the Database section of the GoDaddy Hosting Control Center. This creates and stores your backups in a folder on your hosting account, _db_backups.
- Log in to your Account Manager.
- From the Products section, click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Hosting Control Center, click the icon for the type of database you want to backup.
- 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. (Note: this can take hours so plan accordingly)
NOTE: When you create a backup file using the Hosting Control Center, 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.
Restoring a MySQL or MSSQL Database
You can restore MySQL and MSSQL databases from the Database section of the Hosting Control Center.
- Log in to your Account Manager.
- From the Products section, click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Hosting Control Center, click the icon for the type of database you want to restore.
- Click the pencil icon next to the database you would like to restore to open its edit features.
- Click the Restore icon in the menu bar.
- Select the back up file you want to restore by clicking the radio button next to the back up file name.
- Click Restore.
You can check on the progress of your restore from the Database Information screen.