{"id":1372,"date":"2014-04-26T08:09:29","date_gmt":"2014-04-26T03:39:29","guid":{"rendered":"http:\/\/www.host97.net\/?p=1372"},"modified":"2014-04-26T08:09:29","modified_gmt":"2014-04-26T03:39:29","slug":"%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%b1%db%8c%d8%b3%d8%aa%d9%88%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%d8%a8%d8%b2%d8%b1%da%af-%d9%88-%d8%ad%d8%ac%db%8c%d9%85-%d8%af","status":"publish","type":"post","link":"https:\/\/host97.net\/wiki\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%b1%db%8c%d8%b3%d8%aa%d9%88%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%d8%a8%d8%b2%d8%b1%da%af-%d9%88-%d8%ad%d8%ac%db%8c%d9%85-%d8%af\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0648 \u062d\u062c\u06cc\u0645 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MYSQL \u062f\u0631 SSH \u0644\u06cc\u0646\u0648\u06a9\u0633"},"content":{"rendered":"<h2 style=\"text-align: justify;\"><\/h2>\n<h2 style=\"text-align: justify;\">\u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u067e\u0631 \u062d\u062c\u0645 \u0648 \u0628\u0632\u0631\u06af \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u062d\u06cc\u0637 ssh \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0633\u0631\u0648\u0631<\/h2>\n<p style=\"text-align: justify;\">\u06cc\u06a9\u06cc \u0627\u0632 \u0628\u0632\u0631\u06af \u062a\u0631\u06cc\u0646 \u0645\u0634\u06a9\u0644\u0627\u062a \u0645\u0634\u062a\u0631\u06cc\u0627\u0646\u06cc \u06a9\u0647 \u0627\u0632 \u0647\u0627\u0633\u062a \u0627\u0634\u062a\u0631\u0627\u06a9\u06cc \u0648 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0648\u0628 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0628\u0647 \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u06cc\u0627 \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u06a9\u0648\u0686 \u0645\u06cc\u06a9\u0646\u0646\u062f \u0645\u0634\u06a9\u0644 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc sql \u0628\u0632\u0631\u06af \u0648 \u062d\u062c\u06cc\u0645 \u062f\u0631 MySQL \u0633\u0631\u0648\u0631 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0627\u0633\u062a . \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f phpmyadmin \u06cc\u0627 MySQL\u00a0 Dumper \u0642\u0627\u062f\u0631 \u0628\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0647\u0627\u06cc \u062e\u06cc\u0644\u06cc \u0628\u0632\u0631\u06af \u0648 \u062d\u062c\u06cc\u0645 \u0646\u06cc\u0633\u062a\u0646\u062f \u0648 \u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0646\u062a\u0642\u0627\u0644 \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0628\u0627 \u0622\u0646 \u0647\u0627 \u0647\u0645\u06cc\u0634\u0647 \u0627\u062d\u062a\u0645\u0627\u0644 \u0648 \u062e\u0637\u0631 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0646\u0627\u0642\u0635 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0648 \u0622\u0633\u06cc\u0628 \u062f\u06cc\u062f\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f .<\/p>\n<p>\u0627\u0632 \u0637\u0631\u0641\u06cc \u0647\u0645\u06cc\u0634\u0647 \u0627\u0645\u06a9\u0627\u0646 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0628\u06a9\u0627\u067e \u06a9\u0644\u06cc \u06cc\u0627 Full Backup \u0628\u0631\u0627\u06cc \u062e\u0631\u06cc\u062f\u0627\u0631 \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u06cc\u0627 \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0627\u0645\u06a9\u0627\u0646 \u067e\u0630\u06cc\u0631 \u0646\u06cc\u0633\u062a . \u0645\u062b\u0644\u0627 \u0641\u0648\u0644 \u0628\u06a9\u0627\u067e \u062a\u0648\u0633\u0637 \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 cPanel \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u0648\u0644\u06cc \u0633\u0631\u0648\u0631 \u0645\u0642\u0635\u062f \u0627\u0632 \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 \u062f\u0627\u06cc\u0631\u06a9\u062a \u0627\u062f\u0645\u06cc\u0646 \u06cc\u0627 \u06a9\u0644\u0648\u06a9\u0633\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u06a9\u0646\u062f . \u062f\u0631 \u0627\u06cc\u0646 \u0648\u0636\u0639\u06cc\u062a \u0647\u06cc\u0686 \u0631\u0627\u0647\u06cc \u0646\u06cc\u0633\u062a \u062c\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0648 \u06a9\u0627\u0645\u0646\u062f \u0647\u0627\u06cc ssh \u062f\u0631 \u0644\u06cc\u0646\u0648\u06a9\u0633 . \u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d \u0627\u0632 \u0627\u06cc\u0646 \u06a9\u0627\u0645\u0646\u062f \u0647\u0627 \u0648 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc MySQL \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u060c \u0642\u0627\u062f\u0631 \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0648\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc MySQL \u0628\u0627 \u067e\u0633\u0648\u0646\u062f .sql \u0648 \u062d\u062c\u0645 \u0647\u0627\u06cc \u0628\u0627\u0644\u0627\u06cc \u06f1\u06f5 \u0648 \u06f2\u06f0 \u06af\u06cc\u06af \u0631\u0627 \u062f\u0631 \u06a9\u0645\u062a\u0631\u06cc\u0646 \u0632\u0645\u0627\u0646 \u0645\u0645\u06a9\u0646 \u0648 \u0628\u062f\u0648\u0646 \u062e\u0637\u0627 \u0648 \u0622\u0633\u06cc\u0628 \u062f\u06cc\u062f\u0646 \u0628\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0646\u06cc\u062f .<\/p>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u0646\u062c\u0627\u0645 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062a\u0648\u0633\u0637 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0644\u06cc\u0646\u0648\u06a9\u0633 \u062f\u0631 \u0645\u062d\u06cc\u0637 ssh \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0627\u0646\u062f\u0627\u0632\u0647 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 max_allowed_packet \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062d\u062c\u0645 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u062a\u0646\u0638\u06cc\u0645 \u0646\u0645\u0627\u06cc\u06cc\u062f . \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0628\u0627\u06cc\u062f \u0641\u0627\u06cc\u0644 my.cnf \u062f\u0631 \u0645\u0633\u06cc\u0631 \/etc\/ \u0631\u0627 \u0627\u062f\u06cc\u062a \u06a9\u0631\u062f\u0647 \u0648 \u0645\u06cc\u0632\u0627\u0646 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u062e\u0648\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f . \u0633\u067e\u0633 \u0641\u0627\u06cc\u0644 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f\u0647 \u0648 \u0633\u0631\u0648\u06cc\u0633 MySQL \u0631\u0627 \u0631\u06cc\u0633\u062a \u06a9\u0646\u06cc\u062f .<\/p>\n<p style=\"text-align: justify;\">\u062d\u0627\u0644\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 \u0648\u0628 \u0647\u0627\u0633\u062a\u06cc\u0646\u06af \u0633\u0631\u0648\u0631 \u062e\u0648\u062f \u0634\u0648\u06cc\u062f \u0648 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f . \u0633\u067e\u0633 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0648 \u06a9\u0644\u0645\u0647 \u0639\u0628\u0648\u0631 \u0627\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062c\u062f\u06cc\u062f \u0631\u0627 \u0633\u0627\u062e\u062a\u0647 \u0648 \u0628\u0647 \u0622\u0646 \u0627\u062e\u062a\u0635\u0627\u0635 \u062f\u0647\u06cc\u062f . \u062d\u0627\u0644\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 ssh \u0648\u0627\u0631\u062f \u0641\u0648\u0644\u062f\u0631 \u0648 \u067e\u0648\u0634\u0647 \u0627\u06cc \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0641\u0627\u06cc\u0644 .sql \u062f\u0631 \u0622\u0646 \u0648\u0627\u0642\u0639 \u0634\u062f\u0647 \u0627\u0633\u062a . \u0628\u0627 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0632\u06cc\u0631 \u0627\u0642\u062f\u0627\u0645 \u0628\u0647 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644 .sql \u062f\u0627\u062e\u0644 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MySQL \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 \u0648\u0628 \u0647\u0627\u0633\u062a\u06cc\u0646\u06af \u062e\u0648\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f :<\/p>\n<p style=\"text-align: justify;\">mysql -u dbuser -p\u00a0 dbname &lt; db.sql<\/p>\n<p style=\"text-align: justify;\">\u0628\u0627 \u0632\u062f\u0646 \u06a9\u0644\u06cc\u062f Enter \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0627\u0632 \u0634\u0645\u0627 \u0631\u0645\u0632 \u0648 \u06a9\u0644\u0645\u0647 \u0639\u0628\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 \u0631\u0627 \u0645\u06cc\u062e\u0648\u0627\u0647\u062f \u06a9\u0647 \u0628\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0622\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0622\u063a\u0627\u0632 \u0645\u06cc\u06af\u0631\u062f\u062f . \u0627\u06af\u0631 \u0628\u0647 \u06a9\u0644\u0645\u0647 \u0639\u0628\u0648\u0631 MySQL Root Password \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0631\u06cc\u062f \u0645\u06cc\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u06a9\u0644\u0645\u0647 \u0639\u0628\u0648\u0631 \u0648 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u0642\u062f\u0627\u0645 \u0628\u0647 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0622\u0646 \u0628\u0627 \u06cc\u0648\u0632\u0631 root \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u0646\u0645\u0627\u06cc\u06cc\u062f :<\/p>\n<p style=\"text-align: justify;\">mysql -u root -p\u00a0 dbname &lt; db.sql<\/p>\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>\u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u067e\u0631 \u062d\u062c\u0645 \u0648 \u0628\u0632\u0631\u06af \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u062d\u06cc\u0637 ssh \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0633\u0631\u0648\u0631 \u06cc\u06a9\u06cc \u0627\u0632 \u0628\u0632\u0631\u06af \u062a\u0631\u06cc\u0646 \u0645\u0634\u06a9\u0644\u0627\u062a \u0645\u0634\u062a\u0631\u06cc\u0627\u0646\u06cc \u06a9\u0647 \u0627\u0632 \u0647\u0627\u0633\u062a \u0627\u0634\u062a\u0631\u0627\u06a9\u06cc \u0648 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0648\u0628 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0628\u0647 \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u06cc\u0627 \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u06a9\u0648\u0686 \u0645\u06cc\u06a9\u0646\u0646\u062f \u0645\u0634\u06a9\u0644 \u0631\u06cc\u0633\u062a\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc sql \u0628\u0632\u0631\u06af \u0648 \u062d\u062c\u06cc\u0645 \u062f\u0631 MySQL \u0633\u0631\u0648\u0631 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0627\u0633\u062a . [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1358,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[88],"tags":[152,153,154,149,155,156,150,157,151,158,159,110],"class_list":["post-1372","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-directadmin","tag-max_allowed_packet","tag-mysql","tag-mysql-dumper","tag-phpmyadmin","tag-sql","tag-ssh","tag-150","tag-157","tag-151","tag-158","tag-159","tag-110"],"_links":{"self":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts\/1372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/comments?post=1372"}],"version-history":[{"count":0,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/posts\/1372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/media?parent=1372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/categories?post=1372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/host97.net\/wiki\/wp-json\/wp\/v2\/tags?post=1372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}