How to install Federated engine and enable via XAMPP

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to install Federated engine and enable via XAMPP

Postby PjChen » 09. June 2017 02:14

my server os is : Windows Server 2012
XAMPP version: 5.6.30
DB: MYSQL

I wanna install Federated engine, and use it to update remote DB(another Server & different IP).
I try use add federated to [mysqld] section in my.ini.
BUT got the following error message:
C:\xampp\mysql\bin\mysqld.exe: unknown option '--federated'

#skip-federated also disable.
The SHOW ENGINES display :
Engine Support
CSV YES
InnoDB Default
MEMORY YES
MYISAM YES
...
and
Federated engine not inclued 'SHOW PLUGINS'

How to install Federated engine and enable via XAMPP?? Thanks a lot.
PjChen
 
Posts: 3
Joined: 09. June 2017 02:00
XAMPP version: 5.6.30
Operating System: Windows Server 2012

Re: How to install Federated engine and enable via XAMPP

Postby Nobbie » 09. June 2017 08:45

PjChen wrote:How to install Federated engine and enable via XAMPP?? Thanks a lot.


You cannot extend Xampp, i.e. you cannot add Federated if its not already included. But instead you can 'ignore' Xampps Mysql / MariaDB, do not install it as a service and do not start it from Xampps Controlcenter. Instead install a Mysql or MariaDB package from Oracle or MariaDB onto your PC, start that server instead of Xampps and you are done. This should work without any additional configurations, as Apache and Mysql / MariaDB communicate via TCPIP Port 3306. Only keep in mind, that all your Applications as well as Phpmyadmin now communicate with that Database and not Xampps Database.
Nobbie
 
Posts: 9569
Joined: 09. March 2008 13:04

Re: How to install Federated engine and enable via XAMPP

Postby PjChen » 12. June 2017 06:09

I get my mistake now,
thanks for your suggest.
PjChen
 
Posts: 3
Joined: 09. June 2017 02:00
XAMPP version: 5.6.30
Operating System: Windows Server 2012


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests