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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
