How to clone a MySQL database

 Below shows your the steps needed to clone a MySQL database.

mysqladmin create [new db name] -u [username] –password=[password] && \
mysqldump -u [username] —password=[password] [old db name] | mysql -u [username] –password=[password] -h [host] [new db name]

Rick Donato

Want to become a database expert?

Here is our hand-picked selection of the best courses you can find online:
Ultimate MySQL Bootcamp
Complete SQL Bootcamp
MongoDB Complete Developer course
and our recommended certification practice exams:
AlphaPrep Practice Tests - Free Trial