From owner-freebsd-hackers@FreeBSD.ORG  Tue Aug 16 10:31:25 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 B674C16A41F
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 10:31:25 +0000 (GMT)
	(envelope-from patrick_dkt@yahoo.com.hk)
Received: from web52101.mail.yahoo.com (web52101.mail.yahoo.com
	[206.190.48.104])
	by mx1.FreeBSD.org (Postfix) with SMTP id 2A75543D46
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 10:31:25 +0000 (GMT)
	(envelope-from patrick_dkt@yahoo.com.hk)
Received: (qmail 69623 invoked by uid 60001); 16 Aug 2005 10:31:24 -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=0Ro0hhGXWDUb+pWCLXyqxxg/mI7LGdma2HkLQ19n+zifXGDZ29Q7CCHbI5QvI2knduqxx3z/QjTF30iMwyRjKmqMUHZyKuQChkPv7uSeMzshTR3UFjfboEp6k8ll/oTu5HQgoeaZdMuwze6r3PNfgWv+SOVMSE44Ky1NoI7nMTg=
	; 
Message-ID: <20050816103124.69621.qmail@web52101.mail.yahoo.com>
Received: from [202.134.67.19] by web52101.mail.yahoo.com via HTTP;
	Tue, 16 Aug 2005 03:31:24 PDT
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>
In-Reply-To: <b7052e1e05081601583845c002@mail.gmail.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 10:31:25 -0000

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