{"id":106,"date":"2008-10-19T01:35:58","date_gmt":"2008-10-19T01:35:58","guid":{"rendered":"https:\/\/kristau.net\/blog\/?p=106"},"modified":"2008-10-19T01:35:58","modified_gmt":"2008-10-19T01:35:58","slug":"demo-fail-but-recipants-go","status":"publish","type":"post","link":"https:\/\/kristau.net\/blog\/106\/","title":{"rendered":"Demo FAIL, but ReciPants GO"},"content":{"rendered":"<p>Well, my demo of the Linux Gamers Live <span class=\"caps\">DVD<\/span> didn\u2019t go so well.  My crappy old computer did not perform very well, so we ended up borrowing someone\u2019s laptop to perform the demo.  Wasn\u2019t too exciting.  I just brought up each game on the disk and played them for a bit.  We also discussed some other Linux-friendly gaming.<\/p>\n<p>After that <span class=\"caps\">FAIL<\/span>, I needed some success.  I finally got some relief with the ReciPants database issue.  The problem seems to be with my method for transferring the database from the old server to the new.  Here\u2019s a brief synopsis of what I did to get it to work:<\/p>\n<p>Migrated from the old server (with MySQL 3.23) to a virtual machine running CentOS 3 (also with MySQL 3.23).<\/p>\n<p>On the old server:<\/p>\n<ul>\n<li>Exported the database with the following command (no extra options used, my mistake was exporting with \u2014opt and\/or \u2014add-drop-tables):<\/li>\n<\/ul>\n<p><strong>mysqldump -u root -p ReciPants &gt; ReciPants-database.sql<\/strong><\/p>\n<p>On the \u201cnew\u201d server:<\/p>\n<ul>\n<li>Set up ReciPants v1.2 on the new server, per the Web site instructions \u2014 including running the <span class=\"caps\">SQL<\/span> scripts tables-mysql.sql and ref_data.sql.<\/li>\n<li>Once I confirmed that worked OK, restored the data from the old<br \/>\nserver with the following command (the -f is necessary, as there is a<br \/>\nnon-critical error early on that will halt the process):<\/li>\n<\/ul>\n<p><strong>mysql -u root -p -f ReciPants &lt; ReciPants-database.sql<\/strong><\/p>\n<p>Again, I need to test the above method on MySQL 5.x, but I believe it will work just fine.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well, my demo of the Linux Gamers Live DVD didn\u2019t go so well. My crappy old computer did not perform very well, so we ended up borrowing someone\u2019s laptop to perform the demo. Wasn\u2019t too exciting. I just brought up each game on the disk and played them for a bit. We also discussed some [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,6,7],"tags":[244,160,171,195],"class_list":["post-106","post","type-post","status-publish","format-standard","hentry","category-linux","category-site-news","category-technology","tag-linux","tag-recipants","tag-script","tag-technology-2"],"_links":{"self":[{"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/posts\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":0,"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/posts\/106\/revisions"}],"wp:attachment":[{"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/media?parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/categories?post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kristau.net\/blog\/wp-json\/wp\/v2\/tags?post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}