1、RDS(MySQL)导出表结构
[root@test ~]# mysqldump -h rm-z2qt7g04778vs671n12.mysql.rds.xscloud-test12.test -u test_sit -P 3306 -p'xxx' -d test_sit > test_sit.sql
2、Oceanbase 建库导入表结构
[root@test ~]# mysql -obx.xs-test12.test -uroot@data_test#test_cluster -p -P3306
MySQL [(none)]> create database test_sit ;
Query OK, 1 row affected (0.01 sec)
MySQL [(none)]> use test_sit;
Database changed
MySQL [test_sit]> source test_sit.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.07 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.05 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.08 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected, 1 warning (0.06 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
....
3、json 文件生成
[root@test script]# cat test_info.json
{
"job": {
"content": [