distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

TheEdge posted 4 years ago in Feature discussion
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 posted 4 years ago
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.