How to copy a MySQL database from one computer to another?

Question

Does anyone know of an easy way to copy a database from one computer to a file, and then import it on another computer?

I heard about "mysqldump" but i don't know how to use it and where the command to write. My database name is "lbry" username is "root".

please help me to find the solution...

Answer 1

Try something like this:

mysqldump -u root -p lbry > dump-lbry.sql

Then to import it:

mysql -u root -p < dump-lbry.sql

Answer 2

This best and the easy way is to use a db tools(SQLyog)

http://www.webyog.com/product/downloads

With this tools you can connect the 2 databases servers and just copy one database on server a to server b.

For more info

http://faq.webyog.com/content/12/32/en/mysql-5-objects-are-greyed-out-in-copy-db-to-other-host-dialogue.html