HighWayToHell

To content | To menu | To search

Wednesday, June 24 2009

恢复丢失MYI文件的MyISAM表

最近倒腾一些古董MySQL数据,以便将来查询,碰到一些MyISAM表丢失了MYI(索引)文件,无法读出来了,其实只要表定义能找到,是可以恢复过来的,我手上的表有两种情况,恢复起来要分别对待:

  1. 未压缩的表
    这个好办,运行mysql命令 REPAIR TABLE `tablename` USE_FRM,通过表定义文件就重建出来了。
  2. 压缩过的表
    新建一个相同表结构的空表,然后压缩它,把索引文件拷贝成待恢复表的MYI,对待恢复表执行解压缩:myisamchk --unpack tablename,搞定!连索引文件都重建好了。

恢复好的表,检查一下基本属性和索引,有些参数可能丢失了,需要重设。
现在知道了吧,表定义在恢复数据的时候非常重要,以后必定保存好创建语句。
还有千万要备份,并且要分开存放。

Wednesday, June 17 2009

Fake Plastic Trees

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 man
Who just crumbles and burns.
He used to do surgery
For girls in the eighties
But gravity always wins.
And it wears him out, it wears him out.
It wears him out, it wears . . .

She looks like the real thing
She tastes like the real thing
My fake plastic love.
But I can't help the feeling
I could blow through the ceiling
If I just turn and run.
And it wears me out, it wears me out.
It wears me out, it wears me out.

And if I could be who you wanted
If I could be who you wanted
All the time, all the time.
Oh, oh.

Tuesday, May 26 2009

Otherwise

They wanted me here
Just to show you my face
But when it comes to the crunch
I just hide in disgrace
You're calling me mad
But i know you're the same
Cause you got to be seen to be playing the game
Yes we got to be seen to be playing, the game

It ain't gonna hurt now
If you open up your eyes
You're making it worse now
Everytime you criticise
I'm under your curse now
But I call it compromise
I thought that you were wise
But you were otherwise

A specimen like you
I would love to obtain
I asked a tedious guy if he'd tell me your name
I'd love to impress you
With a back sumersault
I wanna take up your love
But it's locked in a vault
I wanna take up your love
But it's locked in a vault

It ain't gonna hurt now
If you open up your eyes
You're making it worse now
Everytime you criticise
I'm under your curse now
But I call it compromise
I thought that you were wise
But you were otherwise

When i open my mouth
thoughts are brutally honest
And i can't expect that kind of love from you
When you open your mouth
Your teeth are beautifully polished
And i can't extract the pain you're going through
No i can't explain
The pain you're going through

It ain't gonna hurt now
If you open up your eyes
You're making it worse now
Everytime you womanise
I'm under your curse now
But I call it compromise
I'm under your curse

It ain't gonna hurt now
If you open up your eyes
You're making it worse now
Everytime you criticise
I'm under your curse now
But I call it compromise
I thought that you were wise
But you were otherwise!

Tuesday, April 28 2009

乌兰巴托的夜

穿过旷野的风啊 慢些走
我用沉默告诉你 我醉了酒
飘向远方的云啊 慢些走
我用奔跑告诉你 我不回头

乌兰巴托的夜啊
那么静 那么静
连风都不知道我 不知道
乌兰巴托的夜啊
那么静 那么静
连云都不知道我 不知道

飘荡异乡的你啊 在哪里
我的肚子开始痛 你可知道
穿越火焰的鸟啊 不要走
你知今夜疯掉的 不止一个人

乌兰巴托的夜啊
那么静 那么静
连风都不知道我 不知道
乌兰巴托的夜啊
那么静 那么静
连云都不知道我 不知道

Sunday, March 22 2009

607的挽歌

按下暂停,我先讲几句啊(灯光)
我叫GG,来公司有2年了
我本没有打算离开,可是
头头看我不爽,喊我过去
说:我们这里庙小,容不下你这大佛
你,还是到别处去吧(佯装挥泪)
我一听,差点血溅当场
哦不,是泪洒当场
其实,最后我还是没有忍住。(低头不语中)
CC,不能陪你去吃拉面了,要保重身体
QQ,上一次玩98你全都输给我了,不是故意的吧,现在你没有机会赢我了
FF,以后,再也看不到你在办公室里蹦蹦跳跳了
HH,不知道中午吃饭的时候还会不会谈到我
YY,记得把钱都烧给我啊,我可记手机上了
下面,我要清唱这首歌
点燃这支香烟
让光亮爆炸这黑夜
寂静世界不发一言
我的手在触摸著
从高处坠落的感觉
可心仍在向上飞跃
……亲爱的不要哭……
对不起,我忘词了
(从裤兜掏出一纸片,上面写着:慢慢的开始哭,然后痛哭/苦过度,晕厥过去了)
抱歉,我哭不出来
我给大家来一昏厥吧(立扑)
字幕打出──
“剧终”

- page 1 of 42