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

• Next in forum: Re: [PHP] Anybody getting these also?
• Prev in forum: Re: [PHP] secure document : solution wanted
• Thread view: insert mysql data with safe mode on problem

[Reply to this message]