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 flat files

This is a physical backup method whereby you take a backup by directly copying the files inside data directory. Since new data is written while you copy the files, the backup will be inconsistent and cannot be used. To avoid that, you have to shut down MySQL, copy the files, and then start MySQL. This method is not used for daily backups but is well suited during maintenance windows for upgrades or downgrades or while doing a host swap.

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