You are Here: FAQ ->Scripting and Programming Languages->MySQL Database->Article #14


How do I export a backup of my database using phpMyAdmin?


For Linux packages only!Linux Packages Only!
      This includes:
          arrow 1&1 Beginner (Linux)
          arrow 1&1 Home (Linux)
          arrow 1&1 Business (Linux)
          arrow 1&1 Developer (Linux)
          arrow 1&1 Dedicated Website Servers (formerly called managed servers)





Step 1:

Log in to the 1&1 Control Panel using your Customer ID OR domain name and your password at: http://admin.1and1.com

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

select package image
Step 2:

Click the icon for MySQL Administration from the Web Space & Access section.
select MySQL Administration
Step 3:

Click the phpMyAdmin button for the database in question.
click phpmyadmin button image
Step 4:

Click the Dabase Name at the Top Left of the phpMyAdmin window.

click database name image
Step 5:

Toward the Top Right of the page, click on the Export tab.

click export tab image
Step 6:

On the right-hand frame of the page, click the Select All link 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.

click select all image
Step 7:

Select any SQL options required. If you are unsure, it is best to leave these options as the default selection.

select SQL options image
Step 8:

At the bottom, click the checkbox for Save as file and type a file name in the text box. In this example, the file name is 1and1help.com-Apr.4th.2010

Compression is left best at None if unsure. Then Click the Go button.

click go image
Step 9:

Your browser should display a pop-up window prompting you to save or open the file. Please select Save and select a location to save the file on your local computer.

save file image



Print Article
How useful was this article?
(From 5 = Very Useful to 1 = Not useful at all):
1 2 3 4 5