7.4.5.1. Making a Copy of a Database

shell> mysqldump db1 > dump.sqlshell> mysqladmin create db2shell> 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.