Mysql backup

[Stephan]

Hi guys.

I need to back up a mysql db on a Linux box. I've been searching around here and there and found a couple of options...

- a simple dump of the DB and then flat file backup
- ADSMPIPE
- Repostor's TSM for MySQL
- Zmanda
etc...

I'm i just looking into it too much? What do you guys do? Simple dump of the file? through scripts which then backs it up? Pre/postschedule commands? ADSMPIPE?

Thanks.

 

[moon-buddy]

Stephan,

Don't look at this too much. All that is needed is a simple dump and backup routine, and you can use TSM for this.

 

[Stephan]

thanks moon-buddy. I am guessing that the flat file dump of the mysqldump command will be bigger than the actual DBsize right? Does a sqldump take a long time? Can it be done anytime without impacting the environment? Can it be cancelled cleanly if something goes wrong?

thanks.

 

[Kramer]

When I backup mysql, I do the mysqldump (which is pretty big), and then run it through bzip2, which packs it down nicely for storage on disk or backup.

 

[Stephan]

Thanks Tomas.
I'll surely take a look at that option.

Steph

 

[storage.guy]

Zmanda MySQL Backup is now integrated with Tivoli Storage Manager:

http://www.zmanda.com/tivoli-mysql-backup.html

 

[daleto]

Data Protector for MySQL using IBM Tivoli Storage Manager is very fast as all data is sent directly to / from TSM.

http://www-304.ibm.com/software/brandcatalog/ismlibrary/marketplace/details?catalog.label=1TW10SM1S