Skip to content

Instantly share code, notes, and snippets.

@kudarap
Last active September 14, 2015 09:33
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 kudarap/c19a1fbc8e38a4313de3 to your computer and use it in GitHub Desktop.
Save kudarap/c19a1fbc8e38a4313de3 to your computer and use it in GitHub Desktop.
back up project files & mysql db
echo 'backing up ...'
# sql dump all
mysqldump -v -u dev -p --all-databases > mysql-`date '+%d-%m-%Y'`.sql
# project files
tar jcvf project-`date '+%d-%m-%Y'`.tar.bz2 /project/
# put all together
tar jcvf backup-`date '+%d-%m-%Y'`.tar.bz2 project-* mysql-*
# clean
rm -v mysql-* project-*
# done
echo 'back up done!'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment