{"id":7354,"date":"2023-09-15T11:46:59","date_gmt":"2023-09-15T08:46:59","guid":{"rendered":"https:\/\/demo3.lond.net\/blog\/?p=7354"},"modified":"2025-01-22T13:17:59","modified_gmt":"2025-01-22T10:17:59","slug":"ssh-ile-mysql-import-islemi-gerceklestirmek","status":"publish","type":"post","link":"https:\/\/isimkaydet.com\/blog\/ssh-ile-mysql-import-islemi-gerceklestirmek\/","title":{"rendered":"SSH ile MYSQL \u0130mport\u0130\u015flemi Ger\u00e7ekle\u015ftirmek"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">cPanel \u00fczerinden ba\u011flant\u0131 yap\u0131larak giri\u015f yapt\u0131\u011f\u0131m\u0131z phpMyadmin panelinden belli bir limite(2mb)\u00a0 kadar import yani i\u00e7erik y\u00fcklemeyi phpMyAdmin paneli \u00fczerinden ger\u00e7ekle\u015ftirebilmekteyiz. Fakat 2 MB ve \u00fczeri sql dosyalar\u0131m\u0131z\u0131 import etmek istedi\u011fimiz de phpMyAdmin paneli \u00fczerinden y\u00fckleme i\u015flemi ger\u00e7ekle\u015ftirememekteyiz. Bu sebepten \u00f6t\u00fcr\u00fc ssh ba\u011flant\u0131s\u0131 ile sunucumuza root eri\u015fimi yaparak ba\u011flanmam\u0131z gerekmektedir. SSH \u00fczerinden y\u00fckleme yapmak i\u00e7in s\u0131ras\u0131yla \u015fu ad\u0131mlar\u0131 izlemeniz gerekmektedir;<br \/><br \/>1) Daha \u00f6nce phpMyAdmin panelinden edinmi\u015f oldu\u011funuz backup.sql dosyan\u0131z, b\u00fcy\u00fck\u00a0 boyutta ise zipleyip y\u00fcklemeniz daha uygun olacakt\u0131r. K\u00fc\u00e7\u00fck boyutta ise ftp adresinizin public_html klas\u00f6r\u00fcne y\u00fckleyiniz.<br \/>2) SSH ile root giri\u015fi yap\u0131n\u0131z.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">3) Web alan\u0131na y\u00fckleme i\u015flemi ger\u00e7ekle\u015ftirdiyseniz\u00a0 &#8221; wget https:\/\/siteadi.com\/backup.sql &#8221;\u00a0 \u00a0\u015feklinde sunucunuza indiriniz. Yada &#8221; wget https:\/\/siteadi.com\/backup.zip&#8221;<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">4)Yedekleme yapt\u0131\u011f\u0131n\u0131z public_html klas\u00f6r dizinine gidiniz.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">5) SSH \u00fczerinden &#8220;mysql -u veritabani_kullanici_adi -p veritabani_adi &lt; backup.sql&#8221;\u00a0 komutunu giriniz. Sizden \u015fifre isteyecektir veritaban\u0131 \u015fifrenizi giriniz. Her hangi bir hata almad\u0131ysan\u0131z backup.sql dosyan\u0131z ba\u015far\u0131yla y\u00fcklenmi\u015ftir.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>cPanel \u00fczerinden ba\u011flant\u0131 yap\u0131larak giri\u015f yapt\u0131\u011f\u0131m\u0131z phpMyadmin panelinden belli bir limite(2mb)\u00a0 kadar import yani i\u00e7erik y\u00fcklemeyi phpMyAdmin paneli \u00fczerinden ger\u00e7ekle\u015ftirebilmekteyiz. Fakat 2 MB ve \u00fczeri sql dosyalar\u0131m\u0131z\u0131 import etmek istedi\u011fimiz de phpMyAdmin paneli \u00fczerinden y\u00fckleme i\u015flemi ger\u00e7ekle\u015ftirememekteyiz. Bu sebepten \u00f6t\u00fcr\u00fc ssh ba\u011flant\u0131s\u0131 ile sunucumuza root eri\u015fimi yaparak ba\u011flanmam\u0131z gerekmektedir. SSH \u00fczerinden y\u00fckleme yapmak i\u00e7in s\u0131ras\u0131yla<\/p>\n","protected":false},"author":1,"featured_media":7356,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-7354","post","type-post","status-publish","format-standard","has-post-thumbnail","category-web-hosting"],"_links":{"self":[{"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/posts\/7354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/comments?post=7354"}],"version-history":[{"count":3,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/posts\/7354\/revisions"}],"predecessor-version":[{"id":8309,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/posts\/7354\/revisions\/8309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/media\/7356"}],"wp:attachment":[{"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/media?parent=7354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/categories?post=7354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isimkaydet.com\/blog\/wp-json\/wp\/v2\/tags?post=7354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}