mysqldump --single-transaction --routines --triggers --events appdb > appdb.sql

Category: Databases & SQL

mysqldump --single-transaction --routines --triggers --events appdb > appdb.sql

Take a consistent dump with routines

--single-transaction produces a point-in-time snapshot of InnoDB without locking tables, while --routines, --triggers, and --events include stored procedures, triggers, and scheduled events that plain dumps omit. The standard online backup recipe.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.