The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

transfer data directory to a NAS file server

Dear all,

I'm trying to transfer the MariaDB data directory to a Synology NAS file server. Unfortunately neither the MAriaDB Windows Service nor the MaraiDB Windows Process is able to access this directory on the NAS. At startup the MariaDB Windows Service throws error number 1067. The MariaDB Windows Process ends with the following error: ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)".

I have changed the datadir entry in my.ini to point to the new data directory on the NAS. For this entry I tried drive letter, UNC path with the server name as well as UNC path with IP-Address

I configured the MariaDB Windows Service to run as network service as well as user process and local system account.

On the Synology NAS I configured every possible access right for this directory.

Unfortunately nothing helped so far.

I'm using the following congiguration: Windows 7 MariaDB10.4.17 win32 + mariadb-connector-ODBC-3.1.6 win32 Synology NAS DS218J

The goal is to have MariaDB databases on this NAS so that they can be accessed from Windows with MS-Access 2016 via ODBC and from Debian Linux with LibreOffice Base.

Any hint at how to configure this scenario right or how to reach this goal with an alternative strategy will be very much appreciated.

Thank you very much in advance.

Best regards

Karl

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.