Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Current datetime
- now="$(date +'%Y%m%d-%H%M')"
- # DB credentials
- db_name=my_db_name
- db_host=my_db_hostname
- db_user=my_db_user
- db_password=my_db_password
- ### EXAMPLE ###
- #db_name=db_teste
- #db_host=localhost
- #db_user=user
- #db_password=123456
- # Backup file
- sql_file='db_backup_'$now'.sql'
- echo 'Backing up the database on the backup folder'
- mysqldump -h $db_host -u $db_user -p$db_password -v $db_name | gzip > './backup/'$sql_file'.gz'
- # Para voltar o backup
- # gunzip < dump.sql.gz | mysql -u USUARIO -pPASSWORD
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement