Reply to Re: [PHP] insert mysql data with safe mode on problem

Your name:

Reply:


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-----

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация