phpMyAdmin: How to restore a database backup

Step 1:

Please note that larger databases cannot be backed up via phpMyAdmin in some circumstances, because the script is limited by the server's restrictions!

In this case we recommend to back up the data using an external tool such as HeidiSQL.

Step 2:

First, log in to your database via phpMyAdmin.

This can be done directly in the KAS (Technical Administration) panel by clicking menu item Databases and the phpMyAdmin icon right next to the respective database.

You can also access the phpMyAdmin directly by calling up www.yourdomain.com/mysqladmin/ and entering the login credentials of the database. The login credentials can be found inside your KAS (Technical Administration) under the menu item Databases.

Once inside the phpMyAdmin, please click the database name on the left side unless it's already selected.

Step 3:

Click the Import tab.

Step 4:

In order to select your database backup, click the Browse button. You can initiate the restore by clicking OK afterwards.

Step 5:

In case you will get an error message showing Duplicate entry, please empty the database and try again the import of the database backup.

Step 6:

In order to delete the tables and therewith empty the database, first click the Structure tab. Scroll down and choose Check all below the table list. Then select Drop and click Yes.
How helpful was this tutorial?

Search in support and FAQ

Seitensuche