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.

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

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! :)

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.