{"id":682,"date":"2006-12-28T12:10:14","date_gmt":"2006-12-28T10:10:14","guid":{"rendered":"http:\/\/www.rare-it.com\/blog\/index.php\/2006\/12\/28\/server-update-update\/"},"modified":"2006-12-28T12:10:14","modified_gmt":"2006-12-28T10:10:14","slug":"server-update-update","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2006\/12\/server-update-update\/","title":{"rendered":"Server update: update"},"content":{"rendered":"<p><a href=\"\/gallery\">Gallery<\/a> seems to be in working order again. I made an MySQL export in Windows before I took the plunge and installed Ubuntu. After importing the whole Gallery-database, the application did not recognize the data and said that it was not installed, or it just gave a big fat error. So I dropped the database, created the database with the installer from Gallery (empty) and though: now let&#8217;s import the data. And after numerous &#8220;table not found&#8221; errors in MySQL I saw what had happened. Windows does not care about case in filenames. So creating a database-table in MySQL results in a file in small-characters. When running Linux (or some other case-sensitive OS) size matters. So I dropped the empty database, imported my backup, and manually renamed the tables to proper casing. Pffew&#8230;that worked. I only had to recreate all thumbnails, and that was it. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gallery seems to be in working order again. I made an MySQL export in Windows before I took the plunge and installed Ubuntu. After importing the whole Gallery-database, the application did not recognize the data and said that it was not installed, or it just gave a big fat error. So I dropped the database, <a href='https:\/\/www.switchbl8.nl\/blog\/2006\/12\/server-update-update\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-682","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=682"}],"version-history":[{"count":0,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/682\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}