Skip to content

Instantly share code, notes, and snippets.

@earnjam
Created December 9, 2017 11:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save earnjam/81b22ea63e33a48bb27629bfc6902f69 to your computer and use it in GitHub Desktop.
Save earnjam/81b22ea63e33a48bb27629bfc6902f69 to your computer and use it in GitHub Desktop.
Simple bash script to back up a phpBB database daily
#!/bin/bash
mysqldump --defaults-extra-file=/path/to/config.cnf db_name --single-transaction --quick --ignore-table=db_name.phpbb_search_wordmatch --ignore-table=db_name.phpbb_search_wordlist --ignore-table=db_name.phpbb_sessions > "/path/to/backups/filename-$(date '+%u').sql"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment