Backing up and Restoring MySQL with mysqldump
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 backupscp $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
- Lev Lazinskiy
- Lev Lazinskiy
- Lev Lazinskiy
- SQLite DB Migrations with PRAGMA user_version
- Terminal RSS Reader With Nom
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- No-One Escapes the Permanent Underclass from Fernando Borretti
- Is it ethical to use AI? from charity.wtf
- The logical destination of LLMs from Andy Bell
- Revised rules of engineering leadership. from Irrational Exuberance
- 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
Articles from blogs I follow around the net
Pluralistic: How US states and international trustbusters can beat Big Tech (07 Jul 2026)
Today's links How US states and international trustbusters can beat Big Tech: Their common enemies are Trump and his tech giants. Hey look at this: Delights to delectate. Object permanence: Sex work synonyms; Carthedral; French pirates; Suffragette surveil...
via Pluralistic: Daily links from Cory Doctorow July 7, 2026Grayson Highlands Camping 2026
Grayson Highlands Camping 2026 A heatwave hit the east coast just in time for the July 4 weekend. It was over 100F (38C) in RVA. Luckily we were 240 miles away and 1 mile up camping, where the 80F (27C) temps also constitute a heat wave, but one I can hand...
via O'DonnellWeb July 6, 2026The great release notes of BBEdit
I have to admit that when a reader wrote to me and said… Every point release of BBEdit delights me. I live in BBEdit. It’s one of the few packages for which I read through the release notes every time (they often have spots of hilarity). …I got a bit conce...
via Unsung July 6, 2026Generated by openring