Hello Plamen,

Friday, July 27, 2001, 2:04:15 PM, you wrote:

PS> Hi guys,
PS> I have a big MySQL table - about 300MB
PS> I want to get all the records from the table, make certain transformations and 
write them to a text file (i can not use "select into outfile...)
PS> the problem is when i type "select * from <table name>" the server hangs 
PS> is there a way that i can select 1 record at a time or something similar, which 
would not put so much pressure on the server, but i still will get every record from 
the table
PS> Thanks
PS> ----------------------------------------------------------------------------------
PS> Visit our site at http://eshop.bg

As I understood you you want to take all datas from table. For that is
very useful command
mysqldump --database > file.sql

I hope it helps to you
Best regards,
 Daniel                            mailto:[EMAIL PROTECTED]

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]

Reply via email to