erorr: copy database from 4.1 to 3.2

mikerh9

I did mysqldump on Mysql 4.1. I'm trying to insert the data into mysql-3.2. Receive the error message.

[root@localhost data]# /usr/bin/mysql -u mike -h localhost -phjlad pic < 123020040851pic.sql
ERROR 1064 at line 20: You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 13

devinemke

from the manual page for mysqldump concerning the "compatible" command line switch:

--compatible=name
Produce output that is compatible with other database systems or with older MySQL servers. The value of name can be ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, or no_field_options. To use several values, separate them by commas. These values have the same meaning as the corresponding options for setting the server SQL mode. See section 5.2.2 The Server SQL Mode. This option requires a server version of 4.1.0 or higher. With older servers, it does nothing.

mikerh9

Thanks.

It worked. Add this option to mysqldump

--compatible=mysql323