Cristian Livadaru's blog

... think again ...

Compatible=mysql40, or How to Screw Your Database in 2 Easy Steps

Yes once again I had nothing better to do then move servers, fuck and today it wasn’t even raining.
Ok I came across a lot of problems as usual, one was that I decided not to use debian testing anymore, I wanted only stable !
One of the problems was that stable had mysql4.0 and my old database was 4.1 and of course there where problems while trying to import the database, but hey, there is a nice parameter –compatible=mysql40 sounds like exactly what I needed …
After I finished the server almost I found out what “compatible” means for the sickheads who implemented this parameter.
“compatible” means that this line:
`object_id` int(11) NOT NULL auto_increment,
will be transformed into this:
`object_id` int(11) NOT NULL default ’0′,

notice the little difference ? arggggg!