Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Oct 212010
 

How to show the warnings during mysqlimport

Answer:

When you use mysqlimport to import data from text file, the number of warnings will be displayed at the end of import. But there is no way to show the actual warnings message.

To show the warnings, the only method is get into the mysql client to insert, instead of using mysqlimport.

E.g.

mysql> LOAD DATA INFILE  '/tmp/user.csv' REPLACE INTO TABLE user
Query OK, 100000 rows affected, 192 warnings (2.30 sec)

mysql> SHOW WARNINGS;

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>