or perhaps, someone issued a drop table command? =)
did you already checked the data directory to see if the actual .MYI (index), *.MYD (data) or *.frm (table format) files were missing? if those files still exist, then you can issue a command to repair them. if those files just vanished, you can restore your data using the binary log (only if you enabled it), or sql update logs (only if you enabled it), or via the latest dump from mysqldump (only if you scheduled it). i also had issues before when using the mysql package from debian that i now usually download the static binaries directly from mysql.com. On 2/8/07, Roberto Verzola <[EMAIL PROTECTED]> wrote:
Hi, My MySQL database seems to have suffered from corruption and I'd like to ask MySQL gurus here what could have happened. Here's a log of my session: [EMAIL PROTECTED]:~/nocheats$ mysql nocheats -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'phones' Didn't find any fields in table 'reports' Didn't find any fields in table 'unconfirmed' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 to server version: 4.1.11-Debian_4sarge7-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> describe phones; ERROR 1016 (HY000): Can't open file: 'phones.MYI' (errno: 145) mysql> describe reports; ERROR 1016 (HY000): Can't open file: 'reports.MYI' (errno: 145) mysql> describe unconfirmed; ERROR 1016 (HY000): Can't open file: 'unconfirmed.MYI' (errno: 145) mysql> Tables phones, reports and unconfirmed were ok a few days ago. Now they are somehow corrupted. I do remember losing power and having to reboot one or two days ago. I am wondering how .MYI could disappear just like that: an intrusion? a software problem? the power loss? I don't quite know where to start and would appreciate advice. I'm using Debian Sarge and MySQL 4.1. Regards to all, 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
