Re: Please Help me with urgent-strange PHP script (SOLVED)

I want to thank Torsten Roehr for his generous help... We sent each other around 20 e-mails each and the problem was solved by using a script that not only he made, but also changed for me to use... Cheers, Cesar Aracena Patagonia Hosting Development Group --------------------------------------- "Patagonia Hosting Development Group" <development@patagoniahosting.net> escribió en el mensaje news:20040427195416.36811.qmail@pb1.pair.com... > Hi all, > > I need to transfer a MySQL DB TODAY but I can't get a hold of one table that > has mroe than 170.000 records in it. phpMyAdmin will time out every time I > try to make a dump of that table. The other problem is that I only have > access through phpMyAdmin... It's a remote server and I don't have telnet, > ssh o any other thing to wotk with. I can't even get access to MySQL's > files. > > I want to try something with PHP. Anybody knows how can I make a script that > will fetch the first 10.000 records and show them as the SQL statement: > INSERT INTO... for me to make a local .txt file with it? then I can make a > SQL statement with all the inserts. This way, I can grab from 10.000 to > 10.000 and the server won't time out. > > Thanks a lot, > > -- > Cesar Aracena > Patagonia Hosting Development Group