{"id":11811,"date":"2024-11-30T10:05:16","date_gmt":"2024-11-30T07:05:16","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=11811"},"modified":"2024-11-30T10:09:16","modified_gmt":"2024-11-30T07:09:16","slug":"ssh-ile-mysql-yedek-alma-islemi-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/ssh-ile-mysql-yedek-alma-islemi-nasil-yapilir\/","title":{"rendered":"SSH ile MySQL Yedek Alma \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<p>Linux sunucularda MySQL veritaban\u0131 yedekleme i\u015flemi b\u00fcy\u00fck boyutlu SQL dosyalar\u0131 s\u00f6z konusu oldu\u011funda do\u011fru y\u00f6ntemler kullan\u0131lmazsa olduk\u00e7a zorulu bir s\u00fcre\u00e7 haline gelebilir. \u00d6rne\u011fin <strong>phpMyAdmin<\/strong>\u00a0 s\u0131n\u0131rlar nedeniyle yedekleme ve geri y\u00fckleme i\u015flemlerinde yetersiz kalabilir. Bu durumda direkt olarak sunucunuzda SSH \u00fczerinden \u00e7al\u0131\u015fmak b\u00fcy\u00fck veritabanlar\u0131n\u0131 kolayca yedeklemenin pratik ve etkili bir yoludur. SSH MySQL yede\u011fi alma i\u015flemi i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n<h2><strong>Standart Yedek Alma<\/strong><\/h2>\n<p>MySQL veritaban\u0131n\u0131z\u0131 a\u015fa\u011f\u0131da \u00f6rnekte verilen <strong>mysqldump<\/strong> komutuyla kolayca yedekleyebilirsiniz.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-bash\">mysqldump -u kullaniciadi -p dbadi &gt; backup.sql<br \/>\n<\/code><\/div>\n<\/div>\n<p>(Bu komut belirtilen veritaban\u0131n\u0131n yede\u011fini <code>backup.sql<\/code> dosyas\u0131na kaydedecektir. Komut \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda sizden MySQL kullan\u0131c\u0131 parolan\u0131z istenecektir.)<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11827 aligncenter\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/11\/sshmysqlbackup-300x191.png\" alt=\"\" width=\"528\" height=\"336\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/11\/sshmysqlbackup-300x191.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/11\/sshmysqlbackup-768x488.png 768w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/11\/sshmysqlbackup.png 827w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/>%72 \u0130ndirimle <a href=\"https:\/\/www.inetmar.com\/sunucu\/vds-sunucu\/\" target=\"_blank\" rel=\"noopener\">VDS Sunucu<\/a> Sahibi Olun.<\/p>\n<h2><strong>S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f Yedek Alma<\/strong><\/h2>\n<p>E\u011fer yede\u011finizin boyutunu s\u0131k\u0131\u015ft\u0131r\u0131p alandan tasarruf etmek istiyorsan\u0131z yede\u011finizi s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f bir \u015fekilde alabilirsiniz. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-bash\">mysqldump -u kullaniciadi -p dbadi | gzip &gt; backup.sql.gz<br \/>\n<\/code><\/div>\n<\/div>\n<p>Bu y\u00f6ntemle yede\u011finiz <code>.gz<\/code> uzant\u0131l\u0131 bir s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosya olarak kaydedilir bu sayede b\u00fcy\u00fck veritabanlar\u0131nda \u00f6nemli \u00f6l\u00e7\u00fcde yer tasarrufu sa\u011flar.<\/p>\n<p><strong>NOT:<\/strong> Yukar\u0131daki \u00f6rnek komutlarda yer alan <code>kullaniciadi<\/code> ve <code>dbadi<\/code> k\u0131sm\u0131n\u0131 sunucunuzdaki MySQL kullan\u0131c\u0131 ad\u0131 ve yedeklemek istedi\u011finiz veritaban\u0131n\u0131n ad\u0131yla de\u011fi\u015ftirmeyi unutmay\u0131n. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Linux sunucularda MySQL veritaban\u0131 yedekleme i\u015flemi b\u00fcy\u00fck boyutlu SQL dosyalar\u0131 s\u00f6z konusu oldu\u011funda do\u011fru y\u00f6ntemler kullan\u0131lmazsa olduk\u00e7a zorulu bir s\u00fcre\u00e7 haline gelebilir. \u00d6rne\u011fin phpMyAdmin\u00a0 s\u0131n\u0131rlar nedeniyle yedekleme ve geri y\u00fckleme i\u015flemlerinde yetersiz kalabilir. Bu durumda&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":11829,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,54],"tags":[],"class_list":["post-11811","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=11811"}],"version-history":[{"count":17,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11811\/revisions"}],"predecessor-version":[{"id":11831,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11811\/revisions\/11831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/11829"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=11811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=11811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=11811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}