Chris, Sunday, July 14, 2002, 5:44:49 AM, you wrote: CB> I'm new to the list. CB> I'm writing because I've been having trouble with table corruption. I'm CB> using isam tables and i've been using myisamchk under linux to check them. CB> alot of the time it just reports that some of the tables were'nt closed CB> properly so i repair them but after doing that i find that the tables are CB> ruined.
myisamchk is used for checking and repairing MyISAM tables, to repair ISAM tables you should use isamchk. CB> I read that the linux 2.2.14 kernel can be a problem with mysql but i'm CB> running the 2.4.8 kernel. CB> Also, I did backup the databases using mysqldump...but after tryign to CB> restore by: CB> mysql --user=whoever --password=whatever --host=whereever < CB> database_restore.txt CB> i get errors...I think that when the backup was created bad data was written CB> to the file. What errors did you receive? CB> Is there supposed to be a minimum file size before your are supposed to run CB> myisamchk, or is there something i should be running before i run myisamchk? You shouldn't run myisamchk when mysqld is running. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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