{"id":91,"date":"2005-05-02T14:26:54","date_gmt":"2005-05-02T17:26:54","guid":{"rendered":"http:\/\/www.hoogervorst.ca\/arthur\/?p=91"},"modified":"2005-05-02T20:05:31","modified_gmt":"2005-05-02T23:05:31","slug":"importing-old-data","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=91","title":{"rendered":"Importing old data"},"content":{"rendered":"<p><span class=\"dropcap\">A<\/span>lfons managed to export existing WordPress data, which I imported over here this very  morning.\n<\/p>\n<p>What I basically did was updating (update set&#8230;. wp_posts\/post2cat etc.) the IDs of posts and post2cat tables with the latest known entry of the dyndns site (select max(id) from wp_posts) and add this number to the IDs of the entries in the hoogervorst.ca database. Then I dumped the hoogervorst.ca database and copied the data from the dyndns site into this dump. That&#8217;s it.\n<\/p>\n<p>I ran into a one minor problem: a dreaded 1064 MySQL error, which I traced back to non-well formed dumps generated by phpMySQLadmin (which more or less has to do with the php_magic_quotes setting): these dumps did not escape characters correctly. I jumped back to plan B (let mysqldump do the dumping), scp-ed it to the laptop, ran the tests and script on an exact copy of this site on Elsie (The Debian serve). I saw it was good and ultimately ran it in a Dreamhost SSH session.\n<\/p>\n<p>As said, nothing really hard: it&#8217;s fun to do it in MySQL, instead of the usual Postgres affairs I do as part of my daily job.\n<\/p>\n<p><small>Update 1: Most images should be accessible once again. Also, I did not merge the latest &#8216;Elsewhere&#8217; links.<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Alfons managed to export existing WordPress data, which I imported over here this very morning. What I basically did was updating (update set&#8230;. wp_posts\/post2cat etc.) the IDs of posts and post2cat tables with the latest known entry of the dyndns &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=91\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[12],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/91"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}