Hi, You can try mysql-zrm community edition.
For more details see - http://www.zmanda.com/backup-mysql.html http://mysqlbackup.zmanda.com/ Taking raw backup with snapshot (you should have database on a snapshot volume) will help, this is done in mysql-zrm using mysqlhotcopy. Using mysql-zrm-scheduler, backup's can be scheduled. Adjust it before amdump. In this case, the destination directory of mysql-zrm-backup will be the disklist entry in amanda configuration. Thanks, Sachin On 9/6/07, Marc Muehlfeld <[EMAIL PROTECTED]> wrote: > > Hi, > > fedora schrieb: > > Does amanda can backup and restore databases without any error of its > > integrity? I encountered 2 times when recovering databases. I can't do > > databases check integrity (myisamchk or mysqlcheck) even all the backups > > returns no error. I tried to recover those databases many times but only > 2 > > times I cant do the integrity checking. Was it caused by amanda or my > > settings? > > > You can't backup open database files and expect that they are fine after > you > recover them. > > > You have two ways: > > 1.) Shutdown mysql before you run amdump. Then your mysql server will be > offline during backup time. > > 2.) Export the databases to files e. g. using mysqldump and backup them. > Then > you have no downtime for your mysql server. > > > For the second way I wrote a script that exports the databases and tar.gzthem > together with my.cnf. If you use binary-logs then they are flushed and > backuped, too. You can find it here: > http://marc-muehlfeld.de/scripts/mybackup.sh > It's allready linked at the wiki, too: > http://mysqlbackup.zmanda.com/#Other_tools.2Fscripts_for_MySQL_backup > > Regards > Marc > > > -- > Marc Muehlfeld (Leitung Systemadministration) > Zentrum fuer Humangenetik und Laboratoriumsmedizin Dr. Klein und Dr. Rost > Lochhamer Str. 29 - D-82152 Martinsried > Telefon: +49(0)89/895578-0 - Fax: +49(0)89/895578-78 > http://www.medizinische-genetik.de > -- Sachin Kale Zmanda Inc., amanda.zmanda.com http://www.zmanda.com/backup-mysql.html
