From owner-freebsd-hackers@FreeBSD.ORG  Tue Aug 16 10:08:49 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 71DE416A41F
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 10:08:49 +0000 (GMT)
	(envelope-from martin@gneto.com)
Received: from av9-1-sn2.hy.skanova.net (av9-1-sn2.hy.skanova.net
	[81.228.8.179]) by mx1.FreeBSD.org (Postfix) with ESMTP id C6F1D43D48
	for <freebsd-hackers@freebsd.org>; Tue, 16 Aug 2005 10:08:47 +0000 (GMT)
	(envelope-from martin@gneto.com)
Received: by av9-1-sn2.hy.skanova.net (Postfix, from userid 502)
	id 9482A38020; Tue, 16 Aug 2005 12:08:46 +0200 (CEST)
Received: from smtp4-1-sn2.hy.skanova.net (smtp4-1-sn2.hy.skanova.net
	[81.228.8.92]) by av9-1-sn2.hy.skanova.net (Postfix) with ESMTP
	id 6C97037E5A; Tue, 16 Aug 2005 12:08:46 +0200 (CEST)
Received: from [192.168.2.30] (h99n2fls34o985.telia.com [213.66.202.99])
	by smtp4-1-sn2.hy.skanova.net (Postfix) with ESMTP id EAF5A37E42;
	Tue, 16 Aug 2005 12:08:45 +0200 (CEST)
Message-ID: <4301BB2C.807@gneto.com>
Date: Tue, 16 Aug 2005 12:08:44 +0200
From: Martin Nilsson <martin@gneto.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: sv, en-us, en
MIME-Version: 1.0
To: Patrick Dung <patrick_dkt@yahoo.com.hk>
References: <20050816071648.44019.qmail@web52108.mail.yahoo.com>
In-Reply-To: <20050816071648.44019.qmail@web52108.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd hackers <freebsd-hackers@freebsd.org>, vd@datamax.bg
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:08:49 -0000

Patrick Dung wrote:
> It consumes lots of space to do tar+gzip and split.
> I am thinking if I could copy all mysql files to another server  (by
> ftp/ssh) periodically. 

MySQL have something called RAID tables for filesystems where max 
filesize is 2GB (read old Linux ext2fs systems).
You can also use innodb tables and define may 2GB files to hold the 
database. These have the benefit of row-level locking and transactions 
as well!

Regards,
Martin


> 
> Regards
> Patrick
> 
> --- Vasil Dimov <vd@datamax.bg> wrote:
> 
> 
>>On Mon, Aug 15, 2005 at 11:41:09PM -0700, Patrick Dung 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?
>>>
>>
>>I guess this is not applicable, but what about using other "backup
>>product" that supports larger files?
>>
>>Otherwise tar(1) + gzip(1) (eventually) + split(1) seems reasonable
>>solution...
>>
> 
> 
> 
> __________________________________________________
> 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"
>