salts   sailing

 
Enter what you want to search for, to search for an "exact phrase" by enclosing it in quotes. You may search for a combination of words and phrases

en

Learn more about our "How to Tie Knots" DVD/CD
December 15th 2017 - 04:06
August 25th, 2008
August 25th, 2008

Oh My Gotcha!

For anyone considering an upgrade to MySQL 5.1 BEWARE BEWARE BEWARE I just spent the morning working with a web host who also spent the night after what should have been a simple upgrade completely fried several databases! We did find the workaround though...

It seems that if you upgrade MySQL from versions < 5.0.62 to 5.1 the process will cause some tables to get corrupted (sometimes many will work - some will some wont) and then not allow them to be repaired. Considering that this isnīt something one would expect from an upgrade (especially from software like MySQL that has such a great track record) it came as quite a shock.

The error that appeared was Incorrect key file for table ī.....ī; try to repair it which basically just means that the file is corrupt.

How To Fix It?
If youīre reading this BEFORE you upgrade then the key is to take a database extract before upgrading the server, upgrade the server, and then reload the data.

If youīre reading this AFTER your upgrade and facing this exact problem - you can save your data! Install a copy of MySQL 5.0.62 somewhere - copy all the mysql files over to that database and then do an extract (mysqldump) from there. You can then reload this dumpfile into the 5.1 instance and everything should work (it did for us anyway)

... Sorry if this got a bit technical for those that normally read this blog but this seems such a major issue I wanted to be sure everyone knew About it.

Share this:
No Comments
i
You must login or register to post comments Login/Signup
RSS feed Feed Description
Subscribe to the complete The Bosunīs Mate News RSS news feedAll News RSS feed Complete RSS feed
Subscribe to the The Bosunīs Mate News RSS news feed for this category onlyBosunīs Log RSS feed for: Bosunīs Log
A Rich Site Summary (RSS) feed is an xml data file that provides a summary of the information contained here. It is not designed to be viewed in your browser, but instead by rss reader software. If you do not know what this means - you can safely ignore it, as it is provided for advanced users with rss reader software only.

wooden boats
Copyright © 1987-2017 The Bosun's Mate