At 4:05 PM +0200 8/14/01, _lallous wrote:
>Basically I have PHPMyAdmin...
>If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more
>than 30secs to execute it which will make everything fail!
>Anyway, I solved it. Check the recent post in the same thread about SQL2PHP
>script.
>
You don't have to past, you just upload the file, as a SQL query, and
select go. If the file still fails, just break it in two.
fileinsert1.sql, fileinsert2.sql, I've seen people insert over
60,000 records this way no errors. I've personally never worked with
more than 10,000 records at a time, but if time outs are the issue,
then just break the file into smaller files.
Alnisa
--
.........................................
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
.........................................
Nonprofit Tech E-Update
mailto:[EMAIL PROTECTED]
.........................................
applying technology to transform
.........................................
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]