Le jeudi 06 septembre 2007, fedora a écrit :
>
> Hi guys,
>
> I need u guys experiences who are close and familiar with amanda. I used
> amanda to backup my databases in /var/lib/mysql.
> 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?
> Please advice guys.
I solve this using a custom cron script that calls mysqldump on the remote
machine before calling amdump, and I save the generated dump file, not the
raw MySQL files.
Big win, because it means that I can use this dump to restore the database on
_another_ machine without any problem (granted, I always use the same charset
for MySQL databases, so it's easier).
--
Francis Galiegue, One2team - fg AT one2team DOT com
[ATTENTION : CHANGEMENT DE COORDONNÉES !]
+33178945570, +33683877875, http://www.one2team.com
40 avenue Raymond Poincaré - 75116 PARIS
|