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 <[EMAIL PROTECTED]> 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 "[EMAIL PROTECTED]"


_______________________________________________
freebsd-hackers@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to