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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
William_I
Forum Newbie
Posts: 13
Joined: Sat Mar 29, 2003 8:22 am
Location: Manhattan

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

Post 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?
easyteck
Forum Newbie
Posts: 13
Joined: Thu Jun 05, 2003 12:01 pm
Location: Ecuador
Contact:

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

Post 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!!!
Josh_A
Forum Newbie
Posts: 1
Joined: Sun Dec 26, 2004 2:34 am

Post 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!
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post 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.
Post Reply