Hi!

What do I set incorrectly ?
No Syncron mysql between PC and Synology Nas mysq .

data:
Windows XP
Public fixed IP address
PC - Mysql 5.5
SAM Broadcaster v4.9.0 myloweslife
samPHPweb

dbconfig.xml.php
<Database>
<driver>MYSQL</ Driver >
<host>Xx.xxx.xxx.xxx</ Host >
<Port>3306< / Port >
<Database>samdb</ Database >
<username>radarok</ username>
<password>password</ Password >
</ Database >

Router - DIR- 600
Open ports 3306, 1221
PC's IP address - 192.168.0.101
Synology IP address - 192.168.0.100
DMZ eneble - 192.168.0.101
Mysql workbanch :
Connection SAMDB - radarok - Hosts : 192.168.0.100:3306
Connection SAMDB - localhost - radarok - Hosts : 192.168.0.100:3306
Server Instance - mysqld@192.168.0.100
Host: 192.168.0.100 Type Windows

The site is all right , everything works perfectly .
I can save database (Tools/Backup or Restore)
The problem is that the data does not go through the Synology NAS mysql database.
So if I stop the SAM and turn off the PC, the web Oops ...

If I reconfigure when I start the SAM, the connection (host: 192.168.0.100) all data goes to the Synology NAS mysql, but I can't save (Tools/Backup or Restore) - Backup failed

Please help me to find, what is the bad setting

You can't use the SAM Backup feature with a remote database.
The backup feature of SAM merely instructs the database server to perform the dump itself, but if the remote database server has no access to the files on your computer (and especially at the very same path), SAM's instructions will fail.
I.e.: SAM tells your NAS to dump the database to C:\Users\ksilein\AppData\SpacialAudio\SAMBC\backup.csv, but your NAS has no idea what this C thing is or where on earth to find the AppData folder.


For remote MySQL you need to take care of the backup yourself. (And I would strongly suggest doing so for the local MySQL as well)

The only alternative to make this work and still use a remote database on your NAS is to set up Database replication between two DB servers on your computer and the NAS.
I wouldn't recommend that, as it's far from easy and introduces a lot of unneccessary complexity.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode