{"id":1630,"date":"2014-02-05T23:58:33","date_gmt":"2014-02-05T17:58:33","guid":{"rendered":"http:\/\/notes.norfolks.org\/?p=1630"},"modified":"2017-08-17T11:57:57","modified_gmt":"2017-08-17T05:57:57","slug":"mysql","status":"publish","type":"post","link":"https:\/\/notes.norfolks.fun\/?p=1630","title":{"rendered":"Help for MySQL"},"content":{"rendered":"<p><strong>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 MySQL<\/strong><\/p>\n<pre lang=\"mysql\">SELECT USER from mysql.user;<\/pre>\n<p>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043a\u043e\u0434\u0438\u0440\u043e\u0432\u043a\u0443 \u0431\u0430\u0437\u044b<\/p>\n<pre lang=\"mysql\">use database;\r\nSHOW VARIABLES LIKE \"character_set_database\";<\/pre>\n<p>\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f<\/p>\n<pre lang=\"mysql\">mysqldump -u USER -pPASSWORD DATABASE > \/path\/to\/file\/dump.sql<\/pre>\n<p><a href=\"https:\/\/habrahabr.ru\/post\/105954\/\">\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0430 Habr\u0435<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 MySQL SELECT USER from mysql.user; \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043a\u043e\u0434\u0438\u0440\u043e\u0432\u043a\u0443 \u0431\u0430\u0437\u044b use database; SHOW VARIABLES LIKE &#171;character_set_database&#187;; \u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE > \/path\/to\/file\/dump.sql \u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0430 Habr\u0435<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,21],"tags":[],"class_list":["post-1630","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql"],"_links":{"self":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/1630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1630"}],"version-history":[{"count":7,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/1630\/revisions"}],"predecessor-version":[{"id":2115,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/1630\/revisions\/2115"}],"wp:attachment":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}