Re: [X-POST] Fastest way to dump this huge table
| From: | Colin Guthrie | Date: | Wed, 02 May 2007 16:01:09 +0000 |
| Subject: | Re: [X-POST] Fastest way to dump this huge table | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-254241@lists.php.net to get a copy of this message | ||
clive wrote:
>
>> I'd say give some attention to the zip method you use.
>
> or better yet rsync the file, send only what has changed.
Good advice but may not work as well with extended insert syntax which
results in smaller dump files and much faster import too.
I guess with CSV it could work well tho' (my mind is stuck in mysql dump
output mode ;))
COl