Using load data for multiple files
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!
Subject
Written By
Posted
Using load data for multiple files
February 25, 2010 11:30AM
February 25, 2010 05:05PM
February 25, 2010 05:12PM
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.