{"id":85,"date":"2025-10-30T20:30:13","date_gmt":"2025-10-30T20:30:13","guid":{"rendered":"https:\/\/adveyer.com\/blog\/?p=85"},"modified":"2025-11-01T09:39:58","modified_gmt":"2025-11-01T09:39:58","slug":"linux-mysql-yedek-alma","status":"publish","type":"post","link":"https:\/\/adveyer.com\/blog\/linux-mysql-yedek-alma\/","title":{"rendered":"Linux MySQL Yedek Alma"},"content":{"rendered":"

MySQL Yedek Alma (SSH \u00dczerinden Pratik Rehber)<\/h2>\n

Linux sunucularda MySQL veritaban\u0131 yedekleme i\u015flemi<\/strong>, \u00f6zellikle b\u00fcy\u00fck boyutlu SQL dosyalar\u0131 s\u00f6z konusu oldu\u011funda do\u011fru y\u00f6ntemler kullan\u0131lmazsa olduk\u00e7a zahmetli hale gelebilir. \u00d6rne\u011fin, phpMyAdmin<\/strong> belirli limitler nedeniyle b\u00fcy\u00fck veritabanlar\u0131nda yedekleme veya geri y\u00fckleme i\u015flemlerinde yetersiz kalabilir.<\/p>\n

Bu gibi durumlarda, SSH \u00fczerinden do\u011frudan komut sat\u0131r\u0131nda i\u015flem yapmak<\/strong>, b\u00fcy\u00fck veritabanlar\u0131n\u0131 yedeklemenin en pratik ve etkili<\/strong> y\u00f6ntemidir.
A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyerek SSH ile MySQL veritaban\u0131 yede\u011fi alabilirsiniz.<\/p>\n

Standart Yedek Alma<\/h3>\n

MySQL veritaban\u0131n\u0131z\u0131 a\u015fa\u011f\u0131daki mysqldump<\/strong> komutunu kullanarak kolayca yedekleyebilirsiniz:<\/p>\n

\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
mysqldump -u kullaniciadi -p dbadi > backup.sql\r\n<\/code><\/pre>\n<\/div>\n
Bu komut, belirtilen veritaban\u0131n\u0131n yede\u011fini backup.sql<\/strong> adl\u0131 dosyaya kaydeder.
Komutu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda sizden MySQL kullan\u0131c\u0131 parolan\u0131z<\/strong> istenecektir.<\/p>\n
\u00d6rnek:<\/strong><\/p>\n
mysqldump -u root -p ornekveritabani > ornekbackup.sql<\/code><\/pre>\n
S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f Yedek Alma<\/h3>\n
B\u00fcy\u00fck veritabanlar\u0131nda yerden tasarruf etmek istiyorsan\u0131z, yede\u011finizi s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f<\/strong> bir \u015fekilde alabilirsiniz. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\n
\n
mysqldump -u kullaniciadi -p dbadi | gzip > backup.sql.gz\r\n<\/code><\/pre>\n<\/div>\n
Bu y\u00f6ntemle yede\u011finiz .gz uzant\u0131l\u0131<\/strong> bir s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosya olarak kaydedilir.
B\u00f6ylece hem disk alan\u0131ndan tasarruf eder<\/strong>, hem de yedekleme s\u00fcrecini h\u0131zland\u0131r\u0131rs\u0131n\u0131z.<\/strong><\/p>\n
\u00d6nemli Not<\/h3>\n
\n
Yukar\u0131daki \u00f6rneklerde ge\u00e7en kullaniciadi<\/strong> ve dbadi<\/strong> k\u0131s\u0131mlar\u0131n\u0131, kendi sunucunuzdaki MySQL kullan\u0131c\u0131 ad\u0131<\/strong> ve yedeklemek istedi\u011finiz veritaban\u0131 ad\u0131yla<\/strong> de\u011fi\u015ftirmeyi unutmay\u0131n.<\/p>\n<\/blockquote>\n
Ek \u0130pucu:<\/strong><\/h3>\n
\n
Yedekleme i\u015flemini otomatik hale getirmek isterseniz, bu komutlar\u0131 cron job<\/strong> olarak zamanlayabilir ve d\u00fczenli aral\u0131klarla otomatik MySQL yede\u011fi alabilirsiniz.<\/p>\n<\/blockquote>\n
\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
MySQL Yedek Alma (SSH \u00dczerinden Pratik Rehber) Linux sunucularda MySQL veritaban\u0131 yedekleme i\u015flemi, \u00f6zellikle b\u00fcy\u00fck boyutlu SQL dosyalar\u0131 s\u00f6z konusu oldu\u011funda do\u011fru y\u00f6ntemler kullan\u0131lmazsa olduk\u00e7a zahmetli hale gelebilir. \u00d6rne\u011fin, phpMyAdmin belirli limitler nedeniyle b\u00fcy\u00fck veritabanlar\u0131nda yedekleme veya geri y\u00fckleme i\u015flemlerinde yetersiz kalabilir. Bu gibi durumlarda, SSH \u00fczerinden do\u011frudan komut sat\u0131r\u0131nda i\u015flem yapmak, b\u00fcy\u00fck veritabanlar\u0131n\u0131 yedeklemenin […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-85","post","type-post","status-publish","format-standard","hentry","category-linux-genel"],"_links":{"self":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":2,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/85\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}