Back up MySQL with mysqldump
Backup Software / Backup Terms Glossary / Databases / MySQLDump
The mysqldump utility is a free software allowing “logical” backup of any MySQL database by saving it to a text sequence of SQL queries. Originally developed by Igor Romanenko at 1999, now it grows to one of main functional utilities of MySQL environment.
The resulting file created by mysqldump, a database dump, contains the SQL statements needed to build the database from scratch. These statements are independent from the original database. Executing this sequence will restore the database, e.g. for MySQL replication.
The main advantage of dump files created with mysqldump is that they have a very simple and readable internal format. A user can rewrite these dump files manually as it needed, which makes dumps a perfect source for experiments.
For example, let you have a MySQL database with multiple tables, and an application (e.g. a web server) working with it. Each table can use its individual storage engine.
Two key factors define the performance of your application:
That is what database architecture design is about.
Performance of MyISAM and InnoDB under different MySQL writing loads
Files created by mysqldump can be modified with any text editor, which makes it really easy to test different combinations of storage engines, and find out what works for you. Moreover, it also enables you to prepare a plan on how to deal with future database load. The plan is as follows:
In the following video tutorial, you can learn how to back up and restore MySQL databases with Handy Backup.
Note: Instructions in this video suggest that you already have Handy Backup installed on your computer. If you still have not done so, do not hesitate to download it.
Handy Backup extends the functionality of mysqldump utility with multiple options typically used in different backup strategies. For example, your MySQL tables can be automatically compressed, encrypted, and stored onto a given FTP or SSH server.
Handy Backup provides a full spectrum of backup automation settings and options, from compressing data to scheduling events to logging performed tasks. To learn more about MySQL backup with Handy Backup, please refer to MySQL Backup Features.
Version 8.0.0, built on 4 March, 2019. 104 MBBackup Software from Novosoft LLC. 249 USD per license.
To create MySQL dump files, you need the Small Server edition of our software developed for small business backup purposes. Free 30-days trial!
Another scenario in which dump files created by mysqldump or Handy Backup can be useful is migration from MySQL to other database management systems. All popular DBMS aim to comply with the SQL standard, with only some minor changes required for a typical dump file.
To see if you can transfer your MySQL data to another DBMS, you can simply make a dump and try to restore it to a different system. You can read main recommendations on performing this task on the MySQL Recovery page.
Version 8.0.0, built on 4 March, 2019 104 MB
Copyright © 2004-2019 Novosoft LLC. All rights reserved. Handy Backup software.
10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top