The default Mysql version on a Red Hat 9 was version 3, the default Mysql version on RHEL 4 (or Centos in my case) is version 4. Obviously, using a
mysqldumpon my (new) development machine and importing it on my (now) production machine fails. I resulted in dumping the table structures with mysqldump and writing a perl script to generate generic SQL statements.