EXPORT DATABASE CONFIGURATION

    语法

    示例

    • 导出指定逻辑库的存储单元和规则配置到指定路径
    1. EXPORT DATABASE CONFIGURATION FROM sharding_db TO FILE "/xxx/config_sharding_db.yaml";
    • 导出指定逻辑库的存储单元和规则配置到屏幕
    1. mysql> EXPORT DATABASE CONFIGURATION FROM sharding_db;
    2. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    3. | result                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
    4. | databaseName: sharding_db
    5. dataSources:
    7.     password: 123456
    8.     url: jdbc:mysql://127.0.0.1:3306/migration_ds_0
    9.     username: root
    10.     minPoolSize: 1
    11.     connectionTimeoutMilliseconds: 30000
    12.     maxLifetimeMilliseconds: 2100000
    13.     readOnly: false
    14.     idleTimeoutMilliseconds: 60000
    15.     maxPoolSize: 50
    16.   ds_2:
    17.     password: 123456
    18.     username: root
    19.     minPoolSize: 1
    21.     maxLifetimeMilliseconds: 2100000
    22.     readOnly: false
    23.     idleTimeoutMilliseconds: 60000
    24.     maxPoolSize: 50
    25. rules:
    26.  |
    27. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    28. 1 row in set (0.00 sec)
    • 导出当前逻辑库的存储单元和规则配置到指定路径
    • 导出当前逻辑库的存储单元和规则配置到屏幕
    1. EXPORT DATABASE CONFIGURATION;

    相关链接