The data source connection string '' is not in the correct format
Argh!
In MySQL 5.12 I could create a federated table. I just upgraded to MySQL 5.13 and now cannot create a federated table using the same CREATE TABLE command that workeed in 5.12. I also have a test federated table that now cannot be accessed. Instead, accessing the table gives pretty much the same error message as the CREATE table command:-
CREATE TABLE federated.adverts (
K int(8) unsigned NOT NULL auto_increment,
code varchar(50) NOT NULL default '',
added datetime NOT NULL default '0000-00-00 00:00:00',
refurl varchar(100) default NULL,
desturl varchar(100) NOT NULL default '',
RemoteAddr varchar(15) NOT NULL default '',
Keyword varchar(25) NOT NULL default '',
Tracker bigint(20) unsigned NOT NULL default '0',
Advertiser enum('Dreams','Generic','Google','Inktomi') NOT NULL default 'Dreams',
Server tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (Server,K),
KEY code (code),
KEY added (added),
KEY Tracker (Tracker),
KEY Server (Server),
KEY AA (Advertiser,added),
KEY Keyword (Keyword(10))
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COMMENT="mysql://deano@localhost/dof/adverts";
... returns the error:-
Error: Can't create federated table. The data source connection string '' is not in the correct format (State:S1000, Native Code: 598)
Accessing the table federated.test (created in mysql 5.12):-
select * from federated.test
returns the error:-
Error: The data source connection string '' is not in the correct format (State:S1000, Native Code: 599)
Checked the online documentation ... I'm pretty sure that I've got the format of the data connection string correct ... plus it worked in the last beta version.
Has something changed in the Federated engine?
Thanks folks,
Dean