> did you already checked the data directory to see if the > actual .MYI (index), *.MYD (data) or *.frm (table format) > files were missing?
Hi Ariz, thanks for the quick response. Here's the session: (my untrained eye can't find anything wrong...) halal:/var/lib/mysql/nocheats# vdir phones* -rw-rw---- 1 mysql mysql 9244 2006-09-10 09:10 phones.frm -rw-rw---- 1 mysql mysql 315239580 2007-02-07 09:10 phones.MYD -rw-rw---- 1 mysql mysql 24897536 2007-02-07 19:10 phones.MYI halal:/var/lib/mysql/nocheats# vdir reports* -rw-rw---- 1 mysql mysql 8854 2006-09-02 08:40 reports.frm -rw-rw---- 1 mysql mysql 450011012 2007-02-07 09:10 reports.MYD -rw-rw---- 1 mysql mysql 12421120 2007-02-07 19:10 reports.MYI halal:/var/lib/mysql/nocheats# vdir unconfirmed* -rw-rw---- 1 mysql mysql 8854 2006-09-06 13:15 unconfirmed.frm -rw-rw---- 1 mysql mysql 1082754724 2007-02-07 09:10 unconfirmed.MYD -rw-rw---- 1 mysql mysql 29910016 2007-02-07 19:11 unconfirmed.MYI halal:/var/lib/mysql/nocheats# The date feb 7, to the best of my recollection, would be the date when the system lost power, and I'm pretty sure the files were open then, because I had a program running the whole day using these files. > if those files still exist, then you can issue a command to > repair them. These are mostly test data (I wonder if their sizes have anything to do with it...), so recovering them would be a good exercise in preparation for the real thing, but my biggest concern is to make sure this can't happen on our production run this May elections. > > 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). Yes, this is a useful thing to remember. Do you suggest I enable both or only one of the logging commands, and if one is enough, which one would you recommend? > > i also had issues before when using the mysql package > from debian that i now usually download the static binaries > directly from mysql.com. Really? Would those issues you had be somehow similar to this problem I just encountered? Greetings, 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
