shell>mysqldump db1 > dump.sql
shell>mysqladmin create db2
shell>mysql db2 < dump.sql
Do not use --databases
on
the mysqldump command line because that
causes USE db1
to be included in the dump
file, which overrides the effect of naming
db2
on the mysql command
line.
User Comments
Add your own comment.