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
- SQLite DB Migrations with PRAGMA user_version
- Using cgit
- Lev Lazinskiy
- Convert Markdown to PDF in Sublime Text
- Making cgit Pretty
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- AI Mania Is Eviscerating Global Decision-Making from Ludicity
- 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
Articles from blogs I follow around the net
Pluralistic: AI solipsists and AI cynics (24 Jul 2026)
Today's links AI solipsists and AI cynics: You don't have to believe that AI "works" to believe that it's a good investment. Hey look at this: Delights to delectate. Object permanence: Malware v stolen computer; Industrial material made from old coffee and...
via Pluralistic: Daily links from Cory Doctorow July 24, 2026Safari and system design, pt. 2
Around the time I was writing about iPhone’s Safari breaking the expected “tap to jump to the top” gesture, a conversation on social media pointed to yet another thing that this tab control does strangely. A typical use of Safari means two groups of sites:...
via Unsung July 23, 2026Issue 107 – An unserious offer
The crypto industry has spent $200 million to get a bill too corrupt for Democrats to pass and a president too corrupt to sign anything that might meaningfully limit his grift.
via Citation Needed July 23, 2026Generated by openring