Backup problem for backup MySQL (a table > 2GB)

[Martin Nilsson]

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 at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
> To unsubscribe, send any mail to "freebsd-hackers-unsubscribe at freebsd.org"
>