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

[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 <dmitry.mityugov at gmail.com> wrote:

> On 8/16/05, Patrick Dung <patrick_dkt at 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