help with error message from mysql when trying to mysqldump

Hello,
I have mysql 3.23.59 on freebsd 5.4 and Im trying to run mysqldump to
dump my mysql database for backup purposes. Im doing this with a shell
script thats run from crontab..Im getting the following error..Im not
sure what it means ...also is ther a better way to do this as I'd really
like mysqldump to make a full backup of the databases..it seems its
currently only doing a partial backup. the command im using is

/usr/local/bin/mysqldump -A -uroot -pxxxxx -c >
/usr/home/backups/mysql-alldatabases.sql

this is the error i get :

Got error: 1030: Got error 127 from table handler when retrieving data
from server


any help is greatly appreciated

--
--
Brent


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: help with error message from mysql when trying to mysqldump

Hi Brent,

Error 127 (MySQL error code 127: Record-file is crashed) means that one of
your (MyISAM) tables should be checked and, possibly, repaired after some
kind of corruption. See
http://dev.mysql.com/doc/refman/4.1/en/myisamchk.html for the details. Check
mysql-alldatabases.sql already generated to figure out what table is
corrupted.

> /usr/local/bin/mysqldump -A -uroot -pxxxxx -c >
/usr/home/backups/mysql-alldatabases.sql

This command dumps all the databases, according to the manual
(http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html). But it can stop
after error, hence the results that looks like incomplete backup.

Best regards,
--
Valeriy Kravchuk, Support Engineer
MySQL AB, Kiev, Ukraine, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org