blocks|key|4545407|text|您可以转储每个表，并通过REST接口加载它们：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4545408|curl+"http://hosta:8086/db/dbname/series?u=root&p=root&q=select%2520*%2520from%2520series_name%253B"+>+series_name.json
curl+-XPOST+-d+@series_name.json+"http://hostb:8086/db/dbname/series?u=root&p=root"|code-block|syntax|javascript|4545409|或者，您可能想要向集群中添加新主机？这很简单，而且你会免费得到master-master副本。Cluster+Setup|offset|length|4545410|entityMap|0|LINK|mutability|MUTABLE|url|http://influxdb.com/docs/v0.8/clustering/setup.html^0|0|0|1B|D|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You could dump each table and load them through REST interface:

<pre><code>curl "http://hosta:8086/db/dbname/series?u=root&amp;p=root&amp;q=select%20*%20from%20series_name%3B" &gt; series_name.json
curl -XPOST -d @series_name.json "http://hostb:8086/db/dbname/series?u=root&amp;p=root"
</code></pre>

Or, maybe you want to add new host to cluster? It's easy and you'll get master-master replica for free. <a href="http://influxdb.com/docs/v0.8/clustering/setup.html" rel="noreferrer">Cluster Setup</a>

blocks|key|38473|text|导出数据：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|38474|sudo+service+influxdb+start+(Or+leave+this+step+if+service+is+already+running)
influxd+backup+-database+grpcdb+/opt/data++|code-block|syntax|javascript|38475|grpcdb是DB的名称，在这种情况下，备份将保存在/opt/data目录下。|38476|导入数据：|38477|sudo+service+influxdb+stop++(Service+should+not+be+running)
influxd+restore+-metadir+/var/lib/influxdb/meta+/opt/data
influxd+restore+-database+grpcdb+-datadir+/var/lib/influxdb/data+/opt/data
sudo+service+influxdb+start|38478|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Export data:

<pre><code>sudo service influxdb start (Or leave this step if service is already running)
influxd backup -database grpcdb /opt/data 
</code></pre>

grpcdb is name of DB and back up will be saved under /opt/data directory in this case.

Import Data:

<pre><code>sudo service influxdb stop (Service should not be running)
influxd restore -metadir /var/lib/influxdb/meta /opt/data
influxd restore -database grpcdb -datadir /var/lib/influxdb/data /opt/data
sudo service influxdb start
</code></pre>

blocks|key|38427|text|正如ezotrank所说，您可以转储每个表。不过，ezotrank的答案中遗漏了一个"-d“。它应该是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|38428|curl+"http://hosta:8086/db/dbname/series?u=root&p=root&q=select%2520*%2520from%2520series_name%253B"+>+series_name.json
curl+-XPOST+-d+@series_name.json+"http://hostb:8086/db/dbname/series?u=root&p=root"|code-block|syntax|javascript|38429|(Ezotrank，对不起，我会直接对你的回答发表评论，但我还没有足够的名誉点来这么做。)|38430|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

As ezotrank says, you can dump each table. There's a missing "-d" in ezotrank's answer though. It should be:

<pre><code>curl "http://hosta:8086/db/dbname/series?u=root&amp;p=root&amp;q=select%20*%20from%20series_name%3B" &gt; series_name.json
curl -XPOST -d @series_name.json "http://hostb:8086/db/dbname/series?u=root&amp;p=root"
</code></pre>

(Ezotrank, sorry, I would've just posted a comment directly on your answer, but I don't have enough reputation points to do that yet.)

blocks|key|4545539|text|如果我使用curl，我会得到超时，如果我使用influxd+backup，它就不是我能读懂的格式。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4545540|我得到的结果是这样的：|4545541|influx+-host+influxdb.mydomain.com+-database+primary+-format+csv+-execute+"select+time,value+from+\"continuous\"+where+channel='ch123'"+>+outtest.csv|code-block|syntax|javascript|4545542|entityMap^0|M|E|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If I use curl, I get timeouts, and if I use <code>influxd backup</code> its not in a format I can read.

I'm getting fine results like this:

<pre><code>influx -host influxdb.mydomain.com -database primary -format csv -execute "select time,value from \"continuous\" where channel='ch123'" &gt; outtest.csv
</code></pre>

blocks|key|4545627|text|如果要以可读格式导出，最好使用inspect命令。要使用名称HomeData导出数据库，命令为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4545628|sudo+influx_inspect+export+-waldir+/var/lib/influxdb/wal+-datadir+/var/lib/influxdb+-out+"influx_backup.db"+-database+HomeData|code-block|syntax|javascript|4545629|-waldir和-datdir的参数可以在/etc/influxdb/influxdb.conf中找到。|4545630|要再次导入此文件，命令为：|4545631|influx+-import+-path=influx_backup.db|4545632|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If You want to export in an readable format, the inspect command is to prefer.
To export the database with the name HomeData the command is:

<pre><code>sudo influx_inspect export -waldir /var/lib/influxdb/wal -datadir /var/lib/influxdb -out "influx_backup.db" -database HomeData
</code></pre>

The parameters for -waldir and -datdir can be found in /etc/influxdb/influxdb.conf.

To import this file again, the command is:

<pre><code>influx -import -path=influx_backup.db
</code></pre>

blocks|key|38575|text|如果您有权访问运行Influx+db的机器，我建议您使用influx_inspect命令。这个命令很简单，而且非常快。它会将你的数据库转储到line+protocol中。然后，您可以使用influx+-import命令导入此转储。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|38576|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.influxdata.com/influxdb/v1.6/tools/influx_inspect/|1|https://docs.influxdata.com/influxdb/v1.6/write_protocols/line_protocol_tutorial/|2|https://docs.influxdata.com/influxdb/v1.6/tools/shell/#import-data-from-a-file-with-import^0|S|E|0|1Y|D|1|2L|E|2|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]|$A|W|B|X|1|Y]]|C|$]]|$1|D|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]|N|$5|G|H|I|C|$J|O]]]]

If you have access to the machine running Influx db I would say use the <a href="https://docs.influxdata.com/influxdb/v1.6/tools/influx_inspect/" rel="nofollow noreferrer">influx_inspect</a> command. The command is simple and very fast. It will dump your db in <a href="https://docs.influxdata.com/influxdb/v1.6/write_protocols/line_protocol_tutorial/" rel="nofollow noreferrer">line protocol</a>. You can then import this dump using <a href="https://docs.influxdata.com/influxdb/v1.6/tools/shell/#import-data-from-a-file-with-import" rel="nofollow noreferrer">influx -import</a> command.

Is there a way (plugin or tool) to export the data from the database (or database itself) ? I'm looking for this feature as I need to migrate a DB from present host to another one.

Export data from InfluxDB

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

是否有从数据库(或数据库本身)导出数据的方法(插件或工具)？我正在寻找这个功能，因为我需要迁移一个数据库从目前的主机到另一个。

问从InfluxDB导出数据
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从InfluxDB导出数据EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从InfluxDB导出数据
EN