MySQL 8.4 Release Notes
9.4.5.1 复制数据库
$> 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.