Hi Anil,

Why not pipe the mysqldump direct into gzip?

eg: mysqldump etc ... | gzip -c

Regards 



---------------------------------------------------------------
********** _/     **********  David Logan 
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: [EMAIL PROTECTED]
****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
*****        _/       ******    
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia 
i    n    v    e    n    t                                   
---------------------------------------------------------------

-----Original Message-----
From: Anil [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 19 August 2006 8:03 PM
To: mysql@lists.mysql.com
Subject: Managing big mysqldump files

Hi List,

 

We are facing a problem of managing mysqldump out put file which is
currently of size  80 GB and it is growing daily by 2 - 3 GB, but we
have a
linux partition of only 90 GB.. Our backup process is  first generate
the
mysqldump file of total database and then compress the dump file and
remove
the dump file. Is there any way  to get compressed dump file instead of
generating dump file and then compressing it later. Any ideas or
suggestions
please

 

Thanks

Anil

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to