PDA

View Full Version : MySql Repair Question


Bulent Tekcan
Wed 16th Aug '06, 8:14am
I have a interesting DB Error today.1 forum has gone,but posts is there.this is error results.

1st Error : MySQL Error : Got error 12 from storage engine
2nd Error: MySQL Error : Got error 127 from storage engine

Also I was repair my post table....This is my phpmyadmin result...Any idea for that error ? And also my db is OK ?

xxxxxxxxxxxxxxx.post repair info Wrong block with wrong total length starting at 74...
xxxxxxxxxxxxxxx.post repair warning Number of rows changed from 2389072 to 2389071
xxxxxxxxxxxxxxx.post repair status OK

Thanks

Colin F
Wed 16th Aug '06, 8:42am
Error 12 means that there is not enough space and error 127 means that the record table has crashed.

Ask your host to repair the tables using myisamchk.

Bulent Tekcan
Wed 16th Aug '06, 8:44am
xxxxxxxxxxxxxxx.post repair info Wrong block with wrong total length starting at 74...
xxxxxxxxxxxxxxx.post repair warning Number of rows changed from 2389072 to 2389071
xxxxxxxxxxxxxxx.post repair status OK

Hi Colin...

I'm already repair my post table,and this is my report.Is it not ok ?