Mediawiki: Difference between revisions
→Backup Script
m (Protected "Mediawiki" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite))) |
|||
| (4 intermediate revisions by the same user not shown) | |||
Line 50:
{{UC}}
= Backup Script =
mysqldump -u root -ppwd@123 my_wiki | gzip > /home/aman/Backup/my_wiki-$(date +"%d-%b-%Y").sql.gz
echo "$(date +"%d-%b-%Y"): MYSQL DB backup done" >> /home/aman/Backup/status.log
sleep 2
tar cfz /home/aman/Backup/images-$(date +"%d-%b-%Y").tar.gz /var/www/html/images/
echo "$(date +"%d-%b-%Y"): Images Backup Done" >> /home/aman/Backup/status.log
sleep 2
tar cfz /home/aman/Backup/LocalSettings-$(date +"%d-%b-%Y").tar.gz /var/www/html/LocalSettings.php
echo "$(date +"%d-%b-%Y"): LocalSettings Backup done" >> /home/aman/Backup/status.log
exit
If you dont want gzip compression:
mysqldump -u root -ppwd@123 my_wiki > /home/aman/Backup/my_wiki-$(date +"%H%M%S-%d-%b-%Y").sql
*Run Backup every week at 5:00AM:
* 5 * * 1 /home/aman/backup-wiki.sh 2>&1 >> /home/aman/Backup/cron_output.log
* Logrotate:
sudo nano /etc/logrotate.d/backup-wiki
<pre>
/home/aman/Backup/*.sql.gz {
weekly
missingok
rotate 3
maxage 7
compress
notifempty
}
</pre>
sudo logrotate /etc/logrotate.conf --debug --force
= Restoring From Backup =
| |||