1.4.5.2 Copy a Database from one Server to Another

On Server 1:

shell> mysqldump --databases db1 > dump.sql

Copy the dump file from Server 1 to Server 2.

On Server 2:

shell> mysql < dump.sql

Use of --databases with the
mysqldump command line causes the dump file
to include CREATE DATABASE and
USE statements that create the
database if it does exist and make it the default database for
the reloaded data.

Alternatively, you can omit
--databases from the
mysqldump command. Then you will need to
create the database on Server 2 (if necessary) and specify it
as the default database when you reload the dump file.

On Server 1:

shell> mysqldump db1 > dump.sql

On Server 2:

shell> mysqladmin create db1
shell> mysql db1 < dump.sql

You can specify a different database name in this case, so
omitting --databases from
the mysqldump command enables you to dump
data from one database and load it into another.

note that on a multi-user system you will NOT want to put in the passwords as shown because anyone on the system will be able to see them. in that case you can use the following, less convenient command. it will ask you for your password twice, once for the local server and once for the remote server: