Export to target a particular version mySQL version....

[expired user #5214]'s profile image [expired user #5214] posted 13 years ago in Feature discussion Permalink
G'Day,

It would be nice if you were exporting from a MySQL 5.5 database for import into a 4.x database and were able to specify a compatibility level for the export.

Currently exporting from a mySQL 5.5 and importing to a 4.1 database does not work, without modifying the script.
ansgar's profile image ansgar posted 13 years ago Permalink
What exactly fails, with which error message? I think all version specific queries are exported in conditional comments, such as this one:
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

But probably I have overseen one or two queries which also need that.

Please login to leave a reply, or register at first.