Re: Load data is ignoring sql_mode option
Your problem, as described in the bug report, is that you are using the --local option with mysqlimport. When LOCAL is used, this causes the client to send the file to server, rather than being directly read by the server. When an error occurs, there is no way for the server to stop transmission of the data from the client, so errors are ignored. This is described a bit in
http://dev.mysql.com/doc/refman/5.0/en/load-data.html, but in terms of ignoring duplicate rows. Principle should still be the same with regard to strict mode.
-Dave
Subject
Written By
Posted
Re: Load data is ignoring sql_mode option
June 27, 2007 01:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.