Docs Home Return to Homepage
Get Started Login

How to Restore a Database with JetBackup

Last updated Changelog

On this page

Your site’s content, such as WordPress posts or shop products, lives in a database. If something in it goes wrong, put back a copy from one of our nightly backups. In this example we deleted a product from the products table in our cranedemo_shop database, then restored last night’s backup to get it back. Our screenshots are from cPanel; it works the same in DirectAdmin.

Warning: The database goes back to how it was when the backup was made. Anything saved to it since, such as new orders, comments or posts, is lost. If you’re not sure, download a copy of the backup first and look inside.

Steps

  1. Open JetBackup (see how to open it) and click Databases. Each database shows its newest backup. To use an older one, click Choose Other Backup and pick the date from the list.

    The Databases tab with the backup date list for cranedemo_shop highlighted

  2. Click your database’s row. It turns orange. Click Restore.

    The cranedemo_shop row selected and the Restore button highlighted

  3. The Restore Summary lists the database under Databases. Click Restore Selected Items.

    The Restore Summary listing Databases 1 items, with Restore Selected Items highlighted

  4. JetBackup opens the Queue. When the Status says Completed, the database is back. Ours took 5 seconds.

    The Queue showing the database restore with the status Completed

The deleted product was back, and the whole table was identical to how it was before we deleted it.

Restoring a WordPress site

To put a whole WordPress site back to an earlier day, restore both parts from the same date:

Not sure which database belongs to your site? Open wp-config.php in your site’s folder: the name after DB_NAME is the database.

Troubleshooting

Problem What to do
My database isn’t in the list It was created after the last backup ran. It’ll be in tonight’s backup.
I only need one table or a few rows back Download the backup instead, and copy what you need with phpMyAdmin.
The site still shows the old content Clear your site’s cache, such as a WordPress caching plugin, and your browser’s cache.
The restore shows Failed in the Queue Contact support with the database name and the backup date.

Snagged on something? Contact support and we’ll get you sorted.

Snagged on something?

Our sysadmins answer tickets around the clock.