comment on

Hi,

I need to insert alot of data into the database. My webpage times out (Error:Problem loading page) if i use the INSERT command. LOAD DATA LOCAL INFILE works fine in mysql but it doesnt seem to be working when I call it from my cgi file.

example.cgi
my $loc = "/var/temp.txt";
my $query="load data local infile '$loc' into table test fields termin
+ated by ',' lines terminated by '\t'";
my $update = $DB->do($query) or die "prepare failed: " . $DB->errstr()
+;
print $update ." Records inserted";
[download]

I have already created a table 'test' in the database. I get '0E0 Records inserted' in the web browser when i execute example.cgi.
Any suggestions on what I am doing wrong or what I should be doing would be helpful. Thanks!! Note: cgi files are saved in a unix system.

In reply to LOAD DATA LOCAL INFILE not working by Anonymous Monk

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Keep It Simple, Stupid
	PerlMonks