Re: Migrating MySQL 5.0.x to 5.1.x

2010-05-20 Thread Sam Sharpe
On 20 May 2010 07:26, Kevin J. Cummings wrote: > On 05/20/2010 02:11 AM, Sam Sharpe wrote: >> On 20 May 2010 05:24, Kevin J. Cummings wrote: >>> Incorrect key file for table 'host'; try to repair it >> >> 1) backup a copy of /var/lib/mysql/mysql/ >> 2) myisamchk -r /var/lib/mysql/mysql/*.MYI >> 3

Re: Migrating MySQL 5.0.x to 5.1.x

2010-05-19 Thread Kevin J. Cummings
On 05/20/2010 02:11 AM, Sam Sharpe wrote: > On 20 May 2010 05:24, Kevin J. Cummings wrote: >> Incorrect key file for table 'host'; try to repair it > > 1) backup a copy of /var/lib/mysql/mysql/ cp -R /var/lib/mysql/mysql /var/lib/mysql/mysql.bak > 2) myisamchk -r /var/lib/mysql/mysql/*.MYI > -

Re: Migrating MySQL 5.0.x to 5.1.x

2010-05-19 Thread Sam Sharpe
On 20 May 2010 05:24, Kevin J. Cummings wrote: > Incorrect key file for table 'host'; try to repair it 1) backup a copy of /var/lib/mysql/mysql/ 2) myisamchk -r /var/lib/mysql/mysql/*.MYI 3) try starting MySQL assuming it now starts, then run mysql_upgrade -- Sam -- users mailing list users@l

Migrating MySQL 5.0.x to 5.1.x

2010-05-19 Thread Kevin J. Cummings
I just upgraded my F10 server to F11. [long story, it was via a preupgrade to F13, and somehow *some* F11 packages got installed instead of F13, but my rpmfusion stuff got upgraded to rawhide, and my atrpms got upgraded to F13 and F12! so I fixed those and finished the package upgrades from what