Copy/Duplicate MySQL Database
Hi! The Tutorial shows you Step-by-Step How to Easy Copy/Duplicate a MySQL Database on Linux/Unix Systems.
-
Open Command Line Session or Login into Shell.
-
Create a New DB.
mysql -u root -p[pass]
CREATE DATABASE mydb2;
quit
-
BackUp Existing DB.
mysqldump -uroot -p[pass] mydb > /home/myuser/mydb.sql
-
Load BackUp into New DB.
mysql -uroot -p[pass] mydb2 < /home/myuser/mydb.sql
How to Install the Latest MySQL 5.7+ Server on Linux