{"id":5140,"date":"2025-03-08T00:06:16","date_gmt":"2025-03-07T21:06:16","guid":{"rendered":"https:\/\/hostingdunyam.com.tr\/blog\/?p=5140"},"modified":"2025-10-20T00:19:06","modified_gmt":"2025-10-19T21:19:06","slug":"veritabani-nasil-silinir","status":"publish","type":"post","link":"https:\/\/hostingdunyam.com.tr\/blog\/veritabani-nasil-silinir","title":{"rendered":"Veritaban\u0131 Nas\u0131l Silinir?"},"content":{"rendered":"<h3>Veritaban\u0131n\u0131 Silmek<\/h3>\n<p>Veritabanlar\u0131 sitelerin verilerinin tutuldu\u011fu yerdir. Bir\u00e7ok kez veritabanlar\u0131na \u00e7okca ihtiya\u00e7 duyulur. Hemen hemen her sitede bir veritaban\u0131 vard\u0131r.<\/p>\n<p>\u0130lk \u00f6nce <a href=\"https:\/\/hostingdunyam.com.tr\/web-hosting.php\">Hosting<\/a> sa\u011flay\u0131c\u0131n\u0131z\u0131n vermi\u015f oldu\u011fu bilgiler ile cpanel panelinize ( aray\u00fcz ) giri\u015f yap\u0131yoruz. Kar\u015f\u0131n\u0131za Veritabanlar\u0131 adl\u0131 bir ayr\u0131lm\u0131\u015f alan \u00e7\u0131kacakt\u0131r. Ayr\u0131lm\u0131\u015f alandan \u201cMySQL\u00ae Veritabanlar\u0131\u201d adl\u0131 k\u0131s\u0131ma giriyoruz.<\/p>\n<p>Alt k\u0131s\u0131mda g\u00f6r\u00fcnen ve veritabanlar\u0131n\u0131z\u0131n listelenmi\u015f oldu\u011fu k\u0131s\u0131ma geliyoruz. Burdan silmek istedi\u011fimiz veritaban\u0131n\u0131n yan\u0131nda bulunan \u201cSil\u201d k\u0131sm\u0131na basarak veritaban\u0131z\u0131 kal\u0131c\u0131 silme sayfas\u0131na y\u00f6nlendiriliyoruz.<br \/>\n\u201cVeritabanlar\u0131n\u0131 Sil\u201d k\u0131sm\u0131na basarak se\u00e7mi\u015f oldu\u011fumuz veritaban\u0131n\u0131 kal\u0131c\u0131 olarak Cpanelden siliyoruz.<\/p>\n<h2>Phpmyadmin Veritaban\u0131 Silme \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n<p>PhpMyAdmin \u00fczerinden bir veritaban\u0131n\u0131 silmek olduk\u00e7a kolayd\u0131r ancak i\u015flem geri al\u0131namayaca\u011f\u0131 i\u00e7in dikkatli olunmal\u0131d\u0131r. \u00d6ncelikle <strong data-start=\"177\" data-end=\"241\">cPanel, Plesk veya do\u011frudan phpMyAdmin aray\u00fcz\u00fcne giri\u015f yap\u0131n<\/strong> ve sol taraftaki men\u00fcden silmek istedi\u011finiz veritaban\u0131n\u0131 se\u00e7in. Ard\u0131ndan, \u00fcst men\u00fcde bulunan <strong data-start=\"335\" data-end=\"372\">&#8220;\u0130\u015flemler&#8221; (Operations) sekmesine<\/strong> t\u0131klay\u0131n ve sayfan\u0131n alt k\u0131sm\u0131ndaki <strong data-start=\"409\" data-end=\"454\">&#8220;Veritaban\u0131n\u0131 Kald\u0131r (Drop the database)&#8221;<\/strong> butonuna basarak i\u015flemi onaylay\u0131n. Bu ad\u0131mlar\u0131 tamamlad\u0131ktan sonra veritaban\u0131 kal\u0131c\u0131 olarak silinecektir. Verilerinizi kaybetmemek i\u00e7in i\u015flem \u00f6ncesinde <strong data-start=\"607\" data-end=\"633\">yedek alman\u0131z \u00f6nerilir<\/strong>. phpMyAdmin \u00fczerinden veritaban\u0131 silme i\u015flemi, gereksiz dosyalar\u0131 temizleyerek <strong data-start=\"713\" data-end=\"756\">web sitenizin performans\u0131n\u0131 art\u0131rabilir<\/strong> ve gereksiz kaynak t\u00fcketimini \u00f6nleyebilir.<\/p>\n<h2 data-start=\"0\" data-end=\"50\"><strong data-start=\"0\" data-end=\"48\">MySQL Veritaban\u0131 Silme \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?<\/strong><\/h2>\n<p data-start=\"52\" data-end=\"492\">MySQL veritaban\u0131 silme i\u015flemi, gereksiz verileri temizlemek veya kullan\u0131lmayan veritabanlar\u0131n\u0131 kald\u0131rmak i\u00e7in yap\u0131lan kritik bir i\u015flemdir. Bu i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in <strong data-start=\"222\" data-end=\"297\">phpMyAdmin, MySQL komut sat\u0131r\u0131 (CLI) veya cPanel gibi y\u00f6netim panelleri<\/strong> kullan\u0131labilir. MySQL komut sat\u0131r\u0131ndan veritaban\u0131n\u0131 silmek i\u00e7in <strong data-start=\"362\" data-end=\"412\">\u00f6ncelikle MySQL sunucusuna ba\u011flanman\u0131z gerekir<\/strong>. Bunun i\u00e7in terminal veya SSH \u00fczerinden a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rabilirsiniz:<\/p>\n<p><code><span class=\"hljs-keyword\">DROP<\/span> DATABASE veritabani_adi;<\/code><\/p>\n<p>Bu komut, belirtilen veritaban\u0131n\u0131 kal\u0131c\u0131 olarak siler ve geri al\u0131namaz bir i\u015flemdir. <strong data-start=\"621\" data-end=\"683\">Silme i\u015fleminden \u00f6nce verilerinizi yedeklemeniz \u00f6nemlidir.<\/strong> E\u011fer phpMyAdmin kullan\u0131yorsan\u0131z, sol men\u00fcden silmek istedi\u011finiz veritaban\u0131n\u0131 se\u00e7ip <strong data-start=\"767\" data-end=\"837\">&#8220;\u0130\u015flemler&#8221; sekmesinden &#8220;Veritaban\u0131n\u0131 Kald\u0131r&#8221; se\u00e7ene\u011fini t\u0131klayarak<\/strong> i\u015flemi tamamlayabilirsiniz. Do\u011fru bir veritaban\u0131 y\u00f6netimi, <strong data-start=\"897\" data-end=\"968\">sunucu performans\u0131n\u0131z\u0131 art\u0131r\u0131r ve gereksiz kaynak kullan\u0131m\u0131n\u0131 \u00f6nler<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veritaban\u0131n\u0131 Silmek Veritabanlar\u0131 sitelerin verilerinin tutuldu\u011fu yerdir. Bir\u00e7ok kez veritabanlar\u0131na \u00e7okca ihtiya\u00e7 duyulur. Hemen hemen her sitede bir veritaban\u0131 vard\u0131r. \u0130lk \u00f6nce Hosting sa\u011flay\u0131c\u0131n\u0131z\u0131n vermi\u015f oldu\u011fu bilgiler ile cpanel panelinize ( aray\u00fcz ) giri\u015f yap\u0131yoruz. Kar\u015f\u0131n\u0131za Veritabanlar\u0131 adl\u0131 bir ayr\u0131lm\u0131\u015f alan \u00e7\u0131kacakt\u0131r. Ayr\u0131lm\u0131\u015f alandan \u201cMySQL\u00ae Veritabanlar\u0131\u201d adl\u0131 k\u0131s\u0131ma giriyoruz. Alt k\u0131s\u0131mda g\u00f6r\u00fcnen ve veritabanlar\u0131n\u0131z\u0131n listelenmi\u015f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5141,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5140","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel"],"_links":{"self":[{"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/posts\/5140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=5140"}],"version-history":[{"count":4,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/posts\/5140\/revisions"}],"predecessor-version":[{"id":5340,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/posts\/5140\/revisions\/5340"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/media\/5141"}],"wp:attachment":[{"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=5140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=5140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostingdunyam.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=5140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}