{"id":71,"date":"2009-12-21T20:49:42","date_gmt":"2009-12-22T00:49:42","guid":{"rendered":"http:\/\/main.jmah.net\/?p=71"},"modified":"2009-12-21T20:54:02","modified_gmt":"2009-12-22T00:54:02","slug":"migrating-mysql-from-v4-to-v5","status":"publish","type":"post","link":"https:\/\/main.jmah.net\/?p=71","title":{"rendered":"Migrating MySQL from v4 to v5"},"content":{"rendered":"<p><a href=\"http:\/\/main.jmah.net\/wp-content\/uploads\/2009\/12\/phpmyadmin.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-72 alignleft\" title=\"phpmyadmin\" src=\"http:\/\/main.jmah.net\/wp-content\/uploads\/2009\/12\/phpmyadmin-300x216.jpg\" alt=\"\" width=\"300\" height=\"216\" srcset=\"https:\/\/main.jmah.net\/wp-content\/uploads\/2009\/12\/phpmyadmin-300x216.jpg 300w, https:\/\/main.jmah.net\/wp-content\/uploads\/2009\/12\/phpmyadmin.jpg 1024w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>Two key things about migrating your site from MySQL v4 to v5<\/p>\n<p>(1) In oder to preserve the unicode encoding of foreign characters, make sure that the v5 database was created with DEFAULT CHARACTER SET utf8 and COLLATE utf8_general_ci (or altered to the above properties after creation) <strong>before <\/strong>re-creating the tables and restoring the data.<\/p>\n<p>(2) Use plug-ins to backup and restore data instead of using the Export function of phpmyadmin; funny characters can appear if using the latter method\u00a0for migrating data from MySQL v4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Two key things about migrating your site from MySQL v4 to v5 (1) In oder to preserve the unicode encoding of foreign characters, make sure that the v5 database was created with DEFAULT CHARACTER SET utf8 and COLLATE utf8_general_ci (or &hellip; <a href=\"https:\/\/main.jmah.net\/?p=71\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-research-information-technology"],"_links":{"self":[{"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/main.jmah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":5,"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":74,"href":"https:\/\/main.jmah.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/74"}],"wp:attachment":[{"href":"https:\/\/main.jmah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/main.jmah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/main.jmah.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}