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

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

User, date Message
Written by TheEdge
4 years ago
Category: Feature discussion
15 posts since Thu, 07 Oct 10
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.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
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.