Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.20
-
Red Hat Enterprise Linux Server release 6.7 (Santiago) / MariaDB 10.0.20
Description
I create some federated tables like below command.
CREATE SERVER 'remote' FOREIGN DATA WRAPPER 'mysql' OPTIONS |
(HOST 'IP address', |
DATABASE 'dbname', |
USER 'root', |
PASSWORD 'password', |
PORT 3306,
|
SOCKET '', |
OWNER 'root'); |
|
CREATE TABLE "table_name" ( |
....
|
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='remote'; |
Already I created 266 tables, I want to create some more tables.
But I got a error message.
##############################################
|
Lookup Error - MySQL Database Error: Can't create federated table. Foreign data src error: database: 'dbname' username: 'root' hostname: 'ip address'
|
##############################################
|
Already created tables are useable but the new create table command is error.
What's wrong?