Knowledge Base

Overview 

By the end of this article, you will understand how CodeGuard backs up MySQL databases and why those backups stay consistent without disrupting your live site. It explains the mysqldump tool, the single-transaction option that keeps data consistent, and the settings that keep server load low while a backup runs. 

How CodeGuard backs up MySQL databases 

CodeGuard backup uses the industry-standard mysqldump tool to back up MySQL databases. MySQL is a widely used relational database system, and mysqldump lets the live database keep running during a backup while ensuring the integrity and consistency of the saved data. 

How the backup stays consistent 

The mysqldump runs with the single-transaction option, which captures a consistent snapshot of the database without locking it. Combined with the quick and skip-extended-insert options, this lets CodeGuard back up a live database at a single point in time without blocking your applications. 

Keeping server load low 

CodeGuard's mysqldump backups are designed for low server load, so your website keeps running normally while a backup runs in the background. More detail on how mysqldump works is available in the MySQL reference manual: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html 

Similar questions 

•  What tool does CodeGuard use to back up MySQL databases? 

•  Does CodeGuard lock my database during a MySQL backup? 

•  How does CodeGuard keep MySQL backups consistent?