EXPORT DATABASE CONFIGURATION

Description

The EXPORT DATABASE CONFIGURATION syntax is used to export storage units and rule configurations to YAML format.

Syntax

Grammar Railroad diagram

  1. ExportDatabaseConfiguration ::=
  2.   'EXPORT' 'DATABASE' 'CONFIGURATION' ('FROM' databaseName)? ('TO' 'FILE' filePath)?
  4. databaseName ::=
  5.   identifier
  7. filePath ::=
  8.   string

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

  • When filePath is not specified, the storage units and rule configurations will export to screen.

Example

  • Export storage units and rule configurations from specified database to specified file path
  1. EXPORT DATABASE CONFIGURATION FROM sharding_db TO FILE "/xxx/config_sharding_db.yaml";
  • Export storage units and rule configurations from specified database to screen
  1. EXPORT DATABASE CONFIGURATION FROM sharding_db;
  1. mysql> EXPORT DATABASE CONFIGURATION FROM sharding_db;
  2. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | result                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
  4. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | databaseName: sharding_db
  6. dataSources:
  7.   ds_1:
  8.     password: 123456
  9.     url: jdbc:mysql://127.0.0.1:3306/migration_ds_0
  10.     username: root
  11.     minPoolSize: 1
  12.     connectionTimeoutMilliseconds: 30000
  13.     maxLifetimeMilliseconds: 2100000
  14.     readOnly: false
  15.     idleTimeoutMilliseconds: 60000
  16.     maxPoolSize: 50
  17.   ds_2:
  18.     password: 123456
  19.     url: jdbc:mysql://127.0.0.1:3306/db1
  20.     username: root
  21.     minPoolSize: 1
  22.     connectionTimeoutMilliseconds: 30000
  23.     maxLifetimeMilliseconds: 2100000
  24.     readOnly: false
  25.     idleTimeoutMilliseconds: 60000
  26.     maxPoolSize: 50
  27. rules:
  28.  |
  29. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  30. 1 row in set (0.00 sec)
  • Export storage units and rule configurations from current database to specified file path
  1. EXPORT DATABASE CONFIGURATION TO FILE "/xxx/config_sharding_db.yaml";
  • Export storage units and rule configurations from current database to screen
  1. EXPORT DATABASE CONFIGURATION;
  1. mysql> EXPORT DATABASE CONFIGURATION;
  2. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | result                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
  4. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | databaseName: sharding_db
  6. dataSources:
  7.   ds_1:
  8.     password: 123456
  9.     url: jdbc:mysql://127.0.0.1:3306/migration_ds_0
  10.     username: root
  11.     minPoolSize: 1
  12.     connectionTimeoutMilliseconds: 30000
  13.     maxLifetimeMilliseconds: 2100000
  14.     readOnly: false
  15.     idleTimeoutMilliseconds: 60000
  16.     maxPoolSize: 50
  17.   ds_2:
  18.     password: 123456
  19.     url: jdbc:mysql://127.0.0.1:3306/db1
  20.     username: root
  21.     minPoolSize: 1
  22.     connectionTimeoutMilliseconds: 30000
  23.     maxLifetimeMilliseconds: 2100000
  24.     readOnly: false
  25.     idleTimeoutMilliseconds: 60000
  26.     maxPoolSize: 50
  27. rules:
  28.  |
  29. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  30. 1 row in set (0.00 sec)

Reserved word

EXPORT, DATABASE, CONFIGURATION, FROM, TO, FILE