MySQL backup tutorial

Home - Tutorials - MySQL

In this tutorial I will show you a short and simple way how to create a backup copy of your MySQL database using the mysqldump utility.

Tutorial info:

Bookmark MySQL backup tutorial

Step 1 - MySQL backup with mysqldump

MySQL backup tutorial

I don't want to collect all of the reasons why a backup is important. If you are reading this page you probably know them.

MySQL backup solutions:

There are many ways how you can create a backup with MySQL. Here is a list of the most important backup groups:

• Logical vs. physical backup
• Online vs. offline backup
• Local vs. remote backup
• Full vs. incremental backup

Besides this the backup possibilities depend on what kind of database engine you use. In this tutorial I only demonstarte mysqldump as it is more general than the others and can backup all kind of tables.

Using mysqldump to backup your data:

Mysqldump creates an sql file as the result of the backup. Later you simply can execute this file to recreate the MySQL database.

You can backup only some tables, the complete database or all available databases depending on how you call mysqldump. The most simple way to backup a single MySQL database is the following:

Code: 
mysqldump -r c:\backup\myDb.sql myDb
Database F1

This code generates the backup of the myDb database in the c:\backup directory.

Tags: mysql backup tutorial, mysql backup mysqldump, mysql backup, mysqldump backup, mysql, backup