DB dump consistency

[Horkyze]

Correct me of I am wrong, but I noticed that while executing the mysqldump command, it is without the option --single-transaction nor --lock-tables (for InnoDB and MyISAM respectively), hence the consistency of the dump is not guaranteed. This is really bad and can cause a lot of issues when restoring the dump.

Another fact it, the mysqldump can also take --quick option to create the dump faster (for large table).

Same goes for mariadb, and perhaps psql.