| 26. 4. 7. 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
|
|