Problems with data import from different MySQL versions

The original version of MySQL is: 3.4.10.1deb1, the version of the target MySQL is: 5.0.51b-community-nt-log, import data when there is a problem:

1, DELIMITER

you has an error in your SQL syntax; check the manual That corresponds to your MySQL server version for the right syntax to use near ' DELIMITER//' in line 1

Google a bit, [1] The instructions are correct, it said, delimiter is not a MySQL command, with you to execute this sentence of the MySQL client, I use the phpMyAdmin, Its client version is: 5.0.51a, it does not support the delimiter statement, a different client can. The SQL file was imported with the command interface and was successfully run. Summary:delimiter is not relatedto the MySQL server version, only the MySQL client .

2. Btree structure is not supported

#1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-USING-BTREE,
KEY ' Authorid ' (' Authorid ') USING BTREE,
KEY ' Dateline ' (' Datel ' at line 24

In fact, not MySQL version does not support Btree index structure, but SQL syntax is not correct. The target version of the MySQL statement is to put the index entry in parentheses behind, all similar

KEY ' Authorid ' (' Authorid ') USING BTREE

The statement is modified to [2]:

KEY ' Authorid ' USING BTREE (' Authorid ')

3, does not support InnoDB

The target MySQL database does not support the InnoDB engine, but the program needs to support transactions, so it needs to support InnoDB. The procedure is as follows:

Locate the My.ini file, find the Skip-innodb, delete the previous #, save. Restart the MySQL service.

[1] Http://stackoverflow.com/questions/9017269/mysql-delimiter-syntax-error

[2] Http://www.xuyuanchi.com/thread-933-1-1.html

[3] Http://lxy.me/mysql-supports-innodb-storage-engine.html

Reprint Please specify: Kangrui tribe? Problems with data import from different MySQL versions

Problems with data import from different MySQL versions