Is there any proper mysql backup that can backup database without stopping it?? If so, I don't have to worry about it? Of course it wasn't failed but I just worried if I recover it and the database or tables might be corrupt just because Amanda detected strange. Please advice.
Olivier Nicole wrote: > >> FAILED AND STRANGE DUMP DETAILS: >> >> /-- ind.ayo.com /var/lib/mysql lev 0 STRANGE >> sendbackup: start [ind.ayo.com:/var/lib/mysql level 0] >> sendbackup: info BACKUP=/bin/tar >> sendbackup: info RECOVER_CMD=/bin/gzip -dc |/bin/tar -f - ... >> sendbackup: info COMPRESS_SUFFIX=.gz >> sendbackup: info end >> | gtar: ./mysql.sock: socket ignored >> ? gtar: ./mysql/general_log.CSV: file changed as we read it > > Means that the file mysql/general_log.CSV was getting modified while > tar was trying to save it. Most probably this file has not been > included (or included wrongly) in your amanda backup. > > You have to understand that it takes some amount of time for tar to > make a copy of a *big* file. If that big file is changing often, it is > very likely it will be changing while tar is trying to copy it. There > is very little you can make about it, except stopping mysql while you > are doing th backup :) > > Actually, this is only a STRANGE, not a FAIL. > > A bit of auto promotion, this page > https://wwws.cs.ait.ac.th/amanda/operator.shtml reccords a number of > Amanda error message and the explanation for it, and possible recovery > action. > > Olivier > > -- View this message in context: http://www.nabble.com/FAILURE-AND-STRANGE-DUMP-SUMMARY-tf3788077.html#a11022275 Sent from the Amanda - Users mailing list archive at Nabble.com.
