Code snippets
Code snippets
Copy-ready answers to everyday coding questions, each with a short explanation. Laravel, PHP, JavaScript, SQL, Bash and more.
2 snippets tagged #backup · Show all
SQL
October 20, 2026
MySQL backup and restore a database with mysqldump
Dumps a database to a file and restores it later. --single-transaction gives a consistent backup of InnoDB tables without locking them.
# Backup
mysqldump -u root -p --single-transaction mydb > mydb.sql
# Backup compressed
Bash
October 17, 2026
Linux compress and extract tar.gz and zip archives
Creates and unpacks the two most common archive formats.
tar -czf backup.tar.gz folder/ # create tar.gz
tar -xzf backup.tar.gz # extract
tar -xzf backup.tar.gz -C /target/ # extract to a folder
zip -r site.zip folder/ # create zip