List:General Discussion« Previous MessageNext Message »
From:Ryan Stille Date:May 2 2007 2:04pm
Subject:Re: [X-POST] Fastest way to dump this huge table
View as plain text  
I use a script like this:

   #!/bin/bash
   DATE=`date +%A`

   DESTFILE="/home/mysql-backups/mysql-dump-$DATE"

   /usr/bin/mysqldump --skip-extended-insert -uroot -p"password" 
mydatabase > $DESTFILE.sql
   /usr/bin/zip -qjTm $DESTFILE.zip $DESTFILE.sql

I end up with:
mysql-dump-Friday.zip
mysql-dump-Saturday.zip
etc.

Modify to suit your needs.

-Ryan

Brian Dunning wrote:
> 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 wanted to seek advice here first to find 
> what's the best way to proceed.
>
> I can easily use PHP to query the table for the results I want and 
> write a file line by line and then zip it, but I'm worried that might 
> take too long and hang up the machine. The other way to go is some 
> kind of sql dump command, which I guess would be faster, but not sure 
> how much control I'd have over the exact format of the file. Any 
> suggestions which way I should proceed? Not hanging up their server is 
> my prime concern.
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


Thread
[X-POST] Fastest way to dump this huge tableBrian Dunning2 May
  • RE: [X-POST] Fastest way to dump this huge tableJay Blanchard2 May
  • Re: [X-POST] Fastest way to dump this huge tableRyan Stille2 May
  • Re: [X-POST] Fastest way to dump this huge tableDan Buettner2 May
    • Re: [X-POST] Fastest way to dump this huge tableBrian Dunning2 May
      • Re: [X-POST] Fastest way to dump this huge tableDan Buettner2 May