Problems with data import in different mysql versions: mysql version Data Import
The original mysql version is 3.4.10.1deb1, and the target mysql version is 5.0.51b-community-nt-log. The following error occurs during data import:
1. DELIMITER
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter // 'at line 1
Google: The description in [1] is correct. It says that DELIMITER is not a MySQL command and is related to the mysql client where you execute this sentence. I use PHPMYAdmin, the Client Version is 5.0.51a. It does not support the DELIMITER statement. Just change the client. The SQL file is imported on the command line interface and runs successfully. Conclusion: DELIMITER has nothing to do with the MySQL server version and is only related to the mysql client.
2. The B-tree structure is not supported.
#1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'using BTREE,
KEY 'authorid' ('authorid') using btree,
KEY 'dateline '('datel' at line 24
In fact, mysql does not support the B-tree index structure, but SQL syntax is incorrect. In the mysql statement of the target version, place the index items in the brackets behind them.
KEY 'authorid' ('authorid') USING BTREE
To [2]:
KEY 'authorid' using btree ('authorid ')
3. Innodb is not supported
The target mysql database does not support the Innodb engine, but the program must support transactions. Therefore, Innodb must be supported. The procedure is as follows:
Find the my. ini file, search for skip-innodb, delete the previous #, and 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
Reprinted Please note: kangrui tribe» problems with data import in different mysql versions