"J Wadsworth" <[EMAIL PROTECTED]> wrote: > I am attempting to use the LOAD DATA feature. At the end it reports > that I have several warnings but there does not appear to be a way to > determine what the warnings are. I installed V4.1 which has the SHOW > WARNINGS feature, but, it returns empty sets after the load command. > > I have 30+ tables with several hundred thousand rows. Does anyone have > a simpler (and less time consuming) way than writing ETL to export the > tables and compare every record field by field (as recommended by the > MySQL Doc) to determine what the problems are?
SHOW WARNINGS for LOAD DATA will come in version 4.1.1: http://www.mysql.com/doc/en/SHOW_WARNINGS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]