Apache Friends Support Forum

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 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.

I get my mistake now,
thanks for your suggest.