{"id":2156,"date":"2018-09-14T07:06:52","date_gmt":"2018-09-14T07:06:52","guid":{"rendered":"http:\/\/blog.datentraeger.li\/?p=2156"},"modified":"2018-09-14T07:09:24","modified_gmt":"2018-09-14T07:09:24","slug":"pipe-viewer","status":"publish","type":"post","link":"https:\/\/blog.datentraeger.li\/?p=2156","title":{"rendered":"Pipe Viewer"},"content":{"rendered":"<p>Letzthin musste ich einen gr\u00f6sseren SQL-Dump importieren. Mysql\/Mariadb zeigt hier aber keinerlei Status an.<\/p>\n<p>Das kann man aber mit <a href=\"https:\/\/packages.debian.org\/search?keywords=pv&amp;searchon=names&amp;suite=all&amp;section=all\" target=\"_blank\" rel=\"noopener\">pipe viewer<\/a> m\u00f6glich machen<\/p>\n<pre class=\"lang:default decode:true \">[root@node \/var\/tmp]# pv kopano.sql | mysql -u root -p kopano\r\n 350MiB 0:01:07 [11.7MiB\/s] [=======&gt;   \r\n<\/pre>\n<p>Finde ich noch recht angenehm. Zumindest einen kurzen Eintrag hier wert&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"Letzthin musste ich einen gr\u00f6sseren SQL-Dump importieren. Mysql\/Mariadb zeigt hier aber keinerlei Status an. Das kann man aber mit pipe viewer m\u00f6glich machen [root@node \/var\/tmp]# pv kopano.sql | mysql -u root -p kopano 350MiB 0:01:07 [11.7MiB\/s] [=======&gt; Finde ich noch recht angenehm. Zumindest einen kurzen Eintrag hier wert&#8230;\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,16],"tags":[],"class_list":["post-2156","post","type-post","status-publish","format-standard","hentry","category-cli","category-sql"],"_links":{"self":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/2156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2156"}],"version-history":[{"count":4,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/2156\/revisions"}],"predecessor-version":[{"id":2160,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/2156\/revisions\/2160"}],"wp:attachment":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}