var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: host.myi Damaged -- How to fix this?
Hello everybody. Got a linux server with debian and mysql on it. After the computer crashed today, mysql doesn't start up and tells me that host.myi is damaged. How can I fix this?
Thanks in advance
mysqld_safe --skip-grant-tables &
REPAIR TALBE host USE_FRM;
restart MySQL normally
You may lose the data in the host table but it sounds like it's lost already.
Last edited by codenode; 12-23-04 at 05:04.
MYI is the index file so there a chance that your mysql.host table is not lost
You need to use myisamchk -r q to recover the index file and restart mysql
How do I fix the grant tables?
I am getting:
Didn't find any fields in table 'columns_priv'
Didn't find any fields in table 'tables_priv'
I used your advice to fix all the other tables, how do I fix this?