MySQL

Tools

• PHPMyAdmin

Common task

Change password

set password = password("yournewpassword");

Scripts

Hot backup - All databases

output="/srv/backup/mysql"
fecha=`date +%F_%T | tr \: _`
cd $output
mysqldump --all-databases --password=passwd | gzip > all-databases-${hoy}.sql.gz
find $output -type f -name "all-databases.*.sql" -ctime 8 -exec rm -f {} \;