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: ,

No comments:

Post a Comment

Unlocking Raspberry Pi Potential: Navigating Network Booting Challenges for Enhanced Performance and Reliability

I've set up several Raspberry Pis around our house for various projects, but one recurring challenge is the potential for SD card failur...