{"id":92,"date":"2025-10-30T21:03:04","date_gmt":"2025-10-30T21:03:04","guid":{"rendered":"https:\/\/adveyer.com\/blog\/?p=92"},"modified":"2025-11-01T09:39:39","modified_gmt":"2025-11-01T09:39:39","slug":"linux-veri-tabani-onarma-ssh","status":"publish","type":"post","link":"https:\/\/adveyer.com\/blog\/linux-veri-tabani-onarma-ssh\/","title":{"rendered":"Linux Veri Taban\u0131 Onarma (SSH)"},"content":{"rendered":"

Merhaba,<\/p>\n

Bu yaz\u0131m\u0131zda sizlere SSH \u00fczerinden MySQL veritaban\u0131 onarma<\/strong> i\u015flemini ad\u0131m ad\u0131m anlataca\u011f\u0131z.
Zaman zaman veritabanlar\u0131nda tablolar\u0131n bozulmas\u0131, indeks hatalar\u0131 veya dosya yap\u0131s\u0131n\u0131n zarar g\u00f6rmesi gibi durumlar ya\u015fanabilir.
\u00d6zellikle b\u00fcy\u00fck veritabanlar\u0131nda<\/strong> bu t\u00fcr onar\u0131m i\u015flemleri web paneller (\u00f6rne\u011fin phpMyAdmin) \u00fczerinden yapmak hem riskli<\/strong> hem de yava\u015f<\/strong> olabilir.<\/p>\n

Bu nedenle, SSH ba\u011flant\u0131s\u0131 \u00fczerinden do\u011frudan komut sat\u0131r\u0131nda<\/strong> i\u015flem yapmak \u00e7ok daha g\u00fcvenli ve h\u0131zl\u0131 bir \u00e7\u00f6z\u00fcmd\u00fcr.
A\u015fa\u011f\u0131da, MySQL veritaban\u0131n\u0131z\u0131 onarmak i\u00e7in kullanabilece\u011finiz komutlar\u0131 ve a\u00e7\u0131klamalar\u0131n\u0131 bulabilirsiniz.<\/p>\n

1. Standart MySQL Veritaban\u0131 Onarma<\/h3>\n

MySQL veritaban\u0131n\u0131 onarmak i\u00e7in mysqlcheck<\/strong> arac\u0131n\u0131 kullanabilirsiniz.
A\u015fa\u011f\u0131daki komut, belirtilen veritaban\u0131ndaki tablolar\u0131 kontrol eder ve bozuk olanlar\u0131 onar\u0131r:<\/p>\n

\n
mysqlcheck -r [veritaban\u0131_ad\u0131]\r\n<\/code><\/pre>\n<\/div>\n
A\u00e7\u0131klama:<\/strong><\/p>\n
    \n
  • \n
    -r<\/code><\/strong> \u2192 (repair) onar\u0131m i\u015flemi anlam\u0131na gelir.<\/p>\n<\/li>\n
  • \n
    [veritaban\u0131_ad\u0131]<\/strong><\/code> \u2192 onarmak istedi\u011finiz veritaban\u0131n\u0131n ad\u0131n\u0131 buraya yaz\u0131n.<\/p>\n<\/li>\n<\/ul>\n
    \u00d6rnek:<\/strong><\/p>\n
    \n
    mysqlcheck -r firma_db\r\n<\/code><\/pre>\n<\/div>\n
    Bu komut, firma_db<\/em> adl\u0131 veritaban\u0131ndaki t\u00fcm tablolar\u0131 kontrol eder ve bozuk olanlar\u0131 otomatik olarak onar\u0131r.<\/p>\n
    2. myisamchk Arac\u0131 ile Onar\u0131m<\/h3>\n
    E\u011fer yukar\u0131daki komut i\u015fe yaramazsa, MyISAM tablolar\u0131n\u0131<\/strong> onarmak i\u00e7in alternatif olarak myisamchk<\/code> arac\u0131n\u0131 kullanabilirsiniz.<\/p>\n
    \n
    myisamchk -r \/var\/lib\/mysql\/[veritaban\u0131_ad\u0131]\/*\r\n<\/code><\/pre>\n<\/div>\n
    A\u00e7\u0131klama:<\/strong><\/p>\n
      \n
    • \n
      -r<\/code><\/strong> \u2192 onar\u0131m modunu ba\u015flat\u0131r.<\/p>\n<\/li>\n
    • \n
      \/var\/lib\/mysql\/[veritaban\u0131_ad\u0131]\/<\/strong><\/code> \u2192 tablolar\u0131n fiziksel olarak bulundu\u011fu dizindir.<\/p>\n<\/li>\n<\/ul>\n
      \u00d6rnek:<\/strong><\/p>\n
      \n
      myisamchk -r \/var\/lib\/mysql\/musteri_db\/*\r\n<\/code><\/pre>\n<\/div>\n
      \n
      \u26a0\ufe0f Dikkat:<\/strong>
      Bu komutu \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce MySQL servisinin kapal\u0131 olmas\u0131 gerekir.
      Aksi halde dosya eri\u015fim hatas\u0131 alabilirsiniz. Servisi durdurmak i\u00e7in:<\/p>\n<\/blockquote>\n
      \n
      systemctl stop mysql\r\n<\/code><\/pre>\n<\/div>\n
      Onar\u0131m tamamland\u0131ktan sonra yeniden ba\u015flatmak i\u00e7in:<\/p>\n
      \n
      systemctl start mysql\r\n<\/code><\/pre>\n<\/div>\n
      3. T\u00fcm Veritabanlar\u0131n\u0131 Toplu Olarak Onarmak<\/h3>\n
      Sunucunuzda birden fazla veritaban\u0131 varsa, her birini tek tek onarmak zaman alabilir.
      T\u00fcm veritabanlar\u0131n\u0131 otomatik olarak onarmak i\u00e7in \u015fu komutu kullanabilirsiniz:<\/p>\n
      \n
      mysqlcheck --repair -A\r\n<\/code><\/pre>\n<\/div>\n
      A\u00e7\u0131klama:<\/strong><\/p>\n
        \n
      • \n
        --repair<\/strong><\/code> \u2192 t\u00fcm tablolar\u0131 onar\u0131r.<\/p>\n<\/li>\n
      • \n
        -A<\/code><\/strong> \u2192 sunucudaki t\u00fcm veritabanlar\u0131n\u0131 kapsar.<\/p>\n<\/li>\n<\/ul>\n
        4. Veritabanlar\u0131n\u0131 Optimize Etmek<\/h3>\n
        Onar\u0131m i\u015fleminin ard\u0131ndan tablolar\u0131 optimize etmek<\/strong>, performans a\u00e7\u0131s\u0131ndan olduk\u00e7a faydal\u0131d\u0131r.
        A\u015fa\u011f\u0131daki komut, t\u00fcm veritabanlar\u0131ndaki tablolar\u0131 optimize eder:<\/p>\n
        \n
        mysqlcheck --optimize -A\r\n<\/code><\/pre>\n<\/div>\n
        A\u00e7\u0131klama:<\/strong><\/p>\n
          \n
        • \n
          --optimize<\/code><\/strong> \u2192 tablolar\u0131 yeniden d\u00fczenler, kullan\u0131lmayan alanlar\u0131 temizler.<\/p>\n<\/li>\n
        • \n
          -A<\/code><\/strong> \u2192 t\u00fcm veritabanlar\u0131n\u0131 dahil eder.<\/p>\n<\/li>\n<\/ul>\n
          Bu i\u015flem, veritaban\u0131n\u0131n daha h\u0131zl\u0131 sorgu \u00e7al\u0131\u015ft\u0131rmas\u0131na<\/strong> yard\u0131mc\u0131 olur.<\/p>\n
          5. Root \u015eifresiyle Onar\u0131m \u0130\u015flemi<\/h3>\n
          Baz\u0131 durumlarda root yetkisiyle do\u011frudan onar\u0131m yapmak gerekebilir.
          A\u015fa\u011f\u0131daki komut, root kullan\u0131c\u0131 bilgileriyle t\u00fcm veritabanlar\u0131n\u0131 onar\u0131r:<\/p>\n
          \n
          mysqlcheck -A -h localhost -u root -r -p\r\n<\/code><\/pre>\n<\/div>\n
          Komut \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda sizden MySQL root parolan\u0131z<\/strong> istenecektir.<\/p>\n
          Ek \u0130pu\u00e7lar\u0131<\/h3>\n
            \n
          • \n
            Yedek almadan veri taban\u0131 onarma yapmay\u0131n:<\/strong>
            Herhangi bir onar\u0131m i\u015flemine ba\u015flamadan \u00f6nce mutlaka veritaban\u0131n\u0131z\u0131n yede\u011fini al\u0131n.<\/p>\n
            \n
            <\/div>\n
            mysqldump -u root -p dbadi > yedek.sql\r\n<\/code><\/pre>\n<\/div>\n<\/li>\n
          • \n
            Otomatik bak\u0131m:<\/strong>
            Bu komutlar\u0131 cron job<\/strong> olarak zamanlayarak veritaban\u0131 bak\u0131m\u0131n\u0131 d\u00fczenli hale getirebilirsiniz.<\/p>\n<\/li>\n
          • \n
            Hata loglar\u0131n\u0131 inceleyin:<\/strong>
            Onar\u0131m sonras\u0131 h\u00e2l\u00e2 sorun ya\u015f\u0131yorsan\u0131z \/var\/log\/mysql\/error.log<\/code><\/strong> dosyas\u0131n\u0131 kontrol edin.<\/p>\n<\/li>\n<\/ul>\n
            Sonu\u00e7<\/h3>\n
            Bu yaz\u0131m\u0131zda SSH \u00fczerinden MySQL veritabanlar\u0131n\u0131 nas\u0131l onarabilece\u011finizi ad\u0131m ad\u0131m \u00f6\u011frendik.
            B\u00fcy\u00fck veritabanlar\u0131nda do\u011frudan SSH ile \u00e7al\u0131\u015fmak hem daha h\u0131zl\u0131 hem de g\u00fcvenli bir y\u00f6ntemdir.
            D\u00fczenli bak\u0131m ve optimize i\u015flemleriyle veritaban\u0131 performans\u0131n\u0131z\u0131 uzun vadede koruyabilirsiniz.<\/p>\n
            Bir sonraki yaz\u0131m\u0131zda MySQL performans art\u0131rma y\u00f6ntemleri<\/strong> konusuna de\u011finece\u011fiz.
            G\u00f6r\u00fc\u015fmek \u00fczere! \ud83d\udc4b<\/p>\n","protected":false},"excerpt":{"rendered":"
            Merhaba, Bu yaz\u0131m\u0131zda sizlere SSH \u00fczerinden MySQL veritaban\u0131 onarma i\u015flemini ad\u0131m ad\u0131m anlataca\u011f\u0131z.Zaman zaman veritabanlar\u0131nda tablolar\u0131n bozulmas\u0131, indeks hatalar\u0131 veya dosya yap\u0131s\u0131n\u0131n zarar g\u00f6rmesi gibi durumlar ya\u015fanabilir.\u00d6zellikle b\u00fcy\u00fck veritabanlar\u0131nda bu t\u00fcr onar\u0131m i\u015flemleri web paneller (\u00f6rne\u011fin phpMyAdmin) \u00fczerinden yapmak hem riskli hem de yava\u015f olabilir. Bu nedenle, SSH ba\u011flant\u0131s\u0131 \u00fczerinden do\u011frudan komut sat\u0131r\u0131nda i\u015flem yapmak […]<\/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-92","post","type-post","status-publish","format-standard","hentry","category-linux-genel"],"_links":{"self":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/92","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=92"}],"version-history":[{"count":3,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":96,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/posts\/92\/revisions\/96"}],"wp:attachment":[{"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adveyer.com\/blog\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}