Re: [PHP] MySQL big table process

2001-07-27 Thread Unni 

Try LIMIT in the select

Plamen Slavov wrote:

> Hi guys,
> I have a big MySQL table - about 300MB
> 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...)
> the problem is when i type "select * from " the server hangs 
> 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
> Thanks
> --
> Visit our site at http://eshop.bg
> 
> 
> 


-- 
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]

Re: [PHP] MySQL big table process

2001-07-27 Thread Daniel Rezny 

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 " 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,
 Danielmailto:[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]