dave0judy
Joined: 28 Jul 2013 Posts: 30
|
Posted: Thu Jul 06, 2017 4:09 pm Post subject: Running mysql locks databases preventing backup |
|
|
I am running Xampp with MySql databases, on which I am backing up the databases from my NAS drive on vvengine. I have this set to backup when changes are noted on the source. This works fine when the mysql engine is not running. As soon as I start mysql, vvengine detects this as a source change (even when no changes were made to the database files) and tries to do the backup. However, with mysql running, it locks the database files, producing an error on vvengine.
I start windows without mysql running, so that it will backup any changed databases, however as soon as I start mysql to use the databases, it immediately provides the error. When set to "manual", this error doesn't happen, which is what I have had to set it at, so that when I do make changes to the database(s), I then stop mysql and perform the backup manually, on vvengine.
As I would really prefer this being backed up automatially when source changes noted, I was wondering if there was a setting available, where when set to "monitor source", that it would not activate the backup if mysql were turned on?? |
|