O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Taking backups using mydumper

mydumper is a logical backup tool that's similar to mysqlpump.

mydumper has these advantages over mysqldump:

  • Parallelism (hence, speed) and performance (avoids expensive character set conversion routines and has efficient code overall).
  • Consistency. It maintains snapshots across all threads, provides accurate master and slave log positions, and so on. mysqlpump does not guarantee consistency.
  • Easier to manage output (separate files for tables and dumped metadata, and it is easy to view/parse data). mysqlpump writes everything to one file, which limits the option of loading selective database objects.
  • Inclusion and exclusion of database objects using regex.
  • The option to kill long-running transactions that block ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required