Date: Tue, 16 Aug 2005 03:31:24 -0700 (PDT) From: Patrick Dung <patrick_dkt@yahoo.com.hk> To: 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: <20050816103124.69621.qmail@web52101.mail.yahoo.com> In-Reply-To: <b7052e1e05081601583845c002@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050816103124.69621.qmail>