Close Window x

Frequently Asked Questions

Help Center Search

Backing up and Restoring MySQL or MSSQL Databases

Print this Article
Comment on this Article
Last Updated: October 12, 2009 2:54 PM

Here's the Lowdown: MySQL and MSSQL may be different databases, but in the Hosting Control Center, the process of backing up and restoring them is virtually the same.

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 from the Database section of the Hosting Control Center.

To Backup a MySQL or MSSQL Database

  1. Log in to your Account Manager.
  2. In the My Products section, select Hosting.
  3. Click Manage Account next to the hosting account you want to modify.
  4. In the Databases section of the Hosting Control Center, click the icon for the type of database you want to backup.
  5. Click the pencil icon next to the database you would like to back up to open its edit features.
  6. Click the Backup icon in the menu bar.
  7. Click OK to backup your database.

    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./li>

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.

To Restore a MySQL or MSSQL Database

  1. Log in to your Account Manager.
  2. In the My Products section, select Hosting.
  3. Click Manage Account next to the hosting account you want to modify.
  4. In the Databases section of the Hosting Control Center, click the icon for the type of database you want to restore.
  5. Click the pencil icon next to the database you would like to restore to open its edit features.
  6. Click the Restore icon in the menu bar.
  7. Select the back up file you want to restore by clicking the radio button next to the back up file name.
  8. Click Restore.

You can check on the progress of your restore from the Database Information screen.