Categories: Linux Administration

How to Create a mySQL Backup using Command Line

Whether you’re running a LAMP stack on Ubuntu or CentOS, it is usually very good practice to back up your MySQL databases to prevent data loss.

Here we will teach you how to do this with the help of the mysqldump command.

Your Ubuntu Server is now up and running with a LAMP stack in your data center, and on that server you setup yourself runs a database or maybe even a few databases for that matter. Things are getting exciting and then you remember. They must be backed up.

What you will need

If you already have MySQL up and running and all the necessary software is already installed, you are already on the right track.

In order to start this task of backup, you will need to make sure that you have the password for the MySQL user that has access permissions to the database(s) in question.

MySQL provides a great command line utility to take backups of your MySQL database. mysqldump command line utility is available with MySQL installation (bin directory) and can be used to achieve this.

Step by Step

  1. Login to your server with root user
  2. Use following command for taking backup of your MySQL database using mysqldump utility.

mysqldump –u[user name] –p[password] [database name] > [dump file]

Now to make sure the command was executed and the backup file was created using the command

ls –l

on the same path and you should see the database backup file.

Backing it all up

Don’t want to just backup one database? No Problem!

If you want to back up all of your databases, you can accomplish this with the –all-databases option, like so:

mysqldump -u USER -p --all-databases > /mnt/backups/all_databases.sql

And That’s It!

Congrats! You’ve successfully backed up your MySQL databases successfully. Now save them somewhere safe, and hopefully you’ll never need to revert them due to a failure.

serverhub

Recent Posts

Fail2Ban: Protect Your Linux System from Brute-Force Attacks – Open-Source Security Tool

Fail2Ban is an intrusion prevention software framework, written in the Python programming language. It is…

5 days ago

ISPConfig: The Open-Source Control Panel for Effortless Web Hosting Management

ISPConfig is an open-source hosting control panel for managing web hosting services. It provides a…

3 weeks ago

FirewallD: Dynamic Firewall Manager – A ServerHub Comprehensive Guide

Firewalld is a dynamic firewall management tool for Linux systems that simplifies network traffic control…

1 month ago

Learn About Let’s Encrypt: A Free SSL/TLS Certificate Provider

Let's Encrypt is a nonprofit certificate authority offering free, automated, and open digital certificates for…

2 months ago

Cloudflare: Content Delivery Network and DDoS Mitigation for Website Performance and Security

In today’s digital world, speed, security, and reliability are paramount when it comes to delivering…

2 months ago

How to Use the Right Protocols to Monitor Network Traffic

Network Monitoring is the process of discovering, mapping, and monitoring a computer network to ensure…

3 months ago

This website uses cookies.