moving mysql database

[Anon]

I wish to copy the mysql database from one computer to another. How can i do a dump of the database and then recreate it on the other computer?

Jamie

[Anon]

You have two options:

1. Use the mysqldump utility. This program
   that comes with the mysql distributions generate the sql for replicate your database.
   You can redirect the output of the program
   to a file. After make this, you execute
   the sql file generated by mysqldump on the
   other database.

[msource]$ mysqldump .... database > pepe.sql
[dest]$ mysql .... < pepe.sql

2. Stopping the database and copy the files
   of your database to the another database.
   Look at the exactly directory on the variables of mysql.

bye and good luck.

[Anon]

i hope this doesn't sound to much like a self plug but i just recently wrote a mysqldump tutorial :

http://www.theprojects.org/tutorials/mysqldump.php

hope that helps. includes a few useful resources.

philip

[Anon]

I believe that either method will require you to create entries in your user, db and host tables depending on how you've set up security.

It may just be most convenient to tar up the database directory and copy it to the target machine.

[Anon]

I tried tar of files in old directory, copy to new machine, making same name directory and untar, but when I log in to the DB and issue commands:

use database_name;
I get an error
Didn't find any fields in table 'database_name'

and after that I uissue
select * from table_name;
I get
ERROR 1033: Incorrect information in file: './database_name/table_name.frm'

[polson]

don't touch the files, use mysqldump instead.