{"id":2497,"date":"2005-04-27T03:28:55","date_gmt":"2005-04-27T03:28:55","guid":{"rendered":"http:\/\/www.soulhuntre.com\/items\/date\/2005\/04\/27\/update-mysql-database-structures-tasty\/"},"modified":"2005-04-27T03:28:55","modified_gmt":"2005-04-27T03:28:55","slug":"update-mysql-database-structures-tasty","status":"publish","type":"post","link":"http:\/\/legacyiamsenseiken.local\/2005\/04\/27\/update-mysql-database-structures-tasty\/","title":{"rendered":"Update MySQL database structures? Tasty!"},"content":{"rendered":"<p>So your developing, and you have to alter a database structure to match from one versiont o another. You want to automate this process&#8230;. but how?<\/p>\n<p><a href=\"http:\/\/www.mysqldiff.org\/\">MySQLdiff<\/a> to the rescue: <\/p>\n<blockquote>\n<p>&#8220;MySQLdiff is a little Tool to detect layout differences between two databases.<\/p>\n<p>Almost every developer knows the that changes of the database on the developement system have to be logged in order to update the live-system later on.<\/p>\n<p>To make this easier the tool MySQLdiff has been developed. Not as a real project but &#8230;<\/p>\n<p>MySQLdiff will create a SQL-ALTER-Script which has to be run onto the live-system to &#8216;patch&#8217; it to the state of the developement system. &#8220;<\/p>\n<\/blockquote>\n<p>I might be in love.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So your developing, and you have to alter a database structure to match from one versiont o another. You want to automate this process&#8230;. but how? MySQLdiff to the rescue: &#8220;MySQLdiff is a little Tool to detect layout differences between two databases. Almost every developer knows the that changes of the database on the developement [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":53203,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[278],"tags":[],"_links":{"self":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts\/2497"}],"collection":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/comments?post=2497"}],"version-history":[{"count":0,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/posts\/2497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/media\/53203"}],"wp:attachment":[{"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/media?parent=2497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/categories?post=2497"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/legacyiamsenseiken.local\/wp-json\/wp\/v2\/tags?post=2497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}