[snip]
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format and zip the file.
This is not on my server, and it's in production, so I don't want to
risk testing different methods and possibly hanging up their server
for a period of time, so I
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
2 matches
Mail list logo
