Saturday, January 7, 2006

Moving mysql database

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.

Technorati Tags: ,