How to restore one database from a backup
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
- 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.
- Administrator or reseller: in the admin panel (
- Leave Don't restore files selected.
- Under Databases, tick the database. PostgreSQL databases are marked PostgreSQL.
- Leave Email unticked.
- 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.
Thank you — this helps us improve the article.
Still stuck?
Ask the AI about your exact situation — it answers from this knowledge base — or contact us.
Related articles
- How to restore from a snapshot (files, databases, email)
Pick a snapshot of an account and restore all files, one file or folder, chosen databases or the email, into the original place or a new folder.
- How to restore a full backup of an account
Restore an account from a full backup archive: everything at once with Restore all, or only the files, databases or email you choose.
- How to restore a single file or folder from a backup
Get back one deleted or changed file or folder from a snapshot or full backup, into a safe restored folder or straight to its original place.
- Recommended backup plans: example sets of backup jobs
Ready-made backup job sets for small servers, busy shops and resellers: how often to copy files and databases, how many copies to keep, and where.