Guest User

Untitled

a guest
Apr 30th, 2018
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. data=`/bin/date +%d%m%Y%H%M%S`
  2. mysqldump --user=USER --password=PASSWORD --no-data DATABASE > /home/USERNAME/backup/sql-dump-schema.sql
  3. mysqldump --user=USER --password=PASSWORD --no-create-info DATABASE > /home/USERNAME/backup/sql-dump-data.sql
  4. gzip --best /home/USERNAME/backup/sql-dump-schema.sql
  5. gzip --best /home/USERNAME/backup/sql-dump-data.sql
  6. /bin/mv sql-dump-schema.sql.gz sql-dump-schema-${data}.sql.gz
  7. /bin/mv sql-dump-data.sql.gz sql-dump-data-${data}.sql.gz
Add Comment
Please, Sign In to add comment