How do I restore a database backup?

You can restore a database backup via phpMyAdmin. For this, you need a backup file of your database, such as a .sql or .gz file.

Note: This article differs depending on the system (CloudPit or Controlpanel). Please use the appropriate section.
Warning: If you delete existing tables before importing, the existing data in the database will be removed. Before deleting, check that you have selected the correct database and have a complete backup.

Table of Contents

Restore database backup in CloudPit

Log in to CloudPit and open the desired web hosting package.

Open the Databases section (1) and click on OPEN PHPMYADMIN (2) for the desired database.

After logging into phpMyAdmin, check on the left that the correct database is selected. On the right, the tables of this database are displayed.

If you want to replace the existing content with the backup, select the existing tables and choose Drop Tables.

Then click on Import at the top. Under Select file, choose the backup file and start the import by clicking OK.

After a successful import, the tables and contents from the backup file will be displayed in the database.

Restore database backup in Control Panel

Log in to the Control Panel and open Web HostingDatabases (1).

Click on the Database icon next to the desired database to open phpMyAdmin.

After logging into phpMyAdmin, check on the left that the correct database is selected. On the right, the tables of this database are displayed.

If you want to replace the existing content with the backup, scroll down, select the existing tables, and choose Drop Tables.

Then click on Import at the top. Under Select file, choose the backup file and start the import by clicking OK.

After a successful import, the tables and contents from the backup file will be displayed in the database.

For more information about backups, see here: Where can I find my backups?