MySQL Forums
Forum List  »  Perl

Using load data for multiple files
Posted by: Ravishankar Arivazhagan
Date: February 25, 2010 11:30AM

What I am trying to do now is add a bunch of files from a folder into MYSQL database.
The files are all comma separated (CSV's).
Name of the files are in this format :

filename.general (eg: xyz_1.general)

I used 'Load data infile' command initially and it seemed to work. I wrote a perl script to automate this process but I am getting an error after a few files are processed.(only 200 files out of 516 are getting inserted).
Taking the file name format into consideration i am not sure if i can use 'mysqlimport' command.
All files need to go into a single table. They have the same structure.
Is there a limit to the number of files that can be inserted using load file?
Is it suitable to do it for multiple files?
Is there a better way to do what I am doing?

Pleae help me with this guys!
Thank you in advance!

Options: ReplyQuote


Subject
Written By
Posted
Using load data for multiple files
February 25, 2010 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.