[Script] Automatic backup bases

[Wizatek]

Why not just use HeidiSQL instead of navicat?

 

And to make a database backup i prefer to make a cronjob, auto backup every xx hours and upload the backup to a external server

 

 

backup.sh

BACKUPFILE=/home/backup/MySQLDB_`date +%Y-%m-%d-%H`.sql.gz
mysqldump -u root -pPASSWORDHERE --databases newproject_auth newproject_db newproject_web | gzip > $BACKUPFILE

export SSHPASS=SSHPASSWORDFROMEXTERNALSERVERHERE

sshpass -e sftp -oBatchMode=no -b - IPADDRESSOFEXTERNALSERVER << !
put $BACKUPFILE
bye
!