Blogエントリー消滅かと

一瞬、DBを完全に壊して、Blogのエントリが全て消えたのかと焦った。

ちょっと調べた。

hacmini:/var/lib/mysql/MT# ls -l|more
合計 141132
-rw-rw---- 1 mysql mysql       65 2005-11-06 16:12 db.opt
-rw-rw---- 1 mysql mysql      460 2006-08-20 18:39 mt_author.MYD
-rw-rw---- 1 mysql mysql     6144 2006-08-20 18:39 mt_author.MYI
-rw-rw---- 1 mysql mysql     9748 2006-07-16 13:41 mt_author.frm
-rw-rw---- 1 mysql mysql     1948 2006-08-20 18:39 mt_blog.MYD
-rw-rw---- 1 mysql mysql     5120 2006-08-20 18:39 mt_blog.MYI
-rw-rw---- 1 mysql mysql    16094 2006-01-16 02:38 mt_blog.frm
-rw-rw---- 1 mysql mysql     4912 2006-08-20 18:39 mt_category.MYD
-rw-rw---- 1 mysql mysql     9216 2006-08-20 18:39 mt_category.MYI
-rw-rw---- 1 mysql mysql     9026 2006-07-16 13:41 mt_category.frm
-rw-rw---- 1 mysql mysql   280704 2006-08-20 18:39 mt_comment.MYD
-rw-rw---- 1 mysql mysql    84992 2006-08-20 18:39 mt_comment.MYI
-rw-rw---- 1 mysql mysql     9386 2006-01-16 02:38 mt_comment.frm
-rw-rw---- 1 mysql mysql      108 2006-08-20 18:39 mt_config.MYD
-rw-rw---- 1 mysql mysql     2048 2006-08-20 18:39 mt_config.MYI
-rw-rw---- 1 mysql mysql     8602 2006-01-16 02:38 mt_config.frm
-rw-rw---- 1 mysql mysql 67107624 2006-08-20 03:25 mt_entry.MYD
-rw-rw---- 1 mysql mysql  2575360 2006-08-20 18:39 mt_entry.MYI
-rw-r----- 1 root  root  59179008 2006-08-20 01:05 mt_entry.TMD
-rw-rw---- 1 mysql mysql     9644 2006-01-16 02:38 mt_entry.frm
-rw-rw---- 1 mysql mysql        0 2006-08-20 18:39 mt_fileinfo.MYD
-rw-rw---- 1 mysql mysql     1024 2006-08-20 18:39 mt_fileinfo.MYI
hacmini:/var/lib/mysql/MT#

このmt_entry.TMDってのはなんだっけ？

取り合えず、消してみた。

hacmini:/var/lib/mysql/MT# mv mt_entry.TMD mt_entry.TMD.bak
hacmini:/var/lib/mysql/MT# sync
hacmini:/var/lib/mysql/MT# myisamchk -r *.MYI|more
- recovering (with sort) MyISAM-table 'mt_author.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_blog.MYI'
Data records: 5
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_category.MYI'
Data records: 81
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_comment.MYI'
Data records: 978
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
---------
- recovering (with sort) MyISAM-table 'mt_config.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'mt_entry.MYI'
Data records: 40891
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
---------
- recovering (with sort) MyISAM-table 'mt_fileinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'mt_ipbanlist.MYI'
Data records: 172
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_log.MYI'
Data records: 942
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_notification.MYI'
Data records: 5
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'mt_objecttag.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_permission.MYI'
Data records: 13
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'mt_placement.MYI'
Data records: 40886
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_plugindata.MYI'
Data records: 9
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_session.MYI'
Data records: 57
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_tag.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_tbping.MYI'
Data records: 190
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
---------
- recovering (with sort) MyISAM-table 'mt_template.MYI'
Data records: 113
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_templatemap.MYI'
Data records: 24
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_trackback.MYI'
Data records: 40809
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
hacmini:/var/lib/mysql/MT#

その後、復活。

ファイルのタイムスタンプから推測するに、myisamcheckを中断したときに、tempファイルが中途半端に出来てたみたいだな。

それが悪さをしていたんだろう。