How to get a database backup copy from msyql 5 server to install on mysql 4 server?

[blackhorse]

I am running mysql 5 and have to transfer a database to a msyql 4 server. So I run mysqldump on mysql 5 and get the .sql file and upload to that mysql 4 server, I run into syntax error on mysql 4 when I try to create the tables and input the data for the tables from mysql 5 .sql text fiel.

So how can I get the mysqldump file from mysql 5 and can be run at mysql 4 server?

Thanks!

[nemonoman]

MySqlDump has a compatiblity option:
--compatible=mysql40

Produce output that is more 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.1.6, “SQL Modes”.

This option does not guarantee compatibility with other servers. It only enables those SQL mode values that are currently available for making dump output more compatible. For example, --compatible=oracle does not map data types to Oracle types or use Oracle comment syntax.

This option requires a server version of 4.1.0 or higher. With older servers, it does nothing.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html