Sarathlal N

Create MySQL database backup using `mysqldump` - Linux Command

The mysqldump is a nice utility to performs logical backups that producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data.

The result of mysqldump is a flat text file & normally the size of the resulted file is little big. If we compress such text files, we can achieve good compression rates & it help to reduce our disk space usage.

mysqldump --user=$user --password=$password --host=$host $db_name > database.sql
gzip -v database.sql

If you like to compress database on the fly with only one command, check the below command.

mysqldump --user=$user --password=$password --host=$host $db_name | gzip > $daily_backup/${now}/database.sql.gz

This might be useful in situations where space is a problem and the full dump can’t be saved on the available storage directly because of its size.

Looking for a skilled WordPress/WooCommerce developer? I'm currently available for freelance, contract, or full-time remote opportunities! Let's create something amazing together. Send me a quick message, and I'll respond within 24 hours!

Recent Posts

  1. Understanding the Singleton Pattern and Using Traits to Achieve Singleton in WordPress Plugin Development
  2. REST API Methods Explained with Best Practices for Building Clean and Secure APIs
  3. My 28-Day Plan to Master Modern WordPress Development Using AI Tools
  4. Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
  5. WordPress Transients Explained - A Developer's Guide to Site Performance

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.