Clone a database in MySQL

Clone the database World to world_bkp in MySQL database Server

1. Check the database present in MySQL

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |

| sys                |
| world              |
+--------------------+
5 rows in set (0.01 sec)

2. Backup the World database

C:\Program Files\MySQL\bin>mysqldump -u root -p  world > c:\world.sql
Enter password: *********

3. Create a World_BKP database in MySQL server

C:\Program Files\MySQL\bin>mysqladmin -u root -p create world_bkp
Enter password: *********

4. Restore the world_bkp database in MySQL Server.

C:\Program Files\MySQL\bin>mysql -u root -p world_bkp < c:\d\world.sql
Enter password: *********
Table   Op      Msg_type        Msg_text
world_bkp.city  histogram       status  Histogram statistics created for column 'Name'.
Table   Op      Msg_type        Msg_text
world_bkp.city  histogram       status  Histogram statistics created for column 'District'.

5. Verify the backup restore.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+

| information_schema |
| mysql              |
| performance_schema |

| sys                |
| world              |
| world_bkp          |
+--------------------+
6 rows in set (0.00 sec)

mysql> use world
Database changed
mysql> select count(*) from city;
+----------+
| count(*) |
+----------+
|     4079 |
+----------+
1 row in set (0.00 sec)

mysql> use world_bkp
Database changed
mysql> select count(*) from city;
+----------+
| count(*) |
+----------+
|     4079 |
+----------+
1 row in set (0.00 sec)