Re: MySQL big table process
| From: | Daniel Rezny | Date: | Fri, 27 Jul 2001 12:41:36 +0000 |
| Subject: | Re: MySQL big table process | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59937@lists.php.net to get a copy of this message | ||
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
PS> 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
PS> 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:daniel@rezny.sk