I issue a LOAD TABLE FROM MASTER command every night to keep in sync the master and the slave. Yesterday i have done the following test: a) stopped the slave update (SLAVE STOP) at the 18:00 b) deleted the table in the slave and issued the LOAD TABLE FROM MASTER command at the 05:00 am of the day after The error log in the slave reports the following errors/warnings: 10117 5:02:29 Delete link points outside datafile at 309108 010117 5:02:29 Warning: Retrying repair of: './db_name/tablename' without quick 010117 5:02:30 Delete link points outside datafile at 309108 010117 5:02:35 Delete link points outside datafile at 3789600 010117 5:02:36 Delete link points outside datafile at 4315048 010117 5:02:36 Found link that points at 3617857477779347045 (outside data file) at 4314876 010117 5:02:38 Delete link points outside datafile at 5073816 010117 5:02:38 Delete link points outside datafile at 5098388 I suppose that some record that was deleted in the master and LOAD TABLE FROM MASTER tried to read these records... The question is: what does it happen to the table in the slave? It gets corrupted? Or it is safe? Denis --------------------------------------------------------------------- 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
