Page 1 of 1

mySQL error- Got error: 1030: Got error 127 from...

Posted: Mon Jun 09, 2003 9:51 am
by William_I
Full error when attempting commandline mysqldump:
mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server

This is on a 70+ megabyte mySQL database for an XMB forums forum database. Everything is running fine, no errors in the forum operation.

However, backups are failing, and the above error seems to be the cause.

The largest table 'posts' is over 60mb and may be the cause. I get out of memory errors in phpMyAdmin when attempting to export just the table. I've run REPAIR TABLE on this table, and I still get the error.

Has anyone seen this before?

Re: mySQL error- Got error: 1030: Got error 127 from...

Posted: Mon Jun 09, 2003 7:57 pm
by easyteck
I've never got that error...

Have you tried to get the DB dump (backup) using Webmin???

Are you shure you have enough RAM in your mySQL server? This is a huge DB and maibe that's the problem... the resources of your machine!

Cheers!!!

Posted: Sun Dec 26, 2004 2:38 am
by Josh_A
So this is an old topic, but it came up in my Google search, and I just dealt with the same problem, so...

I tried the mysqldump with the --opt option, which ended up telling me what table it was having a problem with...

In mysql, I did check table tablename; which showed it as corrupt. repair table tablename; reported repairing it ok, so I tried mysqldump again and it worked fine.

Hopefully that's the end of the story!

Posted: Sun Dec 26, 2004 10:08 am
by Weirdan

Code: Select all

weirdan@office:~$ perror 127
Error code 127:  Unknown error: 127
127 = Record-file is crashed
That's it, your record file is broken. You may try to recover it using myisamchk utility (if it's in myisam format, of course) with -er option. It will be very lenghty process though.