Re: PHP: mysql_query()

I have PHPMyAdmin 2.21 I only see "GO" button, where can I upload my SQL file? "Alnisa Allgood" <allgood2@slip.net> wrote in message news:p05100309b79edae8263f@[63.202.15.82]... > 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:nonprofit-tech-subscribe@egroups.com > ......................................... > applying technology to transform > .........................................