Hi Marc, 

I have to open this case back :-D. I found in ur script got this line:
mysqldump -u $MYSQLUSER -p$MYSQLPASSWD $DB -e -a -c --add-drop-table
--add-locks -F -l > "$TMPDIR/db_exports/$DB.sql"

May I know if I dont want to lock all tables ( -l )and around insert
statement ( --add-locks ), can I remove those options?. It is because all my
databases should not be locked for all times even a few seconds and it is
always update.


Marc Muehlfeld-2 wrote:
> 
> 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
> 
> 

-- 
View this message in context: 
http://www.nabble.com/MySQL-Integrity-tf4389486.html#a13524662
Sent from the Amanda - Users mailing list archive at Nabble.com.