Backing up and Restoring MySQL with mysqldump

| devops | databases |

I backup and restore databases across servers every few months, but each time I have to resort to reading this very verbose documentation. The steps below are a no fuss way to do this each time.

Backup Server

SSH into the server with the database that you wish to backup run the following command. 
mysqldump -u root -p $DB_NAME > $DB_NAME.sql

Copy the File to Destination Server

Using scp, we can securely transfer the backup 
scp $DB_NAME.sql $USER@$SERVER:

Restore on Destination Server

SSH into the server with the database that you wish to restore. From the the previous step the backup file should now be located in the root directory.
  1. Create new database 
    mysql -u root -p -e 'CREATE DATABASE $DB_NAME'
  2. Restore your backup 
    mysql -u root -p $DB_NAME < $DB_NAME.sql

Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.

Check out some more stuff to read down below.

Most popular posts this month

Recent Favorite Blog Posts

This is a collection of the last 8 posts that I bookmarked.

Articles from blogs I follow around the net

Social media reimagined

We’re all familiar with social media: the Facebooks, the Twitters, the TikToks of this silly digital world. They have invaded our lives and taken over our time and attention. We have spent the past decade posting, snapping, tweeting, reeling (?), …

via Manuel Moreale — Everything Feed March 19, 2026

Pokemon Go created a 3D map of the world – but for what?

You may have seen the recent headlines about how a company called Niantic Spatial is using a database of real-world locations that was originally compiled by players of the mobile game Pokemon Go — a game that launched about a decade ago and quickly becam…

via The Torment Nexus March 19, 2026

Pluralistic: Love of corporate bullshit is correlated with bad judgment (19 Mar 2026)

Today's links Love of corporate bullshit is correlated with bad judgment: Synergizing the strategic inflection points on the global data network. Hey look at this: Delights to delectate. Object permanence: Bluetooth headsets; Fruit sticker decoder; iP…

via Pluralistic: Daily links from Cory Doctorow March 19, 2026

Generated by openring