Making a Copy of a Database

Cara menduplikasi database mysql

shell> mysqldump db1 > dump.sql
shell> mysqladmin create db2
shell> mysql db2 < dump.sql

source : https://dev.mysql.com/doc/refman/5.6/en/mysqldump-copying-database.html