{"id":489,"date":"2003-06-08T22:29:24","date_gmt":"2003-06-09T03:29:24","guid":{"rendered":"http:\/\/www.ashleyit.com\/blogs\/brentashley\/?p=489"},"modified":"2003-06-08T22:29:24","modified_gmt":"2003-06-09T03:29:24","slug":"db-or-not-db-that-is-the-question","status":"publish","type":"post","link":"https:\/\/ashleyit.com\/blogs\/brentashley\/2003\/06\/08\/db-or-not-db-that-is-the-question\/","title":{"rendered":"db or not db? that is the question"},"content":{"rendered":"<p>When I recently moved my ashleyit.com site to <a href=\"http:\/\/www.imhosted.com\">imhosted<\/a>, I decided to upgrade Movable Type and move from Berkeley DB to MySQL.  I thought it would be easiest to simply export all my entries from the old system and import them into the new.<\/p>\n<p>This worked for a while until I realized that all my old posts were not where they were expected to be by external links and search engines.  It seems that export\/import doesn&#8217;t preserve post IDs &#8211; they just all get resequenced.<\/p>\n<p>Since I still have the old site at <a href=\"http:\/\/www.phpwebhosting.com\">PHPWebhosting<\/a>, I was able to grab the old  db files, bring them across, and get everything back to where it was, import the few entries I&#8217;ve done since the move, and I&#8217;m off to the races again.  I think I&#8217;ll just keep it on Berkeley DB at this point &#8211; MySQL just required an extra sql dump in my nightly backups anyhow.<\/p>\n<p>You&#8217;ll notice that indeed, I&#8217;m holding onto two hosting services.  I&#8217;m using mail from PHPWebhosting and web services from imhosted.  I can swap from one to the other at a moment&#8217;s notice because I keep my DNS at <a href-\"http:\/\/www.zoneedit.com\">ZoneEdit<\/a>, an ass-saver of <a href=\"http:\/\/www.skippingdot.net\/2003\/05\/31\"> great renown<\/a>.<\/p>\n<p>At 2 X US$9.95 per month, I have a total of a half a gig of storage, with redundant web and mail, two separate shell accounts, cron jobs, raw logs, you name it.<\/p>\n<p>And many corporations pay hundreds of dollars a month to have people host their low traffic brochure sites.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I recently moved my ashleyit.com site to imhosted, I decided to upgrade Movable Type and move from Berkeley DB to MySQL. I thought it would be easiest to simply export all my entries from the old system and import them into the new. This worked for a while until I realized that all my [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"activitypub_content_warning":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-489","post","type-post","status-publish","format-standard","hentry","category-blather"],"_links":{"self":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts\/489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/comments?post=489"}],"version-history":[{"count":0,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts\/489\/revisions"}],"wp:attachment":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/media?parent=489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/categories?post=489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/tags?post=489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}