Skip to content

Instantly share code, notes, and snippets.

@pauldruziak

pauldruziak/sql-backup.sh

Created February 23, 2010 14:03
Show Gist options
  • Save pauldruziak/312180 to your computer and use it in GitHub Desktop.
Save pauldruziak/312180 to your computer and use it in GitHub Desktop.
Download ZIP
Backup database schema and data
Raw
sql-backup.sh
data=`/bin/date +%d%m%Y%H%M%S`
mysqldump --user=USER --password=PASSWORD --no-data DATABASE > /home/USERNAME/backup/sql-dump-schema.sql
mysqldump --user=USER --password=PASSWORD --no-create-info DATABASE > /home/USERNAME/backup/sql-dump-data.sql
gzip --best /home/USERNAME/backup/sql-dump-schema.sql
gzip --best /home/USERNAME/backup/sql-dump-data.sql
/bin/mv sql-dump-schema.sql.gz sql-dump-schema-${data}.sql.gz
/bin/mv sql-dump-data.sql.gz sql-dump-data-${data}.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment