{"id":1805,"date":"2021-07-08T19:25:33","date_gmt":"2021-07-08T14:55:33","guid":{"rendered":"https:\/\/iranspeed.net\/blog\/?p=1805"},"modified":"2021-07-08T19:25:33","modified_gmt":"2021-07-08T14:55:33","slug":"restore-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/iranspeed.net\/blog\/restore-database-in-cpanel\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u0633\u06cc \u067e\u0646\u0644"},"content":{"rendered":"

\u0647\u0645\u06cc\u0634\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062d\u0641\u0638 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0645\u0646\u06cc\u062a \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u06a9\u0627\u067e \u062a\u0647\u06cc\u0647 \u0646\u0645\u0648\u062f\u0647 \u0648 \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u0627\u0632 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0645\u06a9\u0627\u0646\u06cc \u0627\u0645\u0646 \u0648 \u0642\u0627\u0628\u0644 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0646\u0645\u0627\u06cc\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a \u0628\u0627 \u0622\u0645\u0648\u0632\u0634 \u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u0633\u06cc \u067e\u0646\u0644 \u0648 \u0633\u0631\u0648\u0631 \u0647\u0645\u0631\u0627\u0647 \u0645\u0627 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n

\u0645\u0648\u0627\u0642\u0639\u06cc \u06a9\u0647 \u0627\u062e\u062a\u0644\u0627\u0644 \u062f\u0631 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0645\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f\u060c \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0627\u0642\u0639 \u0645\u06cc\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0627\u0644\u0645 \u0645\u0634\u06a9\u0644 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u0646\u0645\u0627\u06cc\u06cc\u0645. \u0648\u0628 \u0645\u0633\u062a\u0631\u0647\u0627\u06cc \u062d\u0631\u0641\u0647 \u0627\u06cc \u0647\u0645\u06cc\u0634\u0647 \u0646\u0633\u062e\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0627\u06cc\u062a \u0647\u0627\u06cc\u0634\u0627\u0646 \u062f\u0631 \u0644\u0648\u06a9\u0627\u0644 \u0648 \u06cc\u0627 \u0633\u0631\u0648\u0631 \u062f\u06cc\u06af\u0631\u06cc \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u0633\u0627\u06cc\u062a \u0628\u0647 \u0647\u0627\u0633\u062a \u062f\u06cc\u06af\u0631 \u0648 \u06cc\u0627 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0633\u0627\u0644\u0645 \u0633\u0627\u06cc\u062a\u06cc \u06a9\u0647 \u0628\u0647 \u0647\u0645 \u0631\u06cc\u062e\u062a\u0647 \u06cc\u0627 \u0647\u06a9 \u0634\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f. \u067e\u0633 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0648 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0646\u062d\u0648\u0647 \u06cc \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0628\u06a9\u0627\u067e \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0645\u0647\u0645\u06cc \u062f\u0631 \u0648\u0628 \u0645\u0633\u062a\u0631\u06cc \u0633\u0627\u06cc\u062a \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n

\u0646\u062d\u0648\u0647 \u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u0633\u06cc \u067e\u0646\u0644 \u0648\u0633\u0631\u0648\u0631:<\/span>
\n<\/strong><\/h3>\n

\u0628\u0631\u0627\u06cc \u0631\u06cc\u0633\u062a\u0648\u0631 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0647 \u0631\u0648\u0634 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n

– \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Backup & Restore \u0627\u0632 \u0633\u0627\u06cc\u062a<\/p>\n

– \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 phpMyAdmin<\/p>\n

– \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \/ Command Line<\/p>\n

\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0647\u0631\u06cc\u06a9 \u0627\u0632 \u0631\u0648\u0634 \u0647\u0627\u00a0 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u06a9\u0627\u0645\u0644 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc \u062f\u0647\u06cc\u0645:<\/p>\n

\u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632\u00a0Backup & Restore\u00a0\u0627\u0632 \u0633\u0627\u06cc\u062a:<\/span><\/h3>\n

\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u06a9\u0627\u0631 \u0627\u0628\u062a\u062f\u0627 \u0648\u0627\u0631\u062f \u0633\u06cc \u067e\u0646\u0644 \u0647\u0627\u0633\u062a<\/a><\/span> \u062e\u0648\u062f \u0634\u0648\u06cc\u062f.. \u0648\u0627\u0632 \u0645\u0646\u0648 files \u06af\u0632\u06cc\u0646\u0647 \u06cc Backup \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n

\u0627\u0632 \u0642\u0633\u0645\u062a Restore a MySQL Database Backup \u0628\u0631 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 \u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0641\u0627\u06cc\u0644 \u06a9\u0644\u06cc\u06a9 \u0646\u0645\u0648\u062f\u0647 \u0648 \u0641\u0627\u06cc\u0644 sql \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f\u060c \u0633\u067e\u0633 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 \u06cc upload \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u06cc\u0633\u062a\u0648\u0631 \u0634\u0648\u062f.<\/p>\n

\"\u0622\u0645\u0648\u0632\u0634<\/p>\n

\u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632\u00a0phpMyAdmin:<\/span><\/h3>\n

\u0627\u0628\u062a\u062f\u0627 \u0648\u0627\u0631\u062f \u0633\u06cc \u067e\u0646\u0644 \u0634\u0648\u06cc\u062f \u0648\u0627\u0632 \u0645\u0646\u0648 databases \u00a0\u0648\u0627\u0631\u062f phpMyAdmin \u0634\u0648\u06cc\u062f.<\/p>\n

\u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\u062a\u0627\u0646 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n

\u0627\u0632 \u0633\u0631\u0628\u0631\u06af Import \u0628\u0631 \u0631\u0648\u06cc choose file \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u0648 \u0641\u0627\u06cc\u0644 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\u062a\u0627\u0646 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n

\u0628\u0631 \u0631\u0648\u06cc Go \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0639\u0645\u0644\u06cc\u0627\u062a \u0627\u06cc\u0645\u067e\u0648\u0631\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f.<\/p>\n

\"\u0622\u0645\u0648\u0632\u0634<\/p>\n

\u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \/ Command Line:<\/span><\/h3>\n

\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u0627\u0632 \u0645\u062d\u06cc\u0637 \u062f\u0633\u062a\u0648\u0631\u06cc SSH \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f. \u062f\u0633\u062a\u0648\u0631 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0645\u06cc \u0628\u0627\u0634\u062f:<\/p>\n

\n\t\t

\n\t\t\t
\n\t\t\t\t<\/span> mysql -p -u username database_name < file.sql\n\t\t\t<\/div>\n\t\t<\/div>\n\t\n

\n\t\t

\n\t\t\t
\n\t\t\t\t<\/span>\n

\u062a\u0630\u06a9\u0631: \u0628\u0639\u062f \u0627\u0632 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u067e\u0633\u0648\u0631\u062f \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u06cc\u06a9 \u06a9\u067e\u06cc \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062e\u0648\u0627\u0647\u062f \u0634\u062f. \u067e\u0633 \u0627\u0632 \u0627\u06cc\u0645\u067e\u0648\u0631\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 phpmyadmin \u0634\u0645\u0627 \u0642\u0627\u062f\u0631 \u0647\u0633\u062a\u06cc\u062f \u0628\u0627 \u0627\u062a\u0635\u0627\u0644 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0647 \u0633\u0627\u06cc\u062a\u062a\u0627\u0646\u060c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0633\u0627\u06cc\u062a\u062a\u0627\u0646 \u0631\u0627 \u0628\u0647 \u062e\u0648\u0628\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0627 \u0648\u0631\u0648\u062f \u0628\u0647 phpmyadmin \u0642\u0627\u062f\u0631 \u0647\u0633\u062a\u06cc\u062f \u06a9\u0647 \u062c\u062f\u0627\u0648\u0644 \u0627\u06cc\u0645\u067e\u0648\u0631\u062a \u0634\u062f\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06cc\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n

\n\t\t\t<\/div>\n\t\t<\/div>\n\t\n\n

\n \n
\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n<\/div>\n \n
\n Rate this post<\/span>\n <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u0647\u0645\u06cc\u0634\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u0634\u0648\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062d\u0641\u0638 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0645\u0646\u06cc\u062a \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u06a9\u0627\u067e \u062a\u0647\u06cc\u0647 \u0646\u0645\u0648\u062f\u0647 \u0648 \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u0627\u0632 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0645\u06a9\u0627\u0646\u06cc \u0627\u0645\u0646 \u0648 \u0642\u0627\u0628\u0644 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0646\u0645\u0627\u06cc\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a \u0628\u0627 \u0622\u0645\u0648\u0632\u0634 \u0631\u06cc\u0633\u062a\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 \u0633\u06cc \u067e\u0646\u0644 \u0648 \u0633\u0631\u0648\u0631 \u0647\u0645\u0631\u0627\u0647 \u0645\u0627 \u0628\u0627\u0634\u06cc\u062f. \u0645\u0648\u0627\u0642\u0639\u06cc \u06a9\u0647 \u0627\u062e\u062a\u0644\u0627\u0644 \u062f\u0631 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0645\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc …<\/p>\n","protected":false},"author":4,"featured_media":1806,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[64],"tags":[],"_links":{"self":[{"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/posts\/1805"}],"collection":[{"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/comments?post=1805"}],"version-history":[{"count":6,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/posts\/1805\/revisions"}],"predecessor-version":[{"id":1869,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/posts\/1805\/revisions\/1869"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/media\/1806"}],"wp:attachment":[{"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/media?parent=1805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/categories?post=1805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iranspeed.net\/blog\/wp-json\/wp\/v2\/tags?post=1805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}