Hi, In my multiserver-setup the DB-Backups don't work 100% correctly: The backups are created, and are saved on the db-server in /var/backup/. But in the ISPConfig-Interface, only the webfolder-backup (tar.gz) shows up, and not the db-backup. So there is no way for the clients to get to the db-backup, or to restore the backup via the interface. Should the db-backups be stored on the db-server, or should they actually be transferred to the web/master server?
Maybe the db server is not able to write to the backup table in the master database. did you try to run a ispconfig update on the db server and anser "yes" when the updater asks to update permissions in master database?
Hmm, I have not tried that. I will try it as soon as I do the next ISPConfig update and report back. (it's a production server - I don't want to update without some precautions.. ) But does the db-server need to write to the backup table, in order to copy the backups? Because as I stated, the backups are actually created. They are just not copied to the master-server, but to the /var/backup folder of the db-server.
The backups get stored on the db server, not the web server. When a db backup gets restored, then this will happen locally on the db system back into the database. But the backup has to show up on the master server to be able to restore it and for that reason, the db server tries to insert a record into the backup table on the master server when a backup is finished.
