When I needed to take a mysql dump from one database, I needed to make sure that it wasn’t going to bring down the database and thus damage the application.
With a few MySQL options, this can be avoided:
mysqldump -uroot –single-transaction –routines –triggers databasename | gzip -c | ssh root@some-server “cat > /folder/databasename.sql.gz”