MySQL Utilities MySQL Tutorial

To do this you would need to duplicate a local database.
First create the duplicate database:

mysql> CREATE DATABASE myDatabase2;
We can copy the tables from the first table into the second.

c:\mysql\bin\mysqldump -u root -p myDatabase | mysql -u backup -p MyPassword myDatabase2