ABSTRACT
This chapter focuses on the most common tools for generating backups in several formats or restoring MySQL databases. Physical backup methods have the following key characteristics: Because backup speed and concentration are important for active and important databases, the MySQL Enterprise Backup product completes physical backups. Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump command. A comma-separated values (CSV) file is a standard format that has a number of great benefits: In this section, we shall look through five methods to export the tables from MySQL to CSV via: using the command line, through mysqldump, MySQL Workbench, phpMyAdmin, or by using the CSV engine. Online backups are processed while the MySQL server is running so that the database information can be delivered from the server. Offline backups happen when the server is stopped.
