MySQL :: MySQL Backup and Recovery :: 1.4.5.1 Making a Copy of a Database

5.7

MySQL Backup and Recovery / ... / Making a Copy of a Database

1.4.5.1 Making a Copy of a Database

$> 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.

PREV HOME UP NEXT