Ubuntu 16.04. There are several sites on a dedicated server and each has its own database. When I create a backup of one of the databases:
mysqldump -uroot -p admin_db1 --opt --routines --lock-all-tables | gzip > /backup/admin_db1.sql.gz All other sites are not available. Why is that?
Parameters --opt --lock-all-tables I use to "block" from any changes at the time of the backup the corresponding database.