Backup problem for backup MySQL (a table > 2GB)

Patrick Dung patrick_dkt at yahoo.com.hk
Tue Aug 16 13:04:30 GMT 2005


Opps, it should be gzip -c, instead of gzip -dc

--- Patrick Dung <patrick_dkt at yahoo.com.hk> wrote:

> Yes mysqldump.
> 
> More solutions
> 
> mysqldump database | split -b 1900m
> mysqldump database | gzip -dc | split -b 1900m
> mysqlhotcopy database /tmp && tar czvf /tmp/db.tar /tmp && split -b
> 1900m /tmp/db.tar
> 
> mysqlhotcopy uses lots of space...
> 
> --- Dmitry Mityugov <dmitry.mityugov at gmail.com> wrote:
> 
> > On 8/16/05, Patrick Dung <patrick_dkt at yahoo.com.hk> wrote:
> > > Hi
> > > 
> > > We are using an old backup product which can only backup files <
> > 2GB.
> > > Now we have a mysql file > 2GB. The backup product refuse to
> backup
> > > that file.
> > > 
> > > So, whats the alternatives to perform backup for this situation?
> > > This is current idea:
> > > 
> > > Tar all the mysql directory and split into small files < 2GB.
> > > 
> > > Any suggestions?
> > 
> > Use mysqldump or mysqlhotcopy?
> > 
> > -- 
> > Dmitry Mityugov, St. Petersburg, Russia
> > I ignore all messages with confidentiality statements
> > 
> > "We live less by imagination than despite it" - Rockwell Kent, "N
> by
> > E"
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> _______________________________________________
> freebsd-hackers at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
> To unsubscribe, send any mail to
> "freebsd-hackers-unsubscribe at freebsd.org"
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the freebsd-hackers mailing list