Somehow your table was zero'ed out, i.e. TRUNCATE / DROP-CREATE. MYD - data of the table MYI - index of the table Frm - TABLE definition
I hope you have a backup. > -----Original Message----- > From: Vicki Brown [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 3:15 PM > To: mysql@lists.mysql.com > Subject: I seem to have lost a table somehow :-( > > I have a Movable Type weblog at http://www.technofile.org/AverageJoe/ > I am using MySQL to store the data for this weblog; > mysql Ver 14.7 Distrib 4.1.7, for unknown-freebsd4.7 (i386) > > > when I go to the MT Main Menu page, the weblog is not listed > as existing. > When I go to the mysql database directory, several pertinent > .MYD files are empty; this concerns me. (massive understatment). > > -rw-rw---- 1 mysql mysql 672 Nov 6 20:13 mt_author.MYD > -rw-rw---- 1 mysql mysql 4096 Nov 13 12:16 mt_author.MYI > -rw-rw---- 1 mysql mysql 9350 Nov 6 20:13 mt_author.frm > -rw-rw---- 1 mysql mysql 0 Nov 6 20:13 mt_blog.MYD > -rw-rw---- 1 mysql mysql 1024 Nov 6 20:13 mt_blog.MYI > -rw-rw---- 1 mysql mysql 11844 Nov 6 20:13 mt_blog.frm > -rw-rw---- 1 mysql mysql 0 Nov 6 20:13 mt_category.MYD > -rw-rw---- 1 mysql mysql 1024 Nov 6 20:13 mt_category.MYI > -rw-rw---- 1 mysql mysql 8970 Nov 6 20:13 mt_category.frm > -rw-rw---- 1 mysql mysql 0 Nov 6 20:13 mt_entry.MYD > -rw-rw---- 1 mysql mysql 1024 Nov 6 20:13 mt_entry.MYI > -rw-rw---- 1 mysql mysql 9678 Nov 6 20:13 mt_entry.frm > > myisamchk certainly doesn't give me warm fuzzies... > > % myisamchk mt_blog.MYI > Checking MyISAM file: mt_blog.MYI > Data records: 0 Deleted blocks: 0 > - check file-size > - check record delete-chain > - check key delete-chain > - check index reference > - check data record references index: 1 > - check data record references index: 2 > - check record links > > The weblog data is still "out there" (i.e. the database > provides a backup and datastore for "published" .html files; > MT isn't, thank goodness, completely dynamic in nature). I'm > waiting in hopes that the MT tech support has a suggestion > for rebuilding the database from "published" files. > > Is there some way I can fix this problem at the MySQL end? > The .frm files have data. Does that "mean" anything? Can I use that? > > > -- > Vicki Brown ZZZ Journeyman Sourceror: > SF Bay Area, CA zz |\ _,,,---,,_ Scripts & Philtres > http://www.cfcl.com zz /,`.-'`' -. ;-;;,_Code, Doc, Process, QA > http://cfcl.com/vlb |,4- ) )-,_. ,\ ( `'-'Perl, Unix, Mac OS X, WWW > ____________________ '---''(_/--' `-'\_) ___________________________ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]