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