1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Federated on MySQL error

Discussion in 'MySQL' started by karabibe, Nov 19, 2010.

  1. karabibe

    karabibe New Member

    Joined:
    Nov 19, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    i use xampp v1.6.8

    setup:
    local ip : 192.168.5.25
    remote ip : 192.168.5.6

    I tried to practice from this source:
    dev.mysql.com/doc/refman/5.0/en/federated-use.html.
    I created two tables like the instructions.

    on a remote server:
    CREATE TABLE test_table (
    id INT (20) NOT NULL AUTO_INCREMENT,
    name VARCHAR (32) NOT NULL DEFAULT'',
    other INT (20) NOT NULL DEFAULT '0 ',
    PRIMARY KEY (id),
    INDEX name (name),
    INDEX other_key (other)
    )
    ENGINE = MyISAM
    DEFAULT charset = latin1;

    on the local server:
    CREATE TABLE federated_table (
    id INT (20) NOT NULL AUTO_INCREMENT,
    name VARCHAR (32) NOT NULL DEFAULT'',
    other INT (20) NOT NULL DEFAULT '0 ',
    PRIMARY KEY (id),
    INDEX name (name),
    INDEX other_key (other)
    )
    ENGINE = Federated
    DEFAULT charset = latin1
    CONNECTION = 'mysql://root@192.168.5.6:9306/federated/test_table';

    but after the command is executed an error occurs: Unable to the connect to foreign data source: Can not the connect to MySQL server on '192 .168.5.6 '(10 061)
    (2921 sec)

    what is wrong and what's the solution?
    thank you
     

Share This Page