"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]