Backup mysql
Backup mysql med log fil
[redigera | redigera wikitext]/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
[redigera | redigera wikitext]/usr/bin/mysql --defaults-extra-file=/home/vibbe/.my.cnf < /home/vibbe/mysql_backup_2024-12-17_14-44.sql