How do I move my MySQL Databases from old Host?

This can be used to back up a database or to move database information from one server to another.

1. Export A MySQL Database

This example shows you how to export a database. It is a good idea to export your data often as a backup.

# mysqldump username -ppassword database_name > FILE.sql



Replace username, password and database_name with your MySQL username, password and database name.

File FILE.sql now holds a backup of your database, download it to your computer.

2. Import A MySQL Database

Here, we import a database. Use this to restore data from a backup or to import from another MySQL server.

Start by uploading the FILE.sql file to the server where you will be running this command.

# mysql -u username -ppassword database_name < FILE.sql

Replace the parts in bold with your own information.

This powerful, easy to use command has many uses. Let's say you wanted to switch to HostNine. Simply export your data on the old provider's server and import it on your account with the new host.

Was this answer helpful?

 Print this Article

Also Read

What security measures are used to protect my server? Where can I report abuse and or spamming?

What security measures are used to protect my server? Where can I report abuse and or spamming?...

Do you offer a money-back guarantee?

Yes. All shared and reseller hosting services are covered by our hassle-free, 45 -Day money back...

Can Label Hosting transfer my website from my old provider?

Yes, LAbel Hosting will transfer all of your accounts from your previous provider completely free...

Is Label Hosting a reseller?

No. We have owned and operated our own servers since we opened. Our data center is located at...

How soon will my account be setup and ready to use?

Due to the high amount of fraud orders that we receive, we manually review every order before...

Powered by WHMCompleteSolution