Un backup mysql propre

mysql -uxxx -pyyyy -e "FLUSH TABLES WITH READ LOCK"

mysqldump -uxxx -pyyyy --databases <listedb> > nomback.sql

mysql -uxxx -pyyyy -e "UNLOCK TABLES"

Comments