As noted in the title, I'm messing about a bit with InnoDB compressed tables. As such, I found a rather glaring hole in the Internet: how the hell do you turn compression off again? :-D
After messing about a lot and googling until my fingers hurt, I happened upon this bug report: http://bugs.mysql.com/bug.php?id=56628 So, you turn compression on a table off by: set session innodb_strict_mode=off; alter table YOURTABLEHERE engine=InnoDB row_format=compact key_block_size=0; Of course, if you're running 5.1.55+ or 5.5.9+, you'll not need to tinker with your innodb_strict_mode ; but it's still a glaring hole in the documentation. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
