Page 1 of 1

Transferring Mysql databases

Posted: Mon Mar 17, 2003 3:24 pm
by josboogz
Hi all,

Just a quick question, i have a mysql database running on a machine at home. I was wondering is it possible to transfer the databases and their contents onto another machine without the use of sql scripts? For example is it possible to find the files that hold the information adn just simply copy and paste them into the right directory on the other machine?

If not what possible ways are there for transfering the information.

Thanks for your time,


Jos

Posted: Mon Mar 17, 2003 3:55 pm
by craigh
It is easier to use mysqldump from the command line to do that all in one step. go to a command line and type man mysqldump and follow the directions.