How do I restore my database in the panel?

DreamHost's daily backups

All DreamHost MySQL products backup daily. The backups start at midnight and complete after every single database has been done. It is HIGHLY RECOMMENDED to make and keep your own offsite backups of all databases to supplement the short term backups DreamHost creates. DreamHost makes no guarantee that backups are available.

To backup your entire account (ftp users, mail users and databases) check out the account backup feature. This is available in the (Panel > 'Billing & Account' > 'Backup Your Account') section of the DreamHost panel. The backups created can be downloaded to another offsite location for safe keeping.

Restoring a database

There are generally 5 days of backups available. Please note that this is not guaranteed so you should always make your own personal backups just in case there are none available to restore in your panel.

  1. Navigate to the (Panel > 'Goodies' > 'MySQL Databases') page.
    01 Restore MySQL.png
  2. Click the Restore DB button to the right of your database.
    02 Restore MySQL.png
  3. Choose what you would like restored:
    • Restore which backup? - Choose any available backup from the dropdown menu
    • Tables to restore - If you want the entire database restored, leave this as *
    • When restoring - You have 4 options of how your tables are restored.
    Options 1 and 2 - The first two options restore your tables but the names are changed. This way, the restored files do NOT take the place of the current files. You'll either need to manually change the table names or adjust your site's config file to view the restored database
    Options 3 and 4 - The last two options immediately replace your database tables. The current tables are renamed. You most often want one of the two last options
  4. Click the Restore my backup now! button.

You'll see a success messages notifying you that your database will be restored within 10 minutes.

MySQL database disk usage

MySQL servers have very fast, high RPM and smaller disks deployed in them, to provide the speed boost required to make MySQL snappy. Due to this, there is limited space available on the MySQL servers and DreamHost encourages its customers to develop as small and efficient databases as possible. For specifics on what size databases are allowed on a specific DreamHost MySQL product, please review the Unlimited Policy and contact support if you have further questions.

See also

Did this article answer your questions?

Article last updated .