Help Center

Version 2.0

• Databases
• MySQL

Related Articles

• Do you restrict any features in MySQL 4.1/5.0?
• What are the new features available in MySQL 4.1?
• How many simultaneous connections can one MySQL database have?
• What are the major differences between MySQL 4.0 and 4.1/5.0?
• Which MySQL features do you disable on hosting accounts?
• How do I recompile the MySQL library to run under medium trust?
• How do you limit MySQL databases?

Exporting a MySQL Database from Your Hosting Account

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. Access your database via PHPMyAdmin. For more information, see Accessing PHPMyAdmin on Your Shared Hosting Account.
2. On the phpMyAdmin page, click Export under MySQL.
3. In the Export field on the left side of the View Dump pane, select the database you would like to export.
4. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
5. When you are satisfied with your options, click the Go button. You are prompted to download the file.

   NOTE: Our hosting accounts do not support compression.

Your database has been exported.

To Export Selected Tables Within a Database

1. Access your database via PHPMyAdmin. For more information, see Accessing PHPMyAdmin on Your Shared Hosting Account.
2. Click on the Databases icon under MySQL.
3. Click the database name you want to export tables from.
4. Click the Export tab.
5. 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.
6. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
7. When you are satisfied with your options, click the Go button. You are prompted to download the file.

   NOTE: Our hosting accounts do not support compression.

The selected tables have been exported.

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