Enable federated on RHEL

[Paolini Julia]

Hi everybody,

I am trying to enable FEDERATED engine on MySQL 5.0.77 on RHEL5.4. I read the documentation:

--- Beginning with MySQL 5.0.64, the FEDERATED storage engine is not enabled by default in the running server; to enable FEDERATED, you must start the MySQL server binary using the --federated option ---

and start MySQL with the federated option (with no errors) but the show engine command still show me that FEDERATED is not supported (I made a test by creating a federated table to verify and it fails). If I compile MySQL with the --with-federated-storage-engine option, no problems, I can create FEDERATED table without any problems.

Did I misunderstood the documentation? Am I obligated to compile?

Many thanks!!