JBeckton
JBeckton

Reputation: 7111

How to move local MYSQL DB up to remote DB server

I have a local MYSQL DB running under WAMP that I need to move up to my production DB server. New to MySQL and need to know the best way to get this DB moved up.

Upvotes: 8

Views: 11455

Answers (3)

Rowno
Rowno

Reputation: 3394

Open up your database in phpMyAdmin and then select Export from the menu. Scroll down and select the Save as file checkbox and then press Go.

Now open up the database in phpMyAdmin on the production server (Note: you will need to create the database first) and then select Import from the menu. Browser to the file you saved and press Go.

If everything goes well you should now have a mirror image of your database on the production server! :)

Upvotes: 5

Macha
Macha

Reputation: 14664

Do you have phpmyadmin? (If you're not sure, type "http://localhost/phpmyadmin"). If you do, go to "Export on your local computer, and then upload that file on the "Import" section of the remote server. This is the absolute easiest way, and 90% of hosts have phpmyadmin installed.

If you don't, use the command line method suggested by ZeppLock.

Upvotes: 1

Zepplock
Zepplock

Reputation: 29175

you can run this on your current server:

mysqldump -u user -p database_name > dump.txt

and then do this on your new server:

mysql -u user -p database_name < dump.txt

Replace "user" with your username and "database_name" with a name of your database. You'll be prompted for a password in both cases

Note that second command will replace old tables in your new database

Upvotes: 15

Related Questions