Skip to content
Sign In Get Started

mysqldump

  1. Back up and restore a databaseBack up and restore a databaseUse mysqldump to export your database, gzip the file, and copy it off the server. Restore into a spare schema first so you can verify the data before…Updated Aug 29, 2026
  2. mysqldump flags that save youmysqldump flags that save youUse mysqldump with --single-transaction and --quick so InnoDB dumps stay consistent without locking the shop. Pipe through gzip, and skip --add-drop-database unless you mean it.Updated Aug 29, 2026