数据库导入和导出
mysql导出
#!/bin/bash
# 导出的数据库名字和表名
xyconf_db_name=db1
xyconf_table_name=table1
# 数据开始时间和结束时间
xyconf_begin="2021-10-01"
xyconf_end="2022-07-30"
# 数据库连接
xyconf_db_ip=-h172.0.0.1
xyconf_db_port=-uroot
xyconf_db_user=-P1234
xyconf_db_passwd=-p'123456'
# ==========================
mysql ${xyconf_db_ip} ${xyconf_db_user} ${xyconf_db_passwd} ${xyconf_db_port} ${xyconf_db_name} -e "SELECT * from ${xyconf_table_name} where end >='${xyconf_begin} 00:00:00' and end<'${xyconf_end} 00:00:00' ;" | sed "s/NULL/\\\\N/g;1d" > data/${xyconf_db_name}__${xyconf_table_name}__${xyconf_begin}__${xyconf_end}__$(date "+%Y%m%d%H%M%S")
其他
| sed "s/NULL/\\\\N/g;1d"
| sed "s/'/\'/;s/\t/,/g;s/\n//g;s/NULL/\\\\N/g;1d"
mysql导入
mysql -h172.0.0.1 -uroot -p123456 -P1234
use xy_test;
LOAD DATA LOCAL INFILE '/data/sd2/importdata/data/aaaaa' into table table1 ;
doris导入
curl --location-trusted -u 数据库用户:数据库密码 -H "label:导入的唯一标识符" -T 本地文件全路径 -XPUT http://doris的feip:8030/api/数据库名字/表名/_stream_load
curl --location-trusted -u root:123456 -H "label:a1_2022_0805001_V05" -T data/aaaaa -XPUT http://172.0.0.1:8030/api/map_test/table1/_stream_load
mysql
定时分区
存储过程
定时事件