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]

About the Author


R Donato

Rick Donato is the Founder and Chief Editor of He currently works as an SDN/NFV Solutions Architect and has a keen interest in automation and the cloud.

You can find Rick on Twitter @f3lix001