For a mixed MySQL database environment that comes with both MyISAM and InnoDB storage engines, perhaps a better choice to back up is to use innobackup.
对于具有MyISAM和in noDB存储引擎的混合式MySQL数据库环境,进行备份的更好的方法可能是使用innobackup。
This article focuses primarily on backup and restore using MyISAM and InnoDB storage engines, as they are the most commonly used engines in the MySQL world.
本文主要关注使用MyISAM和In noDB存储引擎进行备份和恢复,因为它们是MySQL中最常用的引擎。
It USES auto_increment primary key, which causes table-level locks in InnoDB for all MySQL versions prior to 5.1.21.
使用了auto_increment主键,对于MySQL 5.1.21之前的版本都会导致in noDB使用表级锁。
应用推荐