Backup mysql

= Backup mysql med log fil =

/usr/bin/mysqldump --defaults-extra-file=/home/vibbe/.my.cnf --all-databases --single-transaction --routines --triggers --events --flush-logs > /home/vibbe/mysql_backup_$(date +\%F_%H%M).sql 2>/home/vibbe/mysql_backup_log_$(date +\%F_%H%M).log

= Restore mysql =

/usr/bin/mysql --defaults-extra-file=/home/vibbe/.my.cnf < /home/vibbe/mysql_backup_2024-12-17_14-44.sql