Re: Mysql 4.1.12 to 4.0.26

[Bill Karwin]

Most likely the 4.1 backup contains CHARACTER SET and COLLATE clauses in the CREATE TABLE statements, and these clauses are not recognized by 4.0. MySQL 4.1 introduced a lot of support for character sets that wasn't there in earlier versions.

The mysqldump tool, which is typically the tool used for creating backups, has some options for controlling the format of output, and some of these options can omit the clauses that aren't supported in earlier versions.

For instance:
--compatible=mysql40

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

Regards,
Bill K.