Help Center

Version 2.0

• Windows Hosting
• Working With Databases

Help Center Search

Related Articles

• What MySQL Server Features are Disabled on my Shared Hosting Account?
• Connecting to a Microsoft SQL Server Database Using ASP/ADO
• Which version of MySQL should I choose?
• Connecting to a MySQL Database Using ASP/ADO
• Do you restrict any features in MySQL 4.1/5.0?
• What is an Access Database?
• What are the major differences between MySQL 4.0 and 4.1/5.0?

How do I export a MySQL Database?

You have two options when exporting your MySQL database. You can either export the entire database, or export selected tables of a database, to a file.

To Export the Complete Database

1. Log in to your Account Manager.
2. In the My Products section, select Hosting.
3. Next to the hosting account you want to modify, click Manage Account.
4. In the Databases section of the Hosting Control Center, click the icon for the type of database you want to manage. On this page, you can create new databases, delete databases, make changes to existing databases, or export databases.
5. To access more advanced management functions, click Open Manager next to the database you want to export.
6. Enter your username and password for your database.
7. On the phpMyAdmin page, click Export under MySQL.
8. In the Export field on the left side of the View Dump pane, select the database you would like to export.
9. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
10. When you are satisfied with your options, click the Go button. Your exported data displays.
11. Click Select All and paste it into a SQL file.

Your database has been exported.

To Export Selected Tables Within a Database

1. Log in to your Account Manager.
2. In the My Products section, select Hosting.
3. Next to the hosting account you want to modify, click Manage Account.
4. In the Databases section of the Hosting Control Center, click the icon for the type of database you want to manage. On this page, you can create new databases, delete databases, make changes to existing databases, or export databases.
5. To access more advanced management functions, click Open Manager next to the database you want to export.
6. Enter your username and password for your database.
7. Click on the Databases icon under MySQL.
8. Click the database name you want to export tables from.
9. Click the Export tab.
10. In the Export field on the left side of the View Dump pane, select the tables you would like to export. Use the CTRL-key to select multiple tables.
11. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
12. When you are satisfied with your options, click the Go button. Your exported data displays.
13. Click Select All and paste it into a SQL file.

The selected tables have been exported.

• Not helpful
• Somewhat helpful
• Helpful
• Very helpful
• Solved my problem