Date: Tue, 16 Aug 2005 06:04:28 -0700 (PDT) From: Patrick Dung <patrick_dkt@yahoo.com.hk> To: Patrick Dung <patrick_dkt@yahoo.com.hk>, Dmitry Mityugov <dmitry.mityugov@gmail.com> Cc: freebsd hackers <freebsd-hackers@freebsd.org> Subject: Re: Backup problem for backup MySQL (a table > 2GB) Message-ID: <20050816130428.83605.qmail@web52110.mail.yahoo.com> In-Reply-To: <20050816103124.69621.qmail@web52101.mail.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Opps, it should be gzip -c, instead of gzip -dc --- Patrick Dung <patrick_dkt@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@gmail.com> wrote: > > > On 8/16/05, Patrick Dung <patrick_dkt@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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to > "freebsd-hackers-unsubscribe@freebsd.org" > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050816130428.83605.qmail>