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]