Re the MySQL index files that seem to have disappeared (though they show up in dir listings), I did a mysqlcheck, and got the ff:
[EMAIL PROTECTED]:~/nocheats$ mysqlcheck nocheats -p Enter password: nocheats.Q_etc OK nocheats.Q_local OK nocheats.Q_mega OK nocheats.Q_wolf OK nocheats.Qin OK nocheats.Qout OK nocheats.forms OK nocheats.pcints OK nocheats.phones warning : Table is marked as crashed warning : 1 client is using or hasn't closed the table properly error : Found 2259116 keys of 2259119 error : Corrupt nocheats.provinces OK nocheats.queue OK nocheats.reports warning : Table is marked as crashed warning : 1 client is using or hasn't closed the table properly error : Found 462305 keys of 462323 error : Corrupt nocheats.results OK nocheats.towns OK nocheats.unconfirmed warning : Table is marked as crashed warning : 1 client is using or hasn't closed the table properly error : Found 1130874 keys of 1130880 error : Corrupt I then ran mysqlcheck with the analyze option and got the ff: [EMAIL PROTECTED]:~/nocheats$ mysqlanalyze nocheats -p bash: mysqlanalyze: command not found [EMAIL PROTECTED]:~/nocheats$ mysqlcheck -a nocheats -p Enter password: nocheats.Q_etc Table is already up to date nocheats.Q_local Table is already up to date nocheats.Q_mega Table is already up to date nocheats.Q_wolf Table is already up to date nocheats.Qin Table is already up to date nocheats.Qout Table is already up to date nocheats.forms Table is already up to date nocheats.pcints Table is already up to date nocheats.phones error : Can't open file: 'phones.MYI' (errno: 145) nocheats.provinces Table is already up to date nocheats.queue Table is already up to date nocheats.reports error : Can't open file: 'reports.MYI' (errno: 145) nocheats.results Table is already up to date nocheats.towns Table is already up to date nocheats.unconfirmed error : Can't open file: 'unconfirmed.MYI' (errno: 145) So the above .MYI files were really corrupted. I really would like to know how the files were corrupted. The top suspect seems to be the power outage. I just want to make sure I didn't miss anything. Obet _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
