How to Copy/Duplicate A MySQL Database on Linux-Unix Step-by-Step Easy Guide

Copy/Duplicate MySQL Database

Hi! The Tutorial shows you Step-by-Step How to Easy Copy/Duplicate a MySQL Database on Linux/Unix Systems.

1. Open Command Line Session or Login into Shell.

2. Create a New DB.

   mysql -u root -p[pass]

    CREATE DATABASE mydb2;

    quit

3. BackUp Existing DB.

   mysqldump -uroot -p[pass] mydb > /home/myuser/mydb.sql

How to Install the Latest MySQL 5.7+ Server on Linux

MySQL 5.7.X Quick Start for Linux
MySQL for Linux

4. Load BackUp into New DB.

   mysql -uroot -p[pass] mydb2 < /home/myuser/mydb.sql