3 ms·

Afaik, the free version of MySQL doesn't let you do a live transaction-safe database dump of InnoDB tables. A pretty basic feature I thought, which is included

by Andys 16y ago

Afaik, the free version of MySQL doesn't let you do a live transaction-safe database dump of InnoDB tables. A pretty basic feature I thought, which is included in the free version of PostgreSQL.

nodata 16y ago
Well you can almost get there (completely if you're not changing schemas): mysqldump --single-transaction This option sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.
- mrj 16y ago
  Unfortunately, mysql still doesn't have transactional DDL, I believe...
  - koenigdavidmj 16y ago
    Nor does Oracle, for what it's worth.
spudlyo 16y ago
This is incorrect. You can use XtraBackup for this which is an open source alternative to innodb hot backup. Alternately you can quickly lock tables and take a filesystem snapshot or even run mysqldump with --single-transaction all which will let you get a consistent dump of a set of InnoDB tables.