{"id":232,"date":"2013-12-04T21:32:27","date_gmt":"2013-12-04T19:32:27","guid":{"rendered":"http:\/\/my-opinions.info\/?p=232"},"modified":"2016-03-03T16:14:45","modified_gmt":"2016-03-03T14:14:45","slug":"denwer-bekap-mysql","status":"publish","type":"post","link":"https:\/\/uw-t.com\/ru\/programing\/mysql\/denwer-bekap-mysql","title":{"rendered":"Denwer \u0431\u0435\u043a\u0430\u043f Mysql"},"content":{"rendered":"<p>\u0427\u0442\u043e \u0431\u044b \u0432\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0411\u0414 \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443 (cmd)<br \/>\n\u0438 \u043f\u0438\u0448\u0435\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u0443<br \/>\n<strong>cd &lt;\u043f\u0443\u0442\u044c \u043a \u043c\u0443\u0441\u043a\u0443\u043b\u0443&gt;<br \/>\nmysql -uroot test&lt;D:\\test\\easydump.sql<\/strong><br \/>\n\u0427\u0442\u043e \u0431\u044b \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0431\u0435\u043a\u0430\u043f \u043d\u0443\u0436\u043d\u043e \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443<br \/>\n<strong>mysqldump -uroot test&gt;D:\\test\\easydump.sql<\/strong><\/p>\n<p>mysqldump -u <username> -p<password> <database_name> | gzip > \/path\/to\/backup\/db\/datename_`date +%y_%m_%d`.gz<\/p>\n<p>\u0414\u043b\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u0432\u0441\u0435\u0445 \u0431\u0430\u0437 \u0432\u043e\u0442 \u0442\u0430\u043a<br \/>\n<strong>mysqldump -u user -p --all-databases >file.sql<\/strong><\/p>\n<p>\u0432\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0443\u044e \u0411\u0414<br \/>\n<strong>mysql -u sadmin -p pass21 Customers < custback.sql<\/strong><br \/>\n\u0415\u0441\u043b\u0438 \u043d\u0435\u0442 \u0444\u0430\u0439\u043b\u0430 mysqldump \u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0441\u043a\u0430\u0447\u0430\u0442\u044c \u0437\u0434\u0435\u0441\u044c<noindex><a rel=\"nofollow\" href=\"http:\/\/my-opinions.info\/wp-content\/uploads\/2013\/12\/mysqldump.zip\"><strong>mysqldump<\/strong><\/a><\/noindex><\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>\u0427\u0442\u043e \u0431\u044b \u0432\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0411\u0414 \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443 (cmd) \u0438 \u043f\u0438\u0448\u0435\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 cd &lt;\u043f\u0443\u0442\u044c \u043a \u043c\u0443\u0441\u043a\u0443\u043b\u0443&gt; mysql -uroot test&lt;D:\\test\\easydump.sql \u0427\u0442\u043e \u0431\u044b \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0431\u0435\u043a\u0430\u043f \u043d\u0443\u0436\u043d\u043e \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 mysqldump -uroot test&gt;D:\\test\\easydump.sql mysqldump -u -p | gzip > \/path\/to\/backup\/db\/datename_`date +%y_%m_%d`.gz \u0414\u043b\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u0432\u0441\u0435\u0445 \u0431\u0430\u0437 \u0432\u043e\u0442 \u0442\u0430\u043a mysqldump -u user -p --all-databases >file.sql \u0432\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0443\u044e \u0411\u0414 mysql -u sadmin -p &hellip; <a href=\"https:\/\/uw-t.com\/ru\/programing\/mysql\/denwer-bekap-mysql\" class=\"more-link\">\u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 <span class=\"screen-reader-text\">Denwer \u0431\u0435\u043a\u0430\u043f Mysql<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-232","post","type-post","status-publish","format-standard","hentry","category-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/posts\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/comments?post=232"}],"version-history":[{"count":7,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/posts\/232\/revisions"}],"predecessor-version":[{"id":338,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/posts\/232\/revisions\/338"}],"wp:attachment":[{"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/media?parent=232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/categories?post=232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uw-t.com\/ru\/wp-json\/wp\/v2\/tags?post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}