Riccardo Cohen wrote: > Hi, > Sorry to disturb, but I cannot find any answer in online doc and web archive. > > >Description: > I insert 34000 rows in a simple table with all text fields, and myisamchk >tells the table is corrupted, while a select into outfile does not give any error >compared to the original file. >
select * into outfile... does not use any indexes (I think) so if it is only your index that is corrupted then there will be no problem. If the data file is corrupted such that there is an extra bad record, I would bet that it just gets skipped over. MySQL is good at giving you everything it possibly can even if there are 'issues' with the tables/indexes. Have you tried 'myisamchk -r table' to try to repair it? b. --------------------------------------------------------------------- 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
