How to restore one database from a backup

Updated 2026-10-29

On this page
  1. Before you start
  2. Steps
  3. Good to know
  4. Common questions

When a database was damaged, emptied by a bad update or changed by mistake, you can restore only that database from a snapshot or a full backup. Files and email stay as they are.

Before you start

  • The database must exist in the account. If it was deleted, create it again with exactly the same name (in MySQL Databases or PostgreSQL Databases) before restoring. A database that does not exist is skipped.
  • Restoring replaces the database's current content. Changes made since the backup are lost.

Steps

  1. Open the copy to restore from:
    • Administrator or reseller: in the admin panel (https://<server>:2087), open Daily Snapshots or Full Backups (section Websites) and click Restore… next to a copy of the account.
    • Customer: in the control panel (https://<server>:2083), open Backups (section Advanced). Click Browse & restore next to a snapshot, or Restore… next to a backup.
  2. Leave Don't restore files selected.
  3. Under Databases, tick the database. PostgreSQL databases are marked PostgreSQL.
  4. Leave Email unticked.
  5. Click Restore selected and confirm.

The restore runs in the background, usually within a minute for a normal website database.

Good to know

  • What is restored: the database's tables, data, routines, triggers and events as they were at backup time.
  • Database users are not changed. If you re-created the database, give its user access again (Add user to database in MySQL Databases) so the website can connect.
  • Snapshots list the databases they contain. If a database is missing from a snapshot's list, that copy does not hold it (for example, a files-only job).
  • For frequent database copies, an administrator can add a backup job that copies Databases every 15 minutes. See recommended backup plans.

Common questions

I restored but the website still shows the new data. Why?

Check that you picked a copy from before the change (the time is shown in the list), and that the restore finished. Caching plugins may also show old pages; clear the website's cache.

Can I restore a database under a different name?

No. A database is restored into the database of the same name. To compare, restore into the original after taking a fresh copy, or download a full backup and import the .sql.gz file into another database yourself.

The restore failed with "Database …:". What does it mean?

The database server refused the import; the rest of the message says why, for example a full disk. See backup failures and errors.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.