Select Category
Sitemap Help Contact
print article

Backup a 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 the 1&1 Control Panel using your Customer ID OR domain name and your password.

If you have only one package, you will land on the Administration page. If you have more than one package, select the package in question to reach its Administration page.

Package overview
Package overview

Step 2
Click the MySQL link from the Hosting panel.
Click MySQL
Click MySQL

Step 3
Click the phpMyAdmin button for the database in question. Click phpMyAdmin
Click phpMyAdmin
Step 4
Click the Database Name at the top left of the phpMyAdmin window from the Current Server drop-down menu. Click the Database Name
Click the Database Name
Step 5
Toward the Top Right of the page, click on the Export tab. Click the Export tab
Click the Export tab
Step 6
Click the Quick button to export all tables in the database (Unless you only wish to export specific tables however this is usually the exception). Please also select the SQL export option to export the database in SQL format and then click Go. Select the Go button
Select the Go button