mcp_dk
the mysql db's are in
/var/lib/mysql/...
To back them up correctly, you need to stop mysql, as open databases will not be backed up. The standard backup scripts in sme server do a dump of the mysql db's immediately before running a backup. This dump is then included in the backup.
The backup2ws contrib also makes use of this dump function.
Note that the dump file is deleted after the backup is complete.
You can see this "temporary" dump file in
/home/e-smith/db/mysql/mysql.dump
but only after the pre backup routines and before the post backuo routines.
All I can suggest is that you need to create your own backup scripts to selectively dump the contents of certain mysql dbs, and include that in your usual backup job.
Have a look at the sme server backup scripts to see how it is done.
Alternatively schedule the 911 backup job, but set it up to exclude all the user & ibay folders. Then it will have minimal configuration data plus the mysql dump for all your mysql db's.
Then have additional backup jobs scheduled to backup specific ibays & user data etc.