MySQL comes with: mysqldump: Logical Backup tool, for MYSAM can be implemented Win Bei, InnoDB can be hot standby mysqlhotcopy: Physical Backup tool (warm backup) file system Tools: For example, you use the CP command directly under Linux (Cold backup), Win the following copy (cold backup) LVM snapshot feature can achieve almost hot backup LVM snapshot backup MyISAM and InnoDB engine data should be noted: for MyISAM use of LVM snapshot backup needs to execute SQL command flush tables in MySQL The lock TABLE can then create the snapshot, release the lock after creation is complete, and then copy the data after the snapshot is created. For InnoDB, use flush tables; and lock tables; The command also monitors the INNODB storage engine to ensure that its buffer data is synchronized to disk, which can take a significant amount of time. Third-party tools: a business tool for InnoDB backup Ibbackup, requires a server 5000 open source tools: Xtrabackup, Free and more powerful than ibbackup
About MySQL backup tools
