After your backup has completed successfully, you will be able to download an archive of your database from your Sucuri Backups Dashboard (the link can be found at the top of your Sucuri dashboard).

Choose the card for the website.

backup card

Then click on the desired backup date.

backup date

Next, choose the database you want to restore. When you click on the database archive the file will download in your browser. This file is a gzipped archive and will be smaller than your actual database.

download database archive

Restoring Your Website Database using phpMyAdmin

  1. Login to phpMyAdmin. You can find it in the Database section of cPanel. Login phpMyAdmin

  2. Click 'Databases' and select the database that you will be importing your data into. Select database

  3. Create a manual snapshot of your current database before restoration. This step is optional, but highly recommended. phpMyAdmin db snapshot

  4. Next, you'll see a list of tables inside the database. database tables

  5. Look for the row of tabs across the top of the screen. Click the Import tab. database import

  6. On the next screen you can select the import file. You'll see a Browse button.

  7. Click 'Browse'. Choose the database backup file you downloaded from your Backups Dashboard.

  8. Make sure SQL is selected in the Format drop-down menu. There's no need to decompress the .gz archive, it can be directly imported.
  9. Click 'Go'.

Successful database import

That's it!

If you are still not sure what do, please contact your host for help restoring your database backup.