I thought this may be helpful to anyone that is having this problem.
I tried to back up my database using mysqldump:
[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata |
gzip > /home/pad/dbbackup/20010908a.gz
Enter password:
# Connecting to localhost...
# Retrieving table structure for table _chat...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table action_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table asessions...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table data_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_ccard...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_lead_status...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_serv...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup_ac...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table items...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_assign_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_comments...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table leads...
# Sending SELECT query...
# Retrieving rows...
When it got to here, it died, saying something like:
Error 1030: Got error 127 from table handler on record 1382
Hmmm...
I ran a:
repair table leads
command from in mysyl. It fixed two errors. Then I could do the backup.
Also, before I fixed the errors, I could preform the following:
SELECT lead_id FROM leads;
But I could not prefrom the following - I got error 127 from table handler:
SELECT lead_id, firstname, lastname FROM leads;
This one has me puzzled, but repair table fixed this also.
Hope it helps someone!
-Jason Garber
Lead Programmer - pulseaday.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
