{"id":888,"date":"2014-12-20T15:44:15","date_gmt":"2014-12-20T15:44:15","guid":{"rendered":"https:\/\/fir3netwp.gmsrrpobkbd.com\/2014\/12\/20\/how-do-i-export-and-import-a-mysql-database\/"},"modified":"2021-07-24T17:04:46","modified_gmt":"2021-07-24T17:04:46","slug":"how-do-i-export-and-import-a-mysql-database","status":"publish","type":"post","link":"https:\/\/www.fir3net.com\/Databases\/Mysql\/how-do-i-export-and-import-a-mysql-database.html","title":{"rendered":"How do I Export and Import a MySQL Database ?"},"content":{"rendered":"
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.<\/p>\n
Note<\/strong> : This article is meant as a reference point rather then a full blown article.<\/p>\n 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 … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[60],"tags":[],"yoast_head":"\nExport<\/h2>\n
mysqldump -u root -p {database} > db.sql<\/pre>\n
Import<\/h2>\n
mysql -u root -p -h 127.0.0.1 {database} < db.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"