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...

Festus Tamakloe · Accepted Answer · 2012-11-15 11:39:47Z

1

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

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

For more info

answered Nov 15, 2012 at 11:39

Festus Tamakloe

11.3k9 gold badges55 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Erik Ekman · Accepted Answer · 2012-11-15 11:40:00Z

1

Try something like this:

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

Then to import it:

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

answered Nov 15, 2012 at 11:40

Erik Ekman

2,08612 silver badges13 bronze badges