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

2005-08-16 Thread Patrick Dung
Opps, it should be gzip -c, instead of gzip -dc --- Patrick Dung <[EMAIL PROTECTED]> 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

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

2005-08-16 Thread Patrick Dung
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 <[EMAIL PROTECTED]> wrote: > On 8/16/05,

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

2005-08-16 Thread 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 u

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

2005-08-16 Thread Dmitry Mityugov
On 8/16/05, Patrick Dung <[EMAIL PROTECTED]> 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 curr

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

2005-08-16 Thread Patrick Dung
The main problem is money. Buying a new product needs money. The old backup product (commercial) is scalable and is working fine with various OS. However it is outdated and is not supported anymore (unless we have a service agreement with the vendor of the backup product.) It consumes lots of spa

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

2005-08-16 Thread Vasil Dimov
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? > Th

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

2005-08-15 Thread Patrick Dung
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 <