Topic Options
Post Options
Thanks(0)
Databases
SQL
Status
Variables
Charsets
Engines
Processes
Export
Import
From GoDaddy
Last Updated: February 16, 2007 9:17 PM
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
- Log in to your Account Manager.
- Under the Hosting & Email section, select Hosting Account List.
- Next to the hosting account you want to modify, click Open.
- Under the Databases section of the Hosting Manager, 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.
- To access more advanced management functions, click Open Manager next to the database you want to export.
- Enter your username and password for your database.
- On the phpMyAdmin page, click Export under MySQL.
- In the Export field on the left side of the View Dump pane, select the database you would like to export.
- Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
- When you are satisfied with your options, click the Go button. Your exported data displays.
- Click Select All and paste it into a SQL file.
Your database has been exported.
To Export Selected Tables Within a Database
- Log in to your Account Manager.
- Under the Hosting & Email section, select Hosting Account List.
- Next to the hosting account you want to modify, click Open.
- Under the Databases section of the Hosting Manager, 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.
- To access more advanced management functions, click Open Manager next to the database you want to export.
- Enter your username and password for your database.
- Click on the Databases icon under MySQL.
- Click the database name you wish to export tables from.
- Click the Export tab.
- 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.
- Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
- When you are satisfied with your options, click the Go button. Your exported data displays.
- Click Select All and paste it into a SQL file.
The selected tables have been exported.
