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]
