Mega Code Archive

 

Categories / MySQL Tutorial / MySQL Utilities

 

To make a copy of live data

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