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/[email protected]