influxDB数据迁移流程

1. var/lib下的influxdb文件迁移到mnt下

cp -r /var/lib/influxdb /mnt/influxdb

2. 停influx服务

sudo systemctl stop influxdb;

3. 修改/etc/influxdb/influxdb.conf的配置

[meta]
dir = "/var/lib/influxdb/meta"  # meta数据存放目录 ========= >>dir = "/mnt/influxdb/meta"
[data]
dir = "/var/lib/influxdb/data"  # 最终数据（TSM文件）存储目录========= >>dir = "/mnt/influxdb/data"
wal-dir = "/var/lib/influxdb/wal"  # 预写日志存储目录========= >>dir = "/mnt/influxdb/wal"

4. 迁移数据
5. 将临时表复制到新库：tms

SELECT time,car_nexitum,city,direction,district,gps_time,latitude,longitude,odometer,place_name,province,road_name,speed,status,time_1,time_2,time_3,time_4,tmp_1,tmp_2,tmp_3,tmp_4 
INTO "tms".."trackview" 
FROM "tms".."trackviewnew" 
group by "car_num"

6. 删除tms的trackviewnew表 (可不删，保留之前的数据)。

drop measurement "trackviewnew"

7. 检查表是否创建成功。索引是否删除。
8. 启动influx服务：

sudo systemctl start influxdb;