MySQL 9.0 Release Notes
$> mysqldump db1 > dump.sql
$> mysqladmin create db2
$> 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.