473,480 Members | 5,031 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Finding warnings/skips from mysqlimport

Hi,

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 2720

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
662
by: Daniel Kasak | last post by:
Hi all I have some data in Excel ( I didn't put it there - a customer did ). I'm setting up an import routine for it, with an Access front-end. I don't like the way Access imports Excel files,...
0
775
by: gord barq | last post by:
Hi, I'm importing ~2000 rows using mysqlimport with the following syntax: mysqlimport -d -v --ignore -u root -p .txt Connecting to localhost Selecting database Deleting the old data...
0
2222
by: lynn | last post by:
Hello, I am installing some databases on the mysql databases of my mac osx 10.2.8 but when I do "mysqlimport -u X -p W (directory) *.txt.table" I am getting this answer: mysqlimport: Error:...
0
1588
by: Tom | last post by:
Hi I am using the following command to import a csv file into my MySQL database but for some reason the first column in the CSV file is being ignored... any thoughts as to why this might be...
0
2075
by: Dobsons | last post by:
What can I do to make this series run as like an executable? (I type in the file name and it runs these 9 mysqlimport commands) mysqlimport -df --fields-enclosed-by='"' --fields-terminated-by=, R...
0
1768
by: Joseph Hill | last post by:
Hi I have a 300MB CSV file in with data in the following fashion: "AB10 1AF","39410","80640","QA28","SN9","Castlehill","Aberdeen City","Grampian","","49998","Not applicable","" "AB10...
0
2024
by: Dave Hammond | last post by:
When using mysqlimport, the final statistics include a count of "Warnings", for example: Connecting to foo.whatever.com Selecting database foo Loading data from LOCAL file: foo_userInfo.imp...
1
3640
by: rchicho | last post by:
Necesito importar a una tabla MySQL datos de un archivo de texto, donde los campos están seperados por tabuladores, pero el orden y cantidad de los campos en el archivo texto no coincide con el de la...
0
1128
by: moishyyehuda | last post by:
whey when I execute this statment cursor.execute("""mysqlimport merchandise 1.txt""") I get this error ProgrammingError: (1064, "You have an error in your SQL syntax. Check the manual that...
2
3248
by: santhanalakshmi | last post by:
hi, can you give me the mysqlimport query ? i tried with this C:\xampp\mysql\bin>mysqlimport -u root -p --fields-terminated-by="," ...
0
6905
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7041
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
6908
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4772
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2980
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1299
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.