MySQL Problem: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted;

I was dumping and importing MySQL databases between my production server which had MySQL 5.0.95  and my test server which had MySQL 5.1.61 and was getting the error “Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted;” on the test server with the copied over database.

To make a long story short apparently there is some bug in MySQL that causes this rather cryptic error when moving a database created by 5.0 to 5.1. To fix this problem you need to run the following command as root (or use sudo) on the server you have migrated the database.

mysql_upgrade --force -uroot -p [your mysql root password]

You have to use the –force option or else the upgrade won’t fix the problem. I hope this saves someone a little time.

Pio Cesare Grignolino del Monferrato Casalese 2009

I am a bit of a sucker for new things (at the supermarket if it say “new” I will buy it). On this basis I bought a bottle of Pio Cesare Grignolino del Monferrato Casalese 2009. I of course had never heard of Grignolino before (who has), but what the heck I thought why not try this wine. Price is usually a very good indication of quality (unfortunately) and at $30 I thought it should be drinkable. I am glad I took the risk as the wine is very,very drinkable. It is rather difficult to describe (Grignolino is apparently a rather rare, but distinctive Italian wine according to my google research), but I guess the closest would be to say it can fill the role of a pinot while being different. If you are looking for a medium bodied, yet robust, wine that can pair up well with food then this is something to try. If I had to sum it up  in one word then that word would be yum. I will certainly be buying more.

Price $30

Value $45

Edit. Dan Murphys has dropped the price on this down to $19.90 so it is even better value than before.