{"id":4106,"date":"2015-01-16T10:55:01","date_gmt":"2015-01-16T02:55:01","guid":{"rendered":"http:\/\/rmohan.com\/?p=4106"},"modified":"2015-01-16T10:55:01","modified_gmt":"2015-01-16T02:55:01","slug":"how-to-clone-a-mysql-database","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=4106","title":{"rendered":"How to clone a MySQL database"},"content":{"rendered":"<p>Below shows your the steps needed to clone a MySQL database.<\/p>\n<p class=\"codemulti\">mysqladmin create [new db name] -u [username] &#8211;password=[password] &amp;&amp; \\<br \/>\nmysqldump -u [username] &#8212;password=[password] [old db name] | mysql -u\u00a0[username] &#8211;password=[password] -h [host] [new db name]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below shows your the steps needed to clone a MySQL database.<\/p>\n<p class=\"codemulti\">mysqladmin create [new db name] -u [username] &#8211;password=[password] &amp;&amp; \\ mysqldump -u [username] &#8212;password=[password] [old db name] | mysql -u [username] &#8211;password=[password] -h [host] [new db name]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4106"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4106"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4106\/revisions"}],"predecessor-version":[{"id":4108,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4106\/revisions\/4108"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}