Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment