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.
