Backup mysql: Skillnad mellan sidversioner
Vibbe (diskussion | Bidrag) Skapade sidan med '= Backup mysql med log fil =<pre> /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 </pre> = Restore mysql =<pre> /usr/bin/mysql --defaults-extra-file=/home/vibbe/.my.cnf < /home/vibbe/mysql_backup_2024-12-17_14-44.sql </pre>' |
Vibbe (diskussion | Bidrag) mIngen redigeringssammanfattning |
||
| Rad 1: | Rad 1: | ||
= Backup mysql med log fil =<pre> | == Backup mysql med log fil == | ||
<pre> | |||
/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 | /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 | ||
</pre> | </pre> | ||
| Rad 7: | Rad 8: | ||
= Restore mysql =<pre> | == Restore mysql == | ||
<pre> | |||
/usr/bin/mysql --defaults-extra-file=/home/vibbe/.my.cnf < /home/vibbe/mysql_backup_2024-12-17_14-44.sql | /usr/bin/mysql --defaults-extra-file=/home/vibbe/.my.cnf < /home/vibbe/mysql_backup_2024-12-17_14-44.sql | ||
</pre> | </pre> | ||
Nuvarande version från 17 december 2024 kl. 15.05
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