Importing/Exporting MySQL Databases

Votes: 0

You may import/export your MySQL databases using an application called PHPMyAdmin that can be found in your control panel (Plesk and Cpanel). Please see below for instructions.

Exporting MySQL Databases

Open PHPMyAdmin and select the database you would like to export.
Go to the “Export Tab”
Select “Save File As”
Click “Go”
You will be prompted to save this file. We highly suggest you save it on your desktop, so you can find it quickly and easily.

Importing MySQL Databases.

Open PHPMyAdmin
Select the database you want to import.
Go to the SQL Tab
At the bottom it will say “or location of the textfile” and browse to the file on your desktop.
Double Click on the file, so that the location shows the file address in the textbox.
Then Click “Go”

You will be notified once it has been uploaded and successfully completed.

Notes:

Please note that cross version MySQL transportation will be slightly different. For example if the server you are moving from has mysql version 4 and the server you are moving to has version 3.23 you will need to export the file in version 3.23 from your old server. So that the new server will be able to read the file, this is a common occurance when moving from Cpanel (MySQL 4+) to Plesk (MySQL 3.23).

Others in this Category

	Contents of Your Home Directory
	How do I transfer a domain?