From owner-freebsd-hackers@FreeBSD.ORG  Tue Aug 16 13:04:30 2005
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
X-Original-To: freebsd-hackers@freebsd.org
Delivered-To: freebsd-hackers@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id B870716A41F
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 13:04:30 +0000 (GMT)
	(envelope-from patrick_dkt@yahoo.com.hk)
Received: from web52110.mail.yahoo.com (web52110.mail.yahoo.com
	[206.190.48.113])
	by mx1.FreeBSD.org (Postfix) with SMTP id 4097243D58
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 13:04:28 +0000 (GMT)
	(envelope-from patrick_dkt@yahoo.com.hk)
Received: (qmail 83607 invoked by uid 60001); 16 Aug 2005 13:04:28 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.hk;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=N25ex//PKupXmKiXha505cUSOQF4XNJhBkt0A13BRhjRqJLefA7o4//Ix+nX4CG+q5EIcAkFMQk73W01V7Oy+sX/WmuUKowXpsUJd6T/igoriu+VOhvqGO7QHQLsB+Z6VV6LR+TQLZdAmt89bFlCDcMWVDV5Qn4uwvRhHiIjTpg=
	; 
Message-ID: <20050816130428.83605.qmail@web52110.mail.yahoo.com>
Received: from [222.166.160.152] by web52110.mail.yahoo.com via HTTP;
	Tue, 16 Aug 2005 06:04:28 PDT
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>
In-Reply-To: <20050816103124.69621.qmail@web52101.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Cc: freebsd hackers <freebsd-hackers@freebsd.org>
Subject: Re: Backup problem for backup MySQL (a table > 2GB)
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 16 Aug 2005 13:04:30 -0000

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