[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
Support Forum • View topic - Mysql sync with Synology NAS - spacial.com
Skip to Content
It is currently September 27th, 2023, 7:57 pm

All times are UTC - 6 hours [ DST ]

 [ 2 posts ] 
Author Message
PostPosted: July 1st, 2020, 11:10 am 
New User
New User

Joined: July 1st, 2020, 11:08 am
Posts: 1

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

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

<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 -
Synology IP address -
DMZ eneble -
Mysql workbanch :
Connection SAMDB - radarok - Hosts :
Connection SAMDB - localhost - radarok - Hosts :
Server Instance - mysqld@
Host: 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: 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

Last edited by ksilein on July 2nd, 2020, 9:24 am, edited 1 time in total.

PostPosted: July 2nd, 2020, 5:56 am 
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8306
Location: Cologne (Germany)
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

Display posts from previous:  Sort by  
 [ 2 posts ] 

All times are UTC - 6 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 10 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group