MySQL Help

canuck_barlow · 03-14-2005, 11:33 PM

How do I copy a MySQL DB on one computer to another?

(This is probably a really easy question but I'm having some difficulty)

trickykid · 03-14-2005, 11:38 PM

Easiest way is to use mysqldump...

Boby · 03-15-2005, 12:24 AM

MySQL online documentation

Backup your existing database
read

Code:

mysqldump --opt db_name > backup-file.sql

or if you want to compress it to an archive go with this command:

Code:

mysqldump --opt -u user --password="password"
database | bzip2 -c > database.sql.bz2

Copy MySQL database to another computer
read

Code:

mysqladmin create db_name
cat DUMPDIR/*.sql | mysql db_name

Good luck!
Boby