最近倒腾一些古董MySQL数据，以便将来查询，碰到一些MyISAM表丢失了MYI（索引）文件，无法读出来了，其实只要表定义能找到，是可以恢复过来的，我手上的表有两种情况，恢复起来要分别对待： 未压缩的表这个好办，运行mysql命令 REPAIR TABLE `tablename` USE_FRM，通过表定义文件就重建出来了。 压缩过的表新建一个相同表结构的空表，然后压缩它，把索引文件拷贝成待恢复表的MYI，对待恢复表执行解压缩：myisamchk --unpack tablename，搞定！连索引文件都重建好了。 […]
June 2009 (2)
Wednesday, June 17 2009
Fake Plastic Trees
Wednesday, June 17 2009. 音乐
Her green plastic watering can For her fake Chinese rubber plant In the fake plastic earth. That she bought from a rubber man In a town full of rubber plans To get rid of itself. It wears her out, it wears her out It wears her out, it wears her out. She lives with a broken man A cracked polystyrene […]
Last comments