{"id":29961,"date":"2020-06-08T10:37:50","date_gmt":"2020-06-08T07:37:50","guid":{"rendered":"https:\/\/www.natro.com\/blog\/?p=29961"},"modified":"2020-06-17T17:14:45","modified_gmt":"2020-06-17T14:14:45","slug":"heidi-sql-ile-veritabani-yedegi-nasil-alinir","status":"publish","type":"post","link":"https:\/\/www.natro.com\/blog\/heidi-sql-ile-veritabani-yedegi-nasil-alinir\/","title":{"rendered":"Heidi SQL ile veritaban\u0131 yede\u011fi nas\u0131l al\u0131n\u0131r?"},"content":{"rendered":"<p>\u00d6ncelikle MySQL yede\u011fi al\u0131rken neden bu y\u00f6ntem ile veritaban\u0131 yede\u011fi almam\u0131z gerekti\u011fi ile ilgili biraz bilgilendirme yapmak istiyorum.<\/p>\n<p>G\u00fcn\u00fcm\u00fcz MySql veritabanlar\u0131 y\u00fcksek boyutta olduklar\u0131 i\u00e7in hem yedek al\u0131rken hem de bu ald\u0131\u011f\u0131m\u0131z yedekleri aktar\u0131rken zaman a\u015f\u0131m\u0131 veya internet kopmalar\u0131 ya\u015fayabiliyoruz. Bu nedenle h\u0131zl\u0131 ve kolay bir \u015fekilde veritaban\u0131 yedeklerinizi al\u0131p aktarman\u0131z konusunda sizlere Heidi SQL program\u0131 yard\u0131m\u0131yla nas\u0131l veritaban\u0131 yede\u011fi alaca\u011f\u0131m\u0131z\u0131 birlikte inceleyelim.<\/p>\n<h2 id=\"1-programin-kurulmasi\">1.Program\u0131n Kurulmas\u0131<\/h2>\n<p>A\u015fa\u011f\u0131daki link \u00fczerinden heidiSQL program\u0131n\u0131 bilgisayar\u0131n\u0131za indirebilirsiniz.<\/p>\n<p><a href=\"https:\/\/www.heidisql.com\/download.php\">https:\/\/www.heidisql.com\/download.php<\/a><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29962\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/heidi-sql-download.png\" alt=\"\" width=\"1204\" height=\"805\" \/><\/p>\n<h2 id=\"2-ip-izni\">2.IP\u00a0 \u0130zni<\/h2>\n<p>*Natro \u00fczerindeki web hosting paketlerimizde bulunan MySql veritabanlar\u0131na d\u0131\u015far\u0131dan 3.parti bir uygulama ile ba\u011flant\u0131 kurabilmemiz i\u00e7in ilgli veritaban\u0131na IP izni vermemiz gerekiyor. \u00d6ncelikle a\u015fa\u011f\u0131daki link \u00fczerinden IP adresinizi \u00f6\u011frenmeniz gerekir.<\/p>\n<p><a href=\"https:\/\/ipnedir.com\/\">https:\/\/ipnedir.com\/<\/a><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29963\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/ip-nedir.png\" alt=\"\" width=\"716\" height=\"406\" \/><\/p>\n<p>*IP adresimizi \u00f6\u011frendikten sonra Natro m\u00fc\u015fteri hesab\u0131n\u0131za giri\u015f yap\u0131yoruz ve s\u0131ras\u0131 ile;<\/p>\n<p>Hesab\u0131m>Hosting Y\u00f6netimi>Web Hosting Hesaplar\u0131>Y\u00f6net>Veritaban\u0131 Y\u00f6netimi k\u0131sm\u0131ndaki veritabanlar\u0131 i\u00e7erisinde hangisi i\u00e7in i\u015flem yapmak istiyorsan\u0131z onun i\u00e7in \u0130\u015flemler>\u015eifre De\u011fi\u015ftir\/IP G\u00fcncelle k\u0131sm\u0131nda ilgili IP\u2019yi ekleyip G\u00fcncelle dememiz gerekiyor.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29964\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/mp-veritabani.png\" alt=\"\" width=\"960\" height=\"395\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29965\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/mp-veritabani2.png\" alt=\"\" width=\"1103\" height=\"728\" \/><\/p>\n<h2 id=\"3-veritabanina-baglanma\">3.Veritaban\u0131na Ba\u011flanma<\/h2>\n<p>Program\u0131m\u0131z\u0131 indirip, veritaban\u0131m\u0131za\u00a0 IP iznimizi verdikten sonra art\u0131k Heidi SQL program\u0131 ile veritaban\u0131m\u0131za ba\u011flan\u0131p yede\u011fimizi alabiliriz.Bunun i\u00e7in;<\/p>\n<ol>\n<li>Heidi SQL program\u0131n\u0131 a\u00e7\u0131yoruz ve bizden istenen Sunucu ad\u0131, Kullan\u0131c\u0131 ve \u015eifreyi giriyoruz ve A\u00e7 diyoruz.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29967\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/heidi-vb.png\" alt=\"\" width=\"676\" height=\"411\" \/><\/p>\n<p>2.Heidi SQL ile veritaban\u0131m\u0131z\u0131 a\u00e7t\u0131ktan sonra, a\u015fa\u011f\u0131daki resim \u00fczerinden de g\u00f6rebilece\u011finiz \u00fczere ilgili veritaban\u0131m\u0131z\u0131\u00a0 \u00a0 \u00a0 \u00a0 Mouse ile sa\u011f t\u0131k yap\u0131p Veritaban\u0131n\u0131 SQL olarak d\u0131\u015fa aktar diyoruz.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29968\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/heidi-va.png\" alt=\"\" width=\"919\" height=\"595\" \/><\/p>\n<p>3.Kar\u015f\u0131m\u0131za gelecek olan ekrandaki ayarlar\u0131 a\u015fa\u011f\u0131daki resimdeki gibi d\u00fczenledikten sonra D\u0131\u015fa Aktar butonuna t\u0131klay\u0131p veritaban\u0131 yede\u011fimizi bilgisayar\u0131m\u0131za indirmi\u015f oluyoruz.Veritaban\u0131 boyutunuza ba\u011fl\u0131 olarak bu indirme i\u015flemi 15 dakika kadar s\u00fcrebilir.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29969\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/heidi-va2.png\" alt=\"\" width=\"919\" height=\"534\" \/><\/p>\n<p>4.Veritaban\u0131 boyutunuza ba\u011fl\u0131 olarak bu indirme i\u015flemi 15 dakika kadar s\u00fcrebilir.\u0130\u015flemin tamamland\u0131\u011f\u0131n\u0131 a\u015fa\u011f\u0131daki resimde de g\u00f6sterdi\u011fimi gibi Compressing done yaz\u0131s\u0131n\u0131 g\u00f6rd\u00fc\u011f\u00fcn\u00fczde anlayabilirsiniz. \u00a0Sitenizin veritaban\u0131 yede\u011fini bu program arac\u0131l\u0131\u011f\u0131 ile ba\u015far\u0131l\u0131 ve sorunsuz bir \u015fekilde alabilirsiniz. Ald\u0131\u011f\u0131n\u0131z bu yede\u011fi de yine ayn\u0131 program vas\u0131tas\u0131 ile ba\u015fka bir mysql veritaban\u0131na aktarabilirsiniz.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-29970\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2020\/06\/heidi-va3.png\" alt=\"\" width=\"945\" height=\"575\" \/><\/p>\n<p>\u015eimdiden faydal\u0131 bir yaz\u0131 olmas\u0131 dile\u011fi ile\u2026 Herhangi bir sorunuz var ise yorum k\u0131sm\u0131ndan sorabilirsiniz. \u0130yi \u00e7al\u0131\u015fmalar dilerim.<\/p>\n","protected":false},"excerpt":{"rendered":"\u00d6ncelikle MySQL yede\u011fi al\u0131rken neden bu y\u00f6ntem ile veritaban\u0131 yede\u011fi almam\u0131z gerekti\u011fi ile ilgili biraz bilgilendirme yapmak istiyorum.&hellip;\n","protected":false},"author":7,"featured_media":30008,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":{"0":"post-29961","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-nasil-yapilir"},"_links":{"self":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/29961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/comments?post=29961"}],"version-history":[{"count":0,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/29961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media\/30008"}],"wp:attachment":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media?parent=29961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/categories?post=29961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/tags?post=29961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}