This method uses CRON under your own userid and pulls db_name and db_user information from your TTRSS config.php
Backup files will be stored in $home/ttrss_maint/db_backup/ and will be retained for 14 days.
Create a .my.cnf file in your home directory:
[mysqldump]
user=root
password=your_mysql_root_password
Secure the file: chmod 600 .my.cnf
Copy the contents of ../ttrss_utils/sample_conf/mariadb_db_backup_crontab into your crontab: crontab -e
Replace xxxxx with your account_name.
If you wish to run the backup manually:
- cd $home
- cd ttrss_maint/ttrss_utils
- ./mariadb_cron_backup