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.

    1 answer 1

    --lock-all-tables, -x

    Specifying this parameter causes all tables in all databases to be locked while a full dump of all databases is being created.

    --lock-tables, -l

    Specifying this option locks the database tables for which the dump is being created.