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?
mySQL error- Got error: 1030: Got error 127 from...
Moderator: General Moderators
Re: mySQL error- Got error: 1030: Got error 127 from...
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!!!
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!!!
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!
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!
Code: Select all
weirdan@office:~$ perror 127
Error code 127: Unknown error: 127
127 = Record-file is crashed