I'm importing ~2000 rows using mysqlimport with the following syntax:
mysqlimport -d -v --ignore -u root -p[rootpw] [database] [tablename].txt
Connecting to localhost
Selecting database [database]
Deleting the old data from table [tablename]
Loading data from SERVER file: /[path]/[tablename] into [tablename]
[database].[tablename]: Records: 1780 Deleted: 0 Skipped: 39 Warnings: 1178
Disconnecting from localhost
But even with verbose on it doesn't tell me what the warnings are, or what rows were skipped. Where can I find that information?
Thanks.
_________________________________________________________________ MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]