The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects, table data, or both. If your database is extremely large, and for databases in a production environment, you might want to consider using MySQL Enterprise Backup (mysqlbackup), which is part of the MySQL Enterprise Edition.įor those of you that aren’t familiar with mysqldump: And we will look at using the MySQL binary log (binlog) along with mysqldump for point-in-time recovery. This post will be a quick guide to using mysqldump to backup and restore your databases. I have already written several posts on using mysqldump.

– Creating and restoring database backups with mysqldump and MySQL Enterprise Backup – Part 2 of 2 – Creating and restoring database backups with mysqldump and MySQL Enterprise Backup – Part 1 of 2 – Splitting a MySQL Dump File Into Smaller Files Via Perl – Scripting Backups of MySQL with Perl via mysqldump For a detailed overview on how to create a MySQL dump file, please check the video below.Be sure to check out my other posts on mysqldump: The creation of a MySQL backup dump using the PHPMyAdmin tool is simpler than ever, you just need to use its internal export function to create a dump file in various formats. PHPMyAdmin provides us with a feature-rich graphic environment. If you wish to perform a MySQL dump manually, without using a PHPMyAdmin tool or other graphic environment, you need to connect to your database via SSH and run the following command: An example on how to create a MySQL dump using the SQL command line mysqldump -tab=/path/to/some/dir -opt database_name How to create a MySQL dump file using the PHPMyAdmin tool How to create a MySQL dump via the SQL command line The MySQL dump backup solution is suitable for backing up whole databases, as well as a single database table.

Also, if you're planning to make some changes to your database, it is a good idea to create first a MySQL dump. Using a MySQL dump you can easily migrate (all the contents of) your website from one hosting provider to another. It is a bit slower than a raw backup, since it covers all SQL queries required to re-create the tables of the database, as well as all insert queries required to place the information back into the database's tables. However, no matter which application, control panel tool, or SSH script you use, all backups can be either dump or raw backups.Ī MySQL dump is a universal backup solution. There are different ways to perform a MySQL backup. The whole backup and restore process is extremely easy indeed once you have learnt how to do it.

You should know also that MySQL databases are simply files stored on your web server.

Mysql dump sql command