January 2015
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

Categories

January 2015
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

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]

How do I Export and Import a MySQL Database ?

There are times during migrations, database restores etc that you will need to export and import your MySQL database. Below shows you the commands required to achieved this.

Note : This article is meant as a reference point rather then a full blown article.

EXPORT mysqldump -u root -p {database} > db.sql IMPORT mysql -u […]