Backing up and Restoring MySQL with mysqldump

October 13, 2017 | 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.

Create new database

mysql -u root -p -e 'CREATE DATABASE $DB_NAME'

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.

The circus freaks of open source from Drew DeVault's blog
Clanker: A Word For The Machine from Armin Ronacher's Thoughts and Writings
I ran a half-marathon! from gluecko.se
My Running Tips from Kevin Bell's Blog
tweet from Derek Sivers blog
My life was changed by four sentences in four books from Derek Sivers blog
The world reveals itself to those who travel by foot from Escaping Flatland
45 things from Sean Voisen

Articles from blogs I follow around the net

Sunday Steamy Sunday

Sunday Steamy Sunday I was supposed to get up and go birding this morning, but it was going to be 87F (28C) and very humid by the time we finished, so I'm here blogging from the comfort of my air-conditioned home instead. We planned on heading into Richmon...

via CHRISOD.ORG June 14, 2026

Publishing WASM wheels to PyPI for use with Pyodide

The Pyodide 314.0 release announcement (via Hacker News) includes news I've been looking forward to for a long time: You can now publish Python packages built for Pyodide (or any Python runtime compatible with the PyEmscripten platform defined in PEP 783)...

via Simon Willison's Weblog: Entries June 13, 2026

“They had the simplest task in the world.”

This is a really nice set of transitions when pinching in and out in Photos in iOS 26. This is trickier than it seems, because it’s not just a linear zoom (like it would be in Maps or Sketch, for example). It’s a zoom and reflow – from 3 items to 1 item pe...

via Unsung June 13, 2026

Generated by openring