How do I move my MySQL Databases?

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 World Wide Mart. Simply export your data on the old provider's server and import it on your account with the new host.


  • 66 Users Found This Useful
Was this answer helpful?

Related Articles

How long does it take to get my website online?

New account activation is completed within 24 hours follow receipt of your initial payment.  It...

Can you customize a package for me?

Due to the extremely low cost of our existing packages and services, we do not offer any...

What payment options do you accept?

We currently accept PayPal, Visa, MasterCard, American Express, and Discover.  We also accept all...

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

Account activation is typically done within 1-4 hours, but it can take upto 24 hours for the...

Do you register domain names?

World Wide Mart offers domain registration starting from $15.95 per year.  Domains can be...

Powered by WHMCompleteSolution