Skip to content

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

Get new articles in your inbox

Practical tutorials and deep dives, about once a week. No spam, unsubscribe anytime.

Privacy policy

Add DEV Talk to your Home Screen

  1. 1 Tap the Share button in Safari's toolbar.
  2. 2 Scroll down and tap Add to Home Screen.
  3. 3 Tap Add. Open it from the Home Screen to read like an app and to turn on notifications with the bell.

We use cookies to improve your experience and analyze traffic. By continuing, you agree to our Privacy Policy.