Bug Report
Which version of ShardingSphere did you use?
5.5.4-SNAPSHOT 1358c7b
Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
Expected behavior
Import database success
Actual behavior
Exception occurs
Reason analyze (If you can)
No
Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
- Create logic database
create database sharding_db;
use sharding_db;
- Register storage unit
REGISTER STORAGE UNIT ds_0 (
URL="jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true",
USER="root",
PASSWORD="123456",
PROPERTIES("maximumPoolSize"=10)
);
- Load single table
show unloaded single tables;
load single table *.*;
show single tables;
- Export database configuration
export database configuration to file '/tmp/database-sharding-db.yaml';
- Import database configuration
use mysql;
drop database sharding_db;
import database configuration from file '/tmp/database-sharding-db.yaml';

Bug Report
Which version of ShardingSphere did you use?
5.5.4-SNAPSHOT 1358c7b
Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
Expected behavior
Import database success
Actual behavior
Exception occurs
Reason analyze (If you can)
No
Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
REGISTER STORAGE UNIT ds_0 ( URL="jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true", USER="root", PASSWORD="123456", PROPERTIES("maximumPoolSize"=10) );export database configuration to file '/tmp/database-sharding-db.yaml';