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

Why some people (including me) are spending more time on Twitter

Yes, I still call it Twitter. Mostly because I am old and set in my ways, but also because I have spent what feels like most of my life on there — certainly a large portion of my professional life — and for the vast majority of that time it

via The Torment Nexus October 15, 2026

Pluralistic: Expedia amazoned hotel rooms (15 Oct 2026)

Today's links Expedia amazoned hotel rooms: Everything more expensive for everyone, monopolies everywhere, and we're all screwed. Hey look at this: Delights to delectate. Object permanence: Delta v dovening; "Play Money"; Alabama's ethnic cleansing; We tru...

via Pluralistic: Daily links from Cory Doctorow October 15, 2026

“I hoped the system would have had more capacity for institutional reform than it has.”

Those are the words of Mike Bracken, the former head of the United Kingdom’s Government Digital Service (GDS), as he reflected on his departure back in 2015. “We now have a different set of ministers, a different group of permanent secretaries, and you hav...

via Sean Boots October 15, 2026

Generated by openring