{"id":121,"date":"2018-03-02T17:43:22","date_gmt":"2018-03-02T17:43:22","guid":{"rendered":"http:\/\/www.darmain.co.uk\/wordpresser\/?p=121"},"modified":"2018-03-02T18:04:37","modified_gmt":"2018-03-02T18:04:37","slug":"server-cloning","status":"publish","type":"post","link":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/2018\/03\/02\/server-cloning\/","title":{"rendered":"Server cloning"},"content":{"rendered":"<p>Todays success was to figure out how to clone the WP database from the live server to the backup server.\u00a0 Two parts required.\u00a0 First copy the document folder tree over, which is easily down through SAMBA, although I do have to go and change file ownership afterwards.\u00a0 Second is dump the SQL database out the front end machine and then write it back into the backup machine.\u00a0 I use &#8220;mySQL workbench&#8221; to watch the database before and after migration.\u00a0 Then checked record counts and sampled content.\u00a0 It all worked.\u00a0 Finally I switched the website serving duty over from the main server to the backup server, and it all worked.\u00a0 No one would know.\u00a0 Results!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Todays success was to figure out how to clone the WP database from the live server to the backup server.\u00a0 Two parts required.\u00a0 First copy the document folder tree over, which is easily down through SAMBA, although I do have to go and change file ownership afterwards.\u00a0 Second is dump the SQL database out the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-websitedesign"],"_links":{"self":[{"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":2,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":123,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/posts\/121\/revisions\/123"}],"wp:attachment":[{"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darmain.co.uk\/darmainworld\/index.php\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}