Regarding error 127 from table handler... 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
