Transferring Mysql databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
josboogz
Forum Newbie
Posts: 12
Joined: Thu Feb 06, 2003 5:05 am

Transferring Mysql databases

Post 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
craigh
Forum Newbie
Posts: 19
Joined: Sun May 19, 2002 2:50 pm

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