Hello! I would like to make a backup of the databases. However, under Sites > Domain > Backup you can only select the backup interval, the number of backup copies and the excluded folders. I only want to backup the databases available for the web and not folders. Can anyone help?
if you look further down, there are buttons to manually create a backup of just the database(s) or of just the website files. also, if you go to Sites -> Databases, and select a database, you can set a backup schedule (daily/weekly/monthly) for that database there. although the settings there don't let you set the number of backups you want to keep.
I've seen the manual option. However, I would like an automatic one. Would it help if I included all subfolders in the web area (/var/www/abc.xy) in the "Excluded Directories" line? Would then only the databases be backuped?
no. database files/tables are stored in /var/lib/mysql/<dbname>/ set the backup schedule you want backups under sites -> domain -> backup and the number of copies you want to keep. that should backup both website files and databases. you can go to sites -> databases -> database to set a different schedule for db backups if you want it to be different. i assume it still picks up the number of copies to keep from the website settings, but not 100% on that. it would be nice to be able to fully set backup schedules.. ie set both time and date.. for both site and db separately. alternatively, you can use automysqlbackup to backup databases separately from ispconfig. i'm also considering looking at mariadb-backup, to maybe run hourly incremental backups during the day.
