This list will be updated periodically. Every time I feel that something will be useful and make my life easier :)
Create daily backups of your working database set on your desktop/dev machine
- Open console as root
- Paste in console:
crontab -e
- Edit the user, password, path and filename pattern, the desired time to run the job and paste in crontab:
10 11 * * * mysqldump -u root -p<password> --all-databases | gzip > /<path>/local_database_$(date +\%Y-\%m-\%d).sql.gz
hint: use https://crontab.guru/every-day-at-1am amazing site if you want the validate your cron jobs periods.
- Save
- Check with this command your result (after at least on cron cycle)
grep CRON /var/log/syslog
.
Check your free space from a console in Treesize style
sudo du -chd 1 | sort -hr
Install HeidiSQL in Ubuntu
check this link from AskUbuntu
Views: 49