Select Category
Sitemap Help Contact
print article

Backup Your MySQL Database Using phpMyAdmin

For webhosting packages.

Follow the steps below to backup a MySQL database from your Linux Hosting package by using the phpMyAdmin web interface to export the data to a file.

Step 1
Log in to your 1&1 Control Panel and select the relevant package.
Step 2
Click MySQL Database under My Products in the left side menu.
1&1 Control Panel
1&1 Control Panel
Step 3
Click the Open link in the phpMyAdmin column for the database you wish to back up.
MySQL Databases Menu
MySQL Databases Menu
Step 4
Click the Database Name at the top left of the phpMyAdmin window from the Current Server drop-down menu.
phpMyAdmin Current Server Menu
phpMyAdmin Current Server Menu
Step 5
Click on the Export tab.

Click the Quick button to export all tables in the database (Unless you only wish to export specific tables. If so, click Custom). Please also select the SQL export option to export the database in SQL format and then click Go.
Database Export Menu
Database Export Menu