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
- Now What?
- Setting up ANTLR4 on Windows
- SQLite DB Migrations with PRAGMA user_version
- Meritocracy?
- Possible Plagiarism Made me Cringe
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- The Rise of Bluesky from Communications of the ACM
- Podcaster, DJ, and writer DJ Louie XIV on going for it (even if you’re terrified) from The Creative Independent
- Useful Bluesky Tools from Robb Knight • Posts • Atom Feed
- Re: Bluesky from Colin Devroe
- From the Red Hell to the Sky of Blue from Straphanger
- We don’t need to use what we make from Derek Sivers blog
- Ubuntu Summit 2024: A joyful experience filled with sorrow from Planet KDE | English
- Sabotage from jwz
Articles from blogs I follow around the net
Pluralistic: Battery rationality (06 Dec 2024)
Today's links Battery rationality: Ringing down the curtain on 9/11's security theater. Hey look at this: Delights to delectate. This day in history: 2009, 2014, 2019, 2023 Upcoming appearances: Where to find me. Recent appearances: Where I've…
via Pluralistic: Daily links from Cory Doctorow December 6, 2024P&B: Erica Fustero
This is the 67th edition of People and Blogs, the series where I ask interesting people to talk about themselves and their blogs. Today we have Erica Fustero and her blog, ericafustero.com To follow this series subscribe to the newsletter. …
via All the interviews for the People and Blogs series. December 6, 2024P&B: Erica Fustero
This is the 67th edition of People and Blogs, the series where I ask interesting people to talk about themselves and their blogs. Today we have Erica Fustero and her blog, ericafustero.com To follow this series subscribe to the newsletter. …
via Manuel Moreale RSS Feed December 6, 2024Generated by openring