In the process of moving to a Fedora Core 2 server, I have had to move some databases from one machine to another. At first, I tried to just copy the database files, and then restart mysql. This didn't work. I then realized that Fedora Core 2 has version 3.23 of mysql, while Fedora Core 4 has version 4.1.
I then tried to run mysqldump, and then run that .sql file on Fedora Core 2, but I kept getting messages like this:
ERROR 1064 at line 21: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 11
I was able to work around this by removing the "ENGINE=MyISAM DEFAULT CHARSET=latin1" string from each of the CREATE TABLE commands. I knew that this wouldn't cause a problem since in mysql version 3.23 and later MyISAM was the default engine type.