MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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.