MySQL Forums :: Install :: FEDERATED ENGINE

I have this Server installed

protocol_version: 10
version:5.0.45
version_comment:MySQL Community Server (GPL)
version_compile_machine:i386
version_compile_os:pc-nto-qnx6.2.1
have_federated_engine:YES


MySQL Manual Reference say ....
..."you must start the MySQL server binary using the --federated option"
This option can be configurated in my.cnf file
How?

This is an example of my problem

In my remote serve(172.z.z.X)
has the table "X" in the shema/db = mysql

CREATE TABLE `X` (
`TIEMPO` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`TUBO` VARCHAR(45) DEFAULT NULL,
`PESO` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY (`TIEMPO`),
KEY `TUBO` (`TUBO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


In my local server(172.z.z.Y)
I was trying to create the table "Y" on shema/db = mysql

CREATE TABLE `X` (
`TIEMPO` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`TUBO` VARCHAR(45) DEFAULT NULL,
`PESO` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY (`TIEMPO`),
KEY `TUBO` (`TUBO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CONNECT='mysql://dba:sql@172.z.z.X:3306/mysql/X'

I have this error
Error Code : 1432
Can't create federated table.
The data source connection string '' is not in the correct format

Help me please
Sorry for my English



Edited 1 time(s). Last edit at 11/03/2009 02:38PM by Alejandro Pecini.