{"id":1166,"date":"2025-04-29T10:38:28","date_gmt":"2025-04-29T09:38:28","guid":{"rendered":"https:\/\/enerserve.eu\/?post_type=ufaq&#038;p=1166"},"modified":"2025-04-29T10:39:50","modified_gmt":"2025-04-29T09:39:50","slug":"wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren","status":"publish","type":"ufaq","link":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/","title":{"rendered":"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren?"},"content":{"rendered":"<style>.ewd-ufaq-faq-title .ewd-ufaq-post-margin-symbol span { font-size: 16px !important; }<\/style><div  class=\"ewd-ufaq-faq-list ewd-ufaq-page-type-distinct ewd-ufaq-category-tabs-\" id='ewd-ufaq-faq-list'>\n\n\t<input type='hidden' name='show_on_load' value='' id='ewd-ufaq-show-on-load' \/>\n<input type='hidden' name='include_category' value='' id='ewd-ufaq-include-category' \/>\n<input type='hidden' name='exclude_category' value='' id='ewd-ufaq-exclude-category' \/>\n<input type='hidden' name='orderby' value='set_order' id='ewd-ufaq-orderby' \/>\n<input type='hidden' name='order' value='asc' id='ewd-ufaq-order' \/>\n<input type='hidden' name='post_count' value='-1' id='ewd-ufaq-post-count' \/>\n<input type='hidden' name='current_url' value='\/en\/wp-json\/wp\/v2\/ufaq\/1166' id='ewd-ufaq-current-url' \/>\n\t\n\t\n\t<div class='ewd-ufaq-faqs'>\n\n\t\t<div  class=\"ewd-ufaq-faq-div ewd-ufaq-faq-column-count-one ewd-ufaq-faq-responsive-columns- ewd-ufaq-faq-display-style-contemporary ewd-ufaq-can-be-toggled\" id='ewd-ufaq-post-1166-woySWzwfvd' data-post_id='1166'>\n\n\t\t\n\t<div class='ewd-ufaq-faq-title ewd-ufaq-faq-toggle'>\n\t\n\t<a class='ewd-ufaq-post-margin'  href='#' role=\"button\">\n\n\t\t<div class='ewd-ufaq-post-margin-symbol ewd-ufaq-'>\n\t\t\t<span >A<\/span>\n\t\t<\/div>\n\n\t\t<div class='ewd-ufaq-faq-title-text'>\n\n\t\t\t<h4>\n\t\t\t\tWie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren?\t\t\t<\/h4>\n\n\t\t<\/div>\n\n\t\t<div class='ewd-ufaq-clear'><\/div>\n\n\t<\/a>\n\t\n<\/div>\n\t\n\t<div class='ewd-ufaq-faq-body' >\n\n\t\t\n\t\t\t<div class='ewd-ufaq-faq-categories'>\n\t\n\tCategory:\n\t\n\t\tSmartPi\n\t\n<\/div>\n\t\t\n\t\t\t<div class='ewd-ufaq-post-margin ewd-ufaq-faq-post'>\n\t\n<p class=\"wp-block-paragraph\">Seit einiger Zeit verwendet der SmartPi die InfluxDB als Datenbank. Bei alten SmartPis wurde die SQLite-Datenbank verwendet.<br>Das konvertieren der alten SQLite-Daten ist aber m\u00f6glich.<br>Kopieren Sie dazu die SQLite-Dateien (in der Regel liegen die unter \/var\/smartpi\/db) des alten SmartPi-Images auf den SmartPi mit dem neuen Image. Das geht am besten, indem Sie die Dateien vom alten Image per SSH herunterkopieren und auch per SSH auf das neue Image kopieren.<br>Die Dateien d\u00fcrfen dabei nicht umbenannt werden.<br>mit dem Befehl <br><code>smartpisqlite2influxdb &lt;Pfad_zur_SQLite-Datei&gt;<\/code><br>k\u00f6nnen die Dateien importiert werden.<br>Beispiel: <code>smartpisqlite2influxdb \/home\/smartpi\/smartpi_logdata_202411.db<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t<\/div>\n\n<\/div>\n\t<\/div>\n\n\t\n<\/div>","protected":false},"excerpt":{"rendered":"<p>A Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? Category: SmartPi Seit einiger Zeit verwendet der SmartPi die InfluxDB als Datenbank. Bei<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","ufaq-category":[36],"ufaq-tag":[],"class_list":["post-1166","ufaq","type-ufaq","status-publish","hentry","ufaq-category-smartpi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH\" \/>\n<meta property=\"og:description\" content=\"A Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? Category: SmartPi Seit einiger Zeit verwendet der SmartPi die InfluxDB als Datenbank. Bei [\u2026]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/\" \/>\n<meta property=\"og:site_name\" content=\"nD-enerserve GmbH\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-29T09:39:50+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\\\/\",\"url\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\\\/\",\"name\":\"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#website\"},\"datePublished\":\"2025-04-29T09:38:28+00:00\",\"dateModified\":\"2025-04-29T09:39:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/home\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FAQs\",\"item\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/ufaq\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/\",\"name\":\"nD-enerserve GmbH\",\"description\":\"nD-enerserve GmbH\",\"publisher\":{\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#organization\",\"name\":\"nD-enerserve GmbH\",\"url\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/enerserve.eu\\\/wp-content\\\/uploads\\\/cropped-g1205.png\",\"contentUrl\":\"https:\\\/\\\/enerserve.eu\\\/wp-content\\\/uploads\\\/cropped-g1205.png\",\"width\":2216,\"height\":525,\"caption\":\"nD-enerserve GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/enerserve.eu\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/","og_locale":"en_US","og_type":"article","og_title":"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH","og_description":"A Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? Category: SmartPi Seit einiger Zeit verwendet der SmartPi die InfluxDB als Datenbank. Bei [\u2026]","og_url":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/","og_site_name":"nD-enerserve GmbH","article_modified_time":"2025-04-29T09:39:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/","url":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/","name":"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren? - nD-enerserve GmbH","isPartOf":{"@id":"https:\/\/enerserve.eu\/en\/#website"},"datePublished":"2025-04-29T09:38:28+00:00","dateModified":"2025-04-29T09:39:50+00:00","breadcrumb":{"@id":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/enerserve.eu\/en\/ufaq\/wie-kann-ich-die-daten-aus-der-sqlite-datenbank-in-die-influxdb-migrieren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/enerserve.eu\/en\/home\/"},{"@type":"ListItem","position":2,"name":"FAQs","item":"https:\/\/enerserve.eu\/en\/ufaq\/"},{"@type":"ListItem","position":3,"name":"Wie kann ich die Daten aus der SQLite-Datenbank in die InfluxDB migrieren?"}]},{"@type":"WebSite","@id":"https:\/\/enerserve.eu\/en\/#website","url":"https:\/\/enerserve.eu\/en\/","name":"nD-enerserve GmbH","description":"nD-enerserve GmbH","publisher":{"@id":"https:\/\/enerserve.eu\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/enerserve.eu\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/enerserve.eu\/en\/#organization","name":"nD-enerserve GmbH","url":"https:\/\/enerserve.eu\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/enerserve.eu\/en\/#\/schema\/logo\/image\/","url":"https:\/\/enerserve.eu\/wp-content\/uploads\/cropped-g1205.png","contentUrl":"https:\/\/enerserve.eu\/wp-content\/uploads\/cropped-g1205.png","width":2216,"height":525,"caption":"nD-enerserve GmbH"},"image":{"@id":"https:\/\/enerserve.eu\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/ufaq\/1166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/ufaq"}],"about":[{"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/types\/ufaq"}],"author":[{"embeddable":true,"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/comments?post=1166"}],"wp:attachment":[{"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/media?parent=1166"}],"wp:term":[{"taxonomy":"ufaq-category","embeddable":true,"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/ufaq-category?post=1166"},{"taxonomy":"ufaq-tag","embeddable":true,"href":"https:\/\/enerserve.eu\/en\/wp-json\/wp\/v2\/ufaq-tag?post=1166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}