Is there a way to tell if ANY change was made to the database today? Maybe a log entry or some :switch-file" somewhere?
I want to write a nightly bash script that can see if any changes were made to the database in the last 24 hours (or some time interval) and if so I want to engage code I already have to dump the database and load my backup EspoCRM system. (I have two installs of EspoCRM on the same server, in case one goes down during an update or something.) There is a bit of overhead in this and I don't want to reload the backup database if no changes have been made.
Any ideas on how to check if ANY record in the DB has been modified, or if there was an addition or a deletion? Maybe there is a mysql command or query I can use if there is nothing in EspoCRM? I'll research that.
I want to write a nightly bash script that can see if any changes were made to the database in the last 24 hours (or some time interval) and if so I want to engage code I already have to dump the database and load my backup EspoCRM system. (I have two installs of EspoCRM on the same server, in case one goes down during an update or something.) There is a bit of overhead in this and I don't want to reload the backup database if no changes have been made.
Any ideas on how to check if ANY record in the DB has been modified, or if there was an addition or a deletion? Maybe there is a mysql command or query I can use if there is nothing in EspoCRM? I'll research that.
Comment