I have a script that takes two csv files, puts them into tables, and then compares them. The script work perfectly. Now, all of a sudden, the csv files are not being added to the database. The querys I am using are:
$sql = mysql_query("LOAD DATA LOCAL INFILE '/home/gamex1/public_html/scan.csv' INTO TABLE scan LINES TERMINATED BY '\r\n'");
$sql = mysql_query("LOAD DATA LOCAL INFILE '/home/gamex1/public_html//corp.csv' INTO TABLE corp FIELDS OPTIONALLY ENCLOSED BY '\"' TERMINATED BY ',' LINES TERMINATED BY '\r\n'");
This worked for about 2 months, now it doesnt. What would cause this to happen?
Thanks, Joe