Backupscript för mysql

Posted Posted in Tips and tricks

#!/bin/bash dbuser=”USERNAME” dbpass=”PASSWORD” db=”wordpressdata” tmppath=”/tmp” dbpath=”/db_backups/” timestamp=$( date “+%Y-%m-%d_%H-%M” ) filename=”wordpressdata_$timestamp.sql.gz” host=”X.X.X.X” backup=$( mysqldump –events –routines –single-transaction –skip-comments –quick -u […]