{"id":1055,"date":"2021-10-10T19:49:07","date_gmt":"2021-10-10T16:49:07","guid":{"rendered":"https:\/\/www.hostixo.com\/bilgi-bankasi\/?p=1055"},"modified":"2021-10-10T19:48:22","modified_gmt":"2021-10-10T16:48:22","slug":"ssh-ile-mysql-yukleme","status":"publish","type":"post","link":"https:\/\/www.hostixo.com\/bilgi-bankasi\/ssh-ile-mysql-yukleme\/","title":{"rendered":"SSH ile MySQL Veri Taban\u0131 Nas\u0131l Y\u00fcklenir?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0130\u00e7indekiler \u2714<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a68a0daa53fa\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a68a0daa53fa\"  aria-label=\"A\u00e7\/Kapat\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hostixo.com\/bilgi-bankasi\/ssh-ile-mysql-yukleme\/#SSH_Baglantisi_Icin_Neler_Gereklidir\" >SSH Ba\u011flant\u0131s\u0131 \u0130\u00e7in Neler Gereklidir?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hostixo.com\/bilgi-bankasi\/ssh-ile-mysql-yukleme\/#MySQL_veri_tabani_yedegini_SSH_ile_alma_%E2%80%93_Export\" >MySQL veri taban\u0131 yede\u011fini SSH ile alma \u2013 Export<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hostixo.com\/bilgi-bankasi\/ssh-ile-mysql-yukleme\/#MySQL_veri_tabanini_SSH_ile_ice_aktarma_%E2%80%93_Import\" >MySQL veri taban\u0131n\u0131 SSH ile i\u00e7e aktarma \u2013 Import<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>SSH ile MySQL Veri Taban\u0131<\/strong> Nas\u0131l Y\u00fcklenir? G\u00fcn\u00fcm\u00fczde kullan\u0131lmakta olan sunucular <strong>kontrol paneline<\/strong> sahip olabilece\u011fi gibi kontrol paneli bulunmayan sunucular da bulunmaktad\u0131r. Bu sunucularda <strong><a href=\"https:\/\/www.hostixo.com\/bilgi-bankasi\/?p=1714\" data-internallinksmanager029f6b8e52c=\"13\" title=\"cpanel nedir\">cPanel<\/a><\/strong>, <strong>PhpMyAdmin<\/strong> vb. kontrol panelleri y\u00fckl\u00fc de\u011fildir. <strong>SQL<\/strong> dosyalar\u0131n\u0131 bu sunuculardan birine y\u00fcklenmesi gerekti\u011fi durumlarda <strong>SSH komut sat\u0131r\u0131<\/strong> kullan\u0131lmaktad\u0131r. \u00d6zellikle 128 MB\u2019tan b\u00fcy\u00fck veri tabanlar\u0131n\u0131n SSH ile y\u00fcklemesi daha sa\u011fl\u0131kl\u0131 bir y\u00f6ntem olacakt\u0131r. Aksi taktirde PhpMyAdmin <strong>veri taban\u0131 boyut limiti hatas\u0131<\/strong> ile geri d\u00f6necektir. Boyut limitini de\u011fi\u015ftirmenin yollar\u0131 da m\u00fcmk\u00fcn oldu\u011fu gibi<strong> SSH<\/strong> ile hata almadan kolayca <strong>i\u00e7e aktarma<\/strong> veya <strong>d\u0131\u015fa aktarma<\/strong> i\u015flemleri ger\u00e7ekle\u015ftirilmektedir. Bir aray\u00fcz kullanmadan bunu yapmak a\u015fa\u011f\u0131da anlat\u0131lan ad\u0131mlar ile aray\u00fcz kullanmak kadar kolay ve m\u00fcmk\u00fcn hale gelmektedir.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"SSH_Baglantisi_Icin_Neler_Gereklidir\"><\/span>SSH Ba\u011flant\u0131s\u0131 \u0130\u00e7in Neler Gereklidir?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00d6ncelikle bu i\u015flemlerin yap\u0131labilmesi i\u00e7in bir <a href=\"https:\/\/www.hostixo.com\/sunucu\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"sunucu sat\u0131n al\">sunucu<\/a> olmas\u0131 gerekmektedir. Anlat\u0131lan komutlar\u0131n t\u00fcm\u00fc bir <strong><a href=\"https:\/\/www.hostixo.com\/hosting\/linux-hosting\/\">Linux<\/a> VPS<\/strong> (Virtual Private <a href=\"https:\/\/www.hostixo.com\/sunucu\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"sunucu sat\u0131n al\">Server<\/a>) sunucusunda \u00e7al\u0131\u015ft\u0131r\u0131labilir. Son olarak bu sunucuda <strong>root<\/strong> yetkisine sahip olmak gerekmektedir.<\/p>\n<p>Anlat\u0131lan komutlar \u00e7al\u0131\u015ft\u0131r\u0131l\u0131rken <em>kullan\u0131c\u0131ad\u0131<\/em> yerine <strong>veri taban\u0131 MySQL<\/strong> kullan\u0131c\u0131 ad\u0131yla, <em>veritaban\u0131ad\u0131<\/em> yerine <strong>MySQL veri taban\u0131<\/strong> ad\u0131 de\u011fi\u015ftirilmesi gerekmektedir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MySQL_veri_tabani_yedegini_SSH_ile_alma_%E2%80%93_Export\"><\/span>MySQL veri taban\u0131 yede\u011fini SSH ile alma \u2013 Export<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Veri taban\u0131 yede\u011fini almak i\u00e7in <strong>mysqldump<\/strong> komutu a\u015fa\u011f\u0131daki parametreler ile kullan\u0131lmaktad\u0131r. Yede\u011fin al\u0131naca\u011f\u0131 dizinde \u00e7al\u0131\u015ft\u0131r\u0131lacak komut:<\/p>\n<p><strong>mysqldump -u <em>kullan\u0131c\u0131ad\u0131<\/em> -p <em>veritaban\u0131ad\u0131<\/em> &gt; yedekdosyaad\u0131.sql<\/strong><\/p>\n<p>Komut \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda parola istenecektir. <strong>MySQL<\/strong> kullan\u0131c\u0131 parolas\u0131 girildi\u011finde ge\u00e7erli dizinde yedekdosyaad\u0131.sql adl\u0131 dosya kaydedilecektir.<\/p>\n<p>Yedek dosyas\u0131n\u0131n s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir \u015fekilde al\u0131nmas\u0131 i\u00e7in <strong>gzip<\/strong> komutu dahil edilerek dosya uzant\u0131s\u0131na .gz dahil edilmelidir. Ge\u00e7erli dizinde \u00e7al\u0131\u015ft\u0131r\u0131lacak komut:<\/p>\n<p><strong>mysqldump -u kullan\u0131c\u0131ad\u0131 -p veritaban\u0131ad\u0131 | gzip &gt; yedekdosyaad\u0131.sql.gz<\/strong><\/p>\n<p>Komut \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda parola girildikten sonra ge\u00e7erli dizinde yedekdosyaad\u0131.sql.gz adl\u0131 dosya kaydedilecektir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MySQL_veri_tabanini_SSH_ile_ice_aktarma_%E2%80%93_Import\"><\/span>MySQL veri taban\u0131n\u0131 SSH ile i\u00e7e aktarma \u2013 Import<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Veri taban\u0131n\u0131 i\u00e7e aktarmak i\u00e7in <strong>mysql veritaban\u0131<\/strong> komutu a\u015fa\u011f\u0131daki parametreler ile kullan\u0131lmaktad\u0131r. Komutun \u00e7al\u0131\u015ft\u0131r\u0131laca\u011f\u0131 dizin i\u00e7e aktar\u0131lacak dosya ile ayn\u0131 dizin de\u011filse dosya ad\u0131 dosya yolu ile girilmesi gerekmektedir. Ge\u00e7erli dizinde \u00e7al\u0131\u015ft\u0131r\u0131lacak komut:<\/p>\n<p><strong>mysql -u <em>kullan\u0131c\u0131ad\u0131<\/em> -p <em>veritaban\u0131ad\u0131<\/em> &lt; yedekdosyaad\u0131.sql<\/strong><\/p>\n<p>Komut \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda parola istenecektir. Parola girildikten sonra dosya y\u00fcklenecektir.<\/p>\n<p>S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir yedek dosyas\u0131n\u0131 i\u00e7e aktarmak i\u00e7in yine gunzip komutu a\u015fa\u011f\u0131daki komutta g\u00f6sterildi\u011fi \u015fekilde dahil edilmelidir. Ge\u00e7erli dizinde \u00e7al\u0131\u015ft\u0131r\u0131lacak komut:<\/p>\n<p><strong>gunzip &lt; yedekdosyaad\u0131.sql.gz | mysql -u <em>kullan\u0131c\u0131ad\u0131<\/em> -p <em>veritaban\u0131ad\u0131<\/em><\/strong><\/p>\n<p>\u0130stenilen parola girildikten sonra s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f veri taban\u0131 dosyas\u0131 i\u00e7e aktar\u0131lm\u0131\u015f olacakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SSH ile MySQL Veri Taban\u0131 Nas\u0131l Y\u00fcklenir? G\u00fcn\u00fcm\u00fczde kullan\u0131lmakta olan sunucular kontrol paneline sahip olabilece\u011fi gibi kontrol paneli bulunmayan sunucular da bulunmaktad\u0131r. Bu sunucularda cPanel, PhpMyAdmin vb. kontrol panelleri y\u00fckl\u00fc de\u011fildir. SQL dosyalar\u0131n\u0131 bu sunuculardan birine y\u00fcklenmesi gerekti\u011fi durumlarda SSH komut sat\u0131r\u0131 kullan\u0131lmaktad\u0131r. \u00d6zellikle 128 MB\u2019tan b\u00fcy\u00fck veri tabanlar\u0131n\u0131n SSH ile y\u00fcklemesi daha sa\u011fl\u0131kl\u0131 bir [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1055","post","type-post","status-publish","format-standard","hentry","category-mysql-islemleri"],"_links":{"self":[{"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/1055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/comments?post=1055"}],"version-history":[{"count":3,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/1055\/revisions"}],"predecessor-version":[{"id":1058,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/1055\/revisions\/1058"}],"wp:attachment":[{"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/media?parent=1055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/categories?post=1055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostixo.com\/bilgi-bankasi\/wp-json\/wp\/v2\/tags?post=1055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}