MySQL 5.5: type=InnoDB to ENGINE=InnoDB

[proctozont]

MySQL 5.5 doesn't support "type" table option, instead it uses ENGINE option.

Below shell script to change schema/mysql.sql to newer format.

[COLOR=#000000]sed 's/type=InnoDB/ENGINE=InnoDB/g' schema/mysql.sql > /tmp/mysql.sql
rm schema/mysql.sql
cp /tmp/mysql.sql schema/mysql.sql
[/COLOR]

[Alexei]

It is already fixed in pre 1.8.3.

[0siris]

and yet I am facing this right now, in zabbix-1.8.5.tar.gz:

 grep type=InnoDB ./upgrades/dbpatches/1.6/mysql/patch.sql | sort | uniq
) type=InnoDB;

updatescripts now run without problems (both the 1.6 updatescript and the 1.8 updatescript)

[richlv]

oh. well, it was only fixed for schema
changing that for upgrade scripts should be discussed - could you please create a new issue in the tracker ? thanks.

[0siris]

Done.
... filling this post to meet 10 char quota