Posted by Chris on 04/07/05 16:28
I've been using a php script which loads a large (approximately 40,000
records) data file into a mysql table. In the event that MySql's LOAD DATA
INFILE capability is disabled, the script loads each record individually.
The problem I'm facing is trying to run this script on a server which has
safe mode enabled. Under safe mode the default script execution time is
usually 30 seconds, and to process 40,000 records requires about 2-3
minutes.
I'm now faced with a situation where I can't load the entire data file and
wondered if anybody else has encountered this problem.
Also, the following conditions are NOT available as an option.
1 - use phpmyadmin
2 - increase the script execution time in php.ini (set_time_limit doesn't
work in safe mode)
3 - enable LOAD DATA INFILE by granting the MySql File_priv
--
Chris
[Back to original message]
|