Re: DBI/load data infile issue

I am not sure how much of this is completely Perl related. Make sure you are checking for errors on the DBI handle.. If possible you can post you code and we can try it out..

Just for debugging - Upload the file directly using mysql..go into mysql prompt...Use the load data command. Check the number of records that got in..it might be the file and not the script. Also if i remember correctly you can do show warnings; and get the list of warnings generated by mysql..

-SK

Comment on Re: DBI/load data infile issue Download Code

Replies are listed 'Best First'.
Re^2: DBI/load data infile issue by jimbus (Friar) on Jul 08, 2005 at 16:33 UTC
Not to be snippy, but my original post does say I've done exactly what you suggested and got the expected results: `I check the tmp file and it had 3599 lines, I printed out the command from the perl script and appened it to mysql -e and got 3599 records.` [download] The results from the code listed above with PrintError=1 and trace=2: `[reports@clarkkent]/home/reports/ftp/WSB(29): ./b.pl load data infile '/tmp/WSB_urls_CDyy' into table tmpurl fields termina +ted by '\|' (tstamp,url,count) load data infile '/tmp/WSB_count_YAkf' into table tmpwsb fields termin +ated by '\|' (tstamp,op100,op700,total) lines: 72182 Done parsing: 1107730800: 1107734398 Done writing counts Done writing urls Done writing count DB Done writing url DB just done [reports@clarkkent]/home/reports/ftp/WSB(30):` [download] I can cut and paste the load command printed out by the script to "mysql -u root -pXXXX -e" and run it from the unix command line and I get the correct results. When I run the same command from the perl script in ``s I get the same results as I do using DBI Never moon a werewolf!	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: DBI/load data infile issue
by jimbus (Friar) on Jul 08, 2005 at 16:33 UTC

I check the tmp file and it had 3599 lines, I printed out 
the command from the perl script and appened it to 
mysql -e and got 3599 records.
[download]

The results from the code listed above with PrintError=1 and trace=2:

[reports@clarkkent]/home/reports/ftp/WSB(29): ./b.pl
load data infile '/tmp/WSB_urls_CDyy' into table tmpurl fields termina
+ted by '|' (tstamp,url,count)
load data infile '/tmp/WSB_count_YAkf' into table tmpwsb fields termin
+ated by '|' (tstamp,op100,op700,total)
lines: 72182
Done parsing: 1107730800: 1107734398
Done writing counts
Done writing urls
Done writing count DB
Done writing url DB
just done
[reports@clarkkent]/home/reports/ftp/WSB(30):
[download]

I can cut and paste the load command printed out by the script to "mysql -u root -pXXXX -e" and run it from the unix command line and I get the correct results.

When I run the same command from the perl script in ``s I get the same results as I do using DBI

Never moon a werewolf!

[reply]
[d/l]
[select]