Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups. Let’s dive in and discuss some of the basics and best practices around backups for MySQL.

Logical MySQL Backups

In MySQL, it is possible to take backups in two different forms. The first form, logical, is the most universal. Essentially, you create all of the necessary INSERT statements to repopulate your table data. The two most popular tools in the area are mysqldump and mydumper.

mysqldump

This tool has been around since the beginning and supports a slew of different options, too numerous to discuss in this post.

Here is a simple example for taking a logical backup of the …

Now that we are in the New Year, it is time to settle back into work and make plans for 2013. As part of your professional development planning, consider Percona MySQL Training.

Percona will be holding the following MySQL Training classes in the first quarter:

• January
  • Live Virtual Training – DBA Training for MySQL: January 7-10, 2013
  • Chicago, Illinois, USA : January 14-17, 2013
  • London, UK: January 14-17, 2013
• February
  • Frankfurt, DE: February 4-7, 2013
  • San Francisco, CA, USA: February 4-7, 2013
• March
  • New York, NY, USA: March 11-14, 2013

To view these training events, and others, go to percona.com/training.