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

tweet

17 conversations in Jakarta, Indonesia: https://sive.rs/met/at-14

via Derek Sivers July 3, 2026

You’ll miss the soul when it’s gone

Pretty grim day of news in the industry today, with Salma Alam-Naylor stepping away from developer relations work permanently, Josh Comeau taking a sabbatical from making courses and GSAP’s once-vibrant forums descending into a ghost town. The reason your...

via Andy Bell July 3, 2026

Midnight Train to Stockholm

I was recently summoned to a meeting in Stockholm, a city I had somehow managed to avoid despite living in Copenhagen for years. My Swedish experience, up to this point, consisted entirely of trips to Malmö — the closest Swedish city to Denmark and, more i...

via matduggan.com July 3, 2026

Generated by openring