I must be missing something. The line I keep seeing everywhere for a consistent backup is:
mysqldump --single-transaction --all-databases > alldbs.sql
Yet the MySQL docs indicate
--opt is on by default. In that is
Also at MySQL docs under
--single-transaction that the use of
--lock-tables are mutually exclusive.
It seems to me the command line should be:
mysqldump --skip-opt (add in all the ones it uses except --lock-tables) --single-transaction --all-databases > ....
We have production servers that can't be locked for very long; ideally less than a minute. Any suggestions or can you educate me on what I may be missing here?