Posted by Maerlyn on 04/07/05 16:56

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris wrote:

> 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
>
You might make the script recursive, it processes for example 1000
records, then it calls itself to process the next 1000 records, and so
on until all the records are processed. You only have to add one post
or get variable.

- --
Maerlyn
maerlyn[AT]citromail[DOT]hu
http://putraware.ini.hu
GnuPG Public Key ID: 0x0CE0A57
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCVTwDMkyacQzgalcRAo/+AKDXdFsGH8N2xu+CmFM+zdRn+9ZogwCg6skf
EWGgp1IyweJiZaz785AYZJU=
=+H4V
-----END PGP SIGNATURE-----

• Next in forum: Free lancer needed
• Prev in forum: Web Site Security Hole
• Thread view: Re: [PHP] insert mysql data with safe mode on problem

[Reply to this message]