[clug] Fedora 11 problem: mysql

[Eyal Lebedinsky]

So far I made no progress.

I should say that am happy to start the mysql setup from scratch.
I will then copy my mythtv database from the about-to-retire server.

BTW, I do have backups but this did not help. I restored the 'mysql'
database and got the same errors. Moreover, I could see that my mythtv db
also gives many similar errors for some tables.

Bringing up the server with --skip-grant allows me to access this db but
a 'repair table' fails just the same. It does not repair it.

There must be some issue between the two versions of mysql (F10 vs. F11).

Eyal

Daniel Pittman wrote:
> Eyal Lebedinsky <eyal at eyal.emu.id.au> writes:
> 
>> I ran myisamchk on all the tables (*.MYI) and it reported errors only in
>> user.MYI
> 
> [...]
> 
>> I did a recover (myisamchk -r) for this table (later against *all* the
>> tables).
> 
> Damn.  You might try the '--extend-check' option, which is more thorough, but
> as the docs say the standard check gets "99.99 percent" of errors. :/
> 
>> The server still does not come up, giving the same error.
>> 	[ERROR] Fatal error: Can't open and lock privilege tables: Incorrect
>> 	key file for table 'host'; try to repair it
> 
> Worst case, I /think/ MySQL will recreate the table if you start without it,
> so you could try moving it out of the way.  Otherwise, time to restore from
> backup, I guess.
> 
> You would need to reset your host privileges, of course, if you remove it.
> 
> Regards,
>         Daniel

-- 
Eyal Lebedinsky	(eyal at eyal.emu.id.au)