{"id":397,"date":"2006-04-27T11:42:27","date_gmt":"2006-04-27T16:42:27","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=397"},"modified":"2006-04-27T11:45:20","modified_gmt":"2006-04-27T16:45:20","slug":"the-migration-bof","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2006\/04\/27\/the-migration-bof","title":{"rendered":"The Migration BoF"},"content":{"rendered":"<p><em>&#8220;No, you can&#8217;t run a Migration BoF, and it won&#8217;t make sense without a few of our migration experts,&#8221; he exclaimed with a petulant expression.<\/em><\/p>\n<p>Well, it turns out the migration BoF was actually quite good at the MySQL UC. It turns out, that everyone attending thought that it was a migration from 3.23 or 4 or 4.1 to MySQL 5. My understanding of this was that we&#8217;d actually prefer folk to come in from $database and figure they&#8217;d want to migrate to MySQL.<\/p>\n<p>And fair enough, the only experience I&#8217;ve had over time was migrating from Postgresql right to MySQL. But the idea of a BoF is to let everyone talk, share experiences, and so on. So a few resources we discussed, and I think were generally useful (and hopefully now, there will be more 5.0 users):<\/p>\n<ul>\n<li><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/upgrading-from-4-1.html\">Upgrading from MySQL 4.1 to 5.0<\/a> &#8211; from our great manual. Read it and take a gander to see if you&#8217;ll get affected.<\/li>\n<li><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/4.1\/en\/upgrading-from-3-23.html\">Upgrading from MySQL 3.23 to 4.0<\/a><\/li>\n<li><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/4.1\/en\/upgrading-from-4-0.html\">Upgrading from MySQL 4.0 to 4.1<\/a><\/li>\n<\/ul>\n<p>MySQL has always recommended incremental upgrades. And its always a good idea to <strong><em>backup<\/em><\/strong> your data before doing an upgrade.<\/p>\n<p>What I did want to discuss was the cool MySQL <a href=\"http:\/\/www.mysql.com\/products\/tools\/migration-toolkit\/\">Migration Toolkit<\/a>. It also has an <a href=\"http:\/\/dev.mysql.com\/doc\/migration-toolkit\/en\/index.html\">excellent manual entry<\/a>. But it seems that no one has really used it before, and I had to run away for another item&#8230; aka, the <a href=\"https:\/\/www.bytebot.net\/blog\/archives\/2006\/04\/27\/its-nearly-mothers-day-what-a-gift\">Quiz Show<\/a>. All in all, good Migration BoF, and thanks to everyone attending!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;No, you can&#8217;t run a Migration BoF, and it won&#8217;t make sense without a few of our migration experts,&#8221; he exclaimed with a petulant expression. Well, it turns out the migration BoF was actually quite good at the MySQL UC. It turns out, that everyone attending thought that it was a migration from 3.23 or [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[],"class_list":["post-397","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-6p","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=397"}],"version-history":[{"count":0,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/397\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}