Re: MySQL Integrity
2007-09-06 02:20:45
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.gz them
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
|
|
|