How2: Backing Up the MySQL Database

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.