{"id":155,"date":"2012-10-21T00:35:51","date_gmt":"2012-10-20T22:35:51","guid":{"rendered":"http:\/\/tommy.johannishus.se\/?p=155"},"modified":"2012-10-21T00:35:51","modified_gmt":"2012-10-20T22:35:51","slug":"migrera-mysql-anvandare","status":"publish","type":"post","link":"https:\/\/www.appelis.se\/?p=155","title":{"rendered":"Migrera mysql-anv\u00e4ndare"},"content":{"rendered":"<p>Skorpans SSD har kommit och Ubuntu Server \u00e4r installerat p\u00e5 den. Det b\u00f6rjar n\u00e4rma sig dags att flytta \u00f6ver mysql-databaserna till den nya disken. S\u00e5 h\u00e4r kommer det att g\u00e5 till:<\/p>\n<p><strong>Backa upp databaser<\/strong><br \/>\n<code>mysqldump -p &lt;db&gt; &gt; &lt;db&gt;.sql<\/code><\/p>\n<p><strong>Backa upp anv\u00e4ndare<\/strong><br \/>\n<code>mysql -u root -p -B -N -e \"SELECT user, host FROM user\" mysql<br \/>\nmysql -u root -p -B -N -e \"SHOW GRANTS FOR 'userName'@'hostName'\" &gt;&gt; grants.sql<\/code><\/p>\n<p><strong>Importera<\/strong><br \/>\n<code>mysql -u root -B -N &lt; &lt;backup&gt;.sql<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Skorpans SSD har kommit och Ubuntu Server \u00e4r installerat p\u00e5 den. Det b\u00f6rjar n\u00e4rma sig dags att flytta \u00f6ver mysql-databaserna till den nya disken. S\u00e5 h\u00e4r kommer det att g\u00e5 till: Backa upp databaser mysqldump -p &lt;db&gt; &gt; &lt;db&gt;.sql Backa upp anv\u00e4ndare mysql -u root -p -B -N -e &#8221;SELECT user, host FROM user&#8221; mysql [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-skorpan"],"_links":{"self":[{"href":"https:\/\/www.appelis.se\/index.php?rest_route=\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appelis.se\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appelis.se\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appelis.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appelis.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=155"}],"version-history":[{"count":0,"href":"https:\/\/www.appelis.se\/index.php?rest_route=\/wp\/v2\/posts\/155\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appelis.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appelis.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appelis.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}