Hi, I just updated a new database with the update log from another server, and the script failed on the LOAD DATA INFILE commands that I have to import data overnight from other sources, because, of course, those files didn't exist.
Now, I know I can use --force to allow the script to complete, but the questions are: 1. Does the binlog log the LOAD DATA INFILE command in the same way? 2. How do those of you using replication handle load data infile commands on the slave? If the source file is not available on the slave, won't your slave no longer match the master? 3. Is it possible (if it doesn't already in the binlog) to have a load data infile to be logged as a series of INSERTs Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- 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