{"id":2350,"date":"2026-08-31T10:57:28","date_gmt":"2026-08-31T07:57:28","guid":{"rendered":"https:\/\/verimin.com.tr\/blog\/?p=2350"},"modified":"2026-08-31T10:57:28","modified_gmt":"2026-08-31T07:57:28","slug":"veri-tabani-nedir","status":"publish","type":"post","link":"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/","title":{"rendered":"Veri Taban\u0131 Nedir? Web Sitesinde Ne \u0130\u015fe Yarar ve Nas\u0131l \u00c7al\u0131\u015f\u0131r?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Veri taban\u0131, bilgiyi d\u00fczenli ve tekrar eri\u015filebilir bi\u00e7imde saklayan sistemdir. Bir web sitesinin yaz\u0131lar\u0131, kullan\u0131c\u0131lar\u0131, yorumlar\u0131 ve \u00fcr\u00fcnleri dosyalarda de\u011fil, sitenin bar\u0131nd\u0131r\u0131ld\u0131\u011f\u0131 sunucuda \u00e7al\u0131\u015fan bir veri taban\u0131nda durur. Ziyaret\u00e7i bir sayfay\u0131 a\u00e7t\u0131\u011f\u0131nda g\u00f6rd\u00fc\u011f\u00fc metin, o anda veri taban\u0131ndan \u00e7ekilip sayfaya yerle\u015ftirilmi\u015ftir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu yap\u0131n\u0131n do\u011frudan bir sonucu vard\u0131r: bir sitenin yede\u011fi tek par\u00e7a de\u011fildir. Dosya yede\u011fi ve veri taban\u0131 yede\u011fi ayr\u0131 ayr\u0131 al\u0131n\u0131r, \u00e7\u00fcnk\u00fc dosyalar diskte duran nesnelerdir, veri taban\u0131 ise \u00e7al\u0131\u015fan bir servistir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131da veri taban\u0131n\u0131n tablo yap\u0131s\u0131n\u0131, ili\u015fkisel ve NoSQL ayr\u0131m\u0131n\u0131, SQL ile aras\u0131ndaki fark\u0131, sitenin veri taban\u0131na nas\u0131l ba\u011fland\u0131\u011f\u0131n\u0131, panelden nas\u0131l y\u00f6netildi\u011fini ve yede\u011finin neden ayr\u0131 al\u0131nd\u0131\u011f\u0131n\u0131 s\u0131rayla a\u00e7\u0131kl\u0131yoruz.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_73 ez-toc-wrap-left counter-flat ez-toc-counter ez-toc-white ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<div class=\"ez-toc-title\" style=\"cursor:inherit\">\u0130\u00e7erik Ba\u015fl\u0131klar\u0131:<\/div>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_nedir_ve_ne_ise_yarar\" title=\"Veri taban\u0131 nedir ve ne i\u015fe yarar?\">Veri taban\u0131 nedir ve ne i\u015fe yarar?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_nasil_yapilandirilir_tablo_satir_ve_sutun\" title=\"Veri taban\u0131 nas\u0131l yap\u0131land\u0131r\u0131l\u0131r: tablo, sat\u0131r ve s\u00fctun\">Veri taban\u0131 nas\u0131l yap\u0131land\u0131r\u0131l\u0131r: tablo, sat\u0131r ve s\u00fctun<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Iliskisel_veri_tabani_ile_NoSQL_arasindaki_fark_nedir\" title=\"\u0130li\u015fkisel veri taban\u0131 ile NoSQL aras\u0131ndaki fark nedir?\">\u0130li\u015fkisel veri taban\u0131 ile NoSQL aras\u0131ndaki fark nedir?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_ile_SQL_arasindaki_fark_nedir\" title=\"Veri taban\u0131 ile SQL aras\u0131ndaki fark nedir?\">Veri taban\u0131 ile SQL aras\u0131ndaki fark nedir?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Web_sitesi_veri_tabanini_nasil_kullanir\" title=\"Web sitesi veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?\">Web sitesi veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Barindirmada_hangi_veri_tabani_calisir\" title=\"Bar\u0131nd\u0131rmada hangi veri taban\u0131 \u00e7al\u0131\u015f\u0131r?\">Bar\u0131nd\u0131rmada hangi veri taban\u0131 \u00e7al\u0131\u015f\u0131r?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#WordPress_veri_tabanini_nasil_kullanir\" title=\"WordPress veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?\">WordPress veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_nasil_yonetilir\" title=\"Veri taban\u0131 nas\u0131l y\u00f6netilir?\">Veri taban\u0131 nas\u0131l y\u00f6netilir?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_yedegi_neden_ayri_alinir\" title=\"Veri taban\u0131 yede\u011fi neden ayr\u0131 al\u0131n\u0131r?\">Veri taban\u0131 yede\u011fi neden ayr\u0131 al\u0131n\u0131r?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_hakkinda_sik_sorulan_sorular\" title=\"Veri taban\u0131 hakk\u0131nda s\u0131k sorulan sorular\">Veri taban\u0131 hakk\u0131nda s\u0131k sorulan sorular<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Her_web_sitesi_veri_tabani_kullanir_mi\" title=\"Her web sitesi veri taban\u0131 kullan\u0131r m\u0131?\">Her web sitesi veri taban\u0131 kullan\u0131r m\u0131?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Hosting_paketimde_kac_veri_tabani_acabilirim\" title=\"Hosting paketimde ka\u00e7 veri taban\u0131 a\u00e7abilirim?\">Hosting paketimde ka\u00e7 veri taban\u0131 a\u00e7abilirim?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_silinirse_site_geri_gelir_mi\" title=\"Veri taban\u0131 silinirse site geri gelir mi?\">Veri taban\u0131 silinirse site geri gelir mi?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/verimin.com.tr\/blog\/veri-tabani-nedir\/#Veri_tabani_sitemi_yavaslatir_mi\" title=\"Veri taban\u0131 sitemi yava\u015flat\u0131r m\u0131?\">Veri taban\u0131 sitemi yava\u015flat\u0131r m\u0131?<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_nedir_ve_ne_ise_yarar\"><\/span>Veri taban\u0131 nedir ve ne i\u015fe yarar?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Veri taban\u0131, bilgiyi d\u00fczenli ve tekrar eri\u015filebilir bi\u00e7imde saklayan sistemdir. Web ba\u011flam\u0131nda kar\u015f\u0131l\u0131\u011f\u0131 nettir: sitenizin i\u00e7eri\u011fi metin dosyalar\u0131nda de\u011fil, sunucuda \u00e7al\u0131\u015fan bir veri taban\u0131nda tutulur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Burada bir ayr\u0131m gerekir. G\u00fcnl\u00fck konu\u015fmada &#8220;veri taban\u0131&#8221; denince akla verinin kendisi gelir; oysa veri taban\u0131, verinin sakland\u0131\u011f\u0131 ve sorguland\u0131\u011f\u0131 sistemdir. Bu sistemi y\u00f6neten yaz\u0131l\u0131ma <strong>veri taban\u0131 y\u00f6netim sistemi (VTYS)<\/strong> denir ve bar\u0131nd\u0131rmada kar\u015f\u0131n\u0131za \u00e7\u0131kan MySQL, MariaDB ya da MSSQL gibi adlar bu yaz\u0131l\u0131mlar\u0131n ad\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Veri taban\u0131n\u0131n dosyaya g\u00f6re \u00fcst\u00fcnl\u00fc\u011f\u00fc, veriyi aramaya ve ili\u015fkilendirmeye uygun tutmas\u0131d\u0131r. On bin \u00fcr\u00fcn\u00fc metin dosyas\u0131nda saklarsan\u0131z, bir \u00fcr\u00fcn\u00fc bulmak i\u00e7in dosyan\u0131n tamam\u0131n\u0131 okuman\u0131z gerekir. Veri taban\u0131 ayn\u0131 i\u015fi indeksler \u00fczerinden saniyenin \u00e7ok alt\u0131nda yapar. Bu fark\u0131n nas\u0131l m\u00fcmk\u00fcn oldu\u011funu anlamak i\u00e7in veri taban\u0131n\u0131n nas\u0131l yap\u0131land\u0131\u011f\u0131na bakmak gerekir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ayn\u0131 sistem e\u015fzamanl\u0131 eri\u015fimi de y\u00f6netir. Bir sitede ayn\u0131 anda y\u00fcz ziyaret\u00e7i sayfa a\u00e7\u0131yorsa, veri taban\u0131 bu isteklerin hepsini s\u0131raya al\u0131r ve birbirini bozmadan cevaplar. Dosyaya yazan iki i\u015flemin birbirinin \u00fczerine yazmas\u0131 gibi bir sorun burada ya\u015fanmaz; kay\u0131t b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc koruyan mekanizma sistemin kendisindedir.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1672\" height=\"941\" src=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi.avif\" alt=\"Veri taban\u0131ndaki tablo, sat\u0131r ve s\u00fctun yap\u0131s\u0131\" class=\"wp-image-2296\" srcset=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi.avif 1672w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-300x169.avif 300w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-1024x576.avif 1024w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-768x432.avif 768w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-1536x864.avif 1536w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-195x110.avif 195w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-390x220.avif 390w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-tablo-yapisi-1170x658.avif 1170w\" sizes=\"auto, (max-width: 1672px) 100vw, 1672px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_nasil_yapilandirilir_tablo_satir_ve_sutun\"><\/span>Veri taban\u0131 nas\u0131l yap\u0131land\u0131r\u0131l\u0131r: tablo, sat\u0131r ve s\u00fctun<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130li\u015fkisel bir veri taban\u0131 \u00fc\u00e7 temel yap\u0131dan olu\u015fur:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Tablo.<\/strong> Ayn\u0131 t\u00fcrden kay\u0131tlar\u0131n tutuldu\u011fu yap\u0131d\u0131r. Bir blogda <code>yazilar<\/code> tablosu b\u00fct\u00fcn yaz\u0131lar\u0131, <code>kullanicilar<\/code> tablosu b\u00fct\u00fcn kullan\u0131c\u0131lar\u0131 tutar.<\/li><li><strong>Sat\u0131r.<\/strong> Tablodaki tek bir kay\u0131tt\u0131r. <code>yazilar<\/code> tablosundaki her sat\u0131r bir yaz\u0131d\u0131r.<\/li><li><strong>S\u00fctun.<\/strong> Kayd\u0131n tek bir \u00f6zelli\u011fidir. <code>yazilar<\/code> tablosunda ba\u015fl\u0131k, i\u00e7erik, yay\u0131n tarihi ve yazar birer s\u00fctundur.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Tablolar birbirine ba\u011flanabilir. <code>yazilar<\/code> tablosundaki yazar s\u00fctunu, <code>kullanicilar<\/code> tablosundaki bir sat\u0131r\u0131 i\u015faret eder; b\u00f6ylece yazar\u0131n ad\u0131 y\u00fcz yaz\u0131da y\u00fcz kez tekrarlanmaz, tek yerde durur ve gerekti\u011finde oradan \u00e7ekilir. \u0130li\u015fkisel veri taban\u0131na ad\u0131n\u0131 veren \u015fey tam olarak bu ba\u011flant\u0131d\u0131r. Ba\u011flant\u0131y\u0131 ta\u015f\u0131yan s\u00fctunlara anahtar denir ve bu yap\u0131 sayesinde bir yazar\u0131n ad\u0131 de\u011fi\u015fti\u011finde y\u00fcz yaz\u0131n\u0131n tamam\u0131 otomatik olarak g\u00fcncellenmi\u015f olur; \u00e7\u00fcnk\u00fc ad tek bir yerde durmaktad\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Iliskisel_veri_tabani_ile_NoSQL_arasindaki_fark_nedir\"><\/span>\u0130li\u015fkisel veri taban\u0131 ile NoSQL aras\u0131ndaki fark nedir?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0130li\u015fkisel veri taban\u0131nda<\/strong> veri, \u00f6nceden tan\u0131ml\u0131 tablolarda durur. Hangi s\u00fctunun ne t\u00fcr veri alaca\u011f\u0131 ba\u015ftan belirlenir ve bu yap\u0131ya uymayan kay\u0131t kabul edilmez. Bu kat\u0131l\u0131k bir k\u0131s\u0131t gibi g\u00f6r\u00fcnse de veri tutarl\u0131l\u0131\u011f\u0131n\u0131 garanti eder.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>NoSQL<\/strong> yakla\u015f\u0131m\u0131nda \u015fema esnektir. Veri, tablo yerine belge ya da anahtar-de\u011fer \u00e7iftleri olarak saklan\u0131r; her kay\u0131t farkl\u0131 alanlara sahip olabilir. \u00c7ok b\u00fcy\u00fck \u00f6l\u00e7ekli ve yap\u0131s\u0131 s\u00fcrekli de\u011fi\u015fen verilerde tercih edilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bar\u0131nd\u0131rma taraf\u0131nda bu ayr\u0131m\u0131n pratik kar\u015f\u0131l\u0131\u011f\u0131 basittir: payla\u015f\u0131ml\u0131 hosting paketlerinde standart olarak ili\u015fkisel veri taban\u0131 sunulur. \u0130\u00e7erik y\u00f6netim sistemleri, e-ticaret yaz\u0131l\u0131mlar\u0131 ve forum yaz\u0131l\u0131mlar\u0131n\u0131n hepsi ili\u015fkisel yap\u0131ya g\u00f6re yaz\u0131lm\u0131\u015ft\u0131r; NoSQL ihtiyac\u0131 genellikle kendi sunucusunu y\u00f6neten projelerde ortaya \u00e7\u0131kar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_ile_SQL_arasindaki_fark_nedir\"><\/span>Veri taban\u0131 ile SQL aras\u0131ndaki fark nedir?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL bir veri taban\u0131 de\u011fil, ili\u015fkisel veri tabanlar\u0131yla konu\u015fmak i\u00e7in kullan\u0131lan dildir. A\u00e7\u0131l\u0131m\u0131 Structured Query Language&#8217;dir ve yapt\u0131\u011f\u0131 i\u015f, &#8220;\u015fu tablodan \u015fu ko\u015fula uyan kay\u0131tlar\u0131 getir&#8221; gibi istekleri sisteme anlatmakt\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kar\u0131\u015f\u0131kl\u0131\u011f\u0131n kayna\u011f\u0131 \u00fcr\u00fcn adlar\u0131d\u0131r: MySQL, MSSQL ve PostgreSQL adlar\u0131n\u0131n hepsinde SQL ge\u00e7er. Bunlar dilin ad\u0131 de\u011fil, o dili konu\u015fan sistemlerin ad\u0131d\u0131r. Bir sitenin kodu veri taban\u0131na ba\u011fland\u0131\u011f\u0131nda asl\u0131nda bu dili kullanarak konu\u015fur; siz bu konu\u015fmay\u0131 g\u00f6rmezsiniz, yaln\u0131zca sonucunu sayfada g\u00f6r\u00fcrs\u00fcn\u00fcz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1672\" height=\"941\" src=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi.avif\" alt=\"Ziyaret\u00e7i iste\u011finin site kodu ve veri taban\u0131 sorgusundan ge\u00e7ip sayfaya d\u00f6nmesi\" class=\"wp-image-2300\" srcset=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi.avif 1672w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-300x169.avif 300w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-1024x576.avif 1024w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-768x432.avif 768w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-1536x864.avif 1536w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-195x110.avif 195w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-390x220.avif 390w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/site-veri-tabani-baglantisi-1170x658.avif 1170w\" sizes=\"auto, (max-width: 1672px) 100vw, 1672px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Web_sitesi_veri_tabanini_nasil_kullanir\"><\/span>Web sitesi veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sayfan\u0131n a\u00e7\u0131lmas\u0131 d\u00f6rt ad\u0131ml\u0131 bir zincirle ger\u00e7ekle\u015fir:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Ziyaret\u00e7i sayfay\u0131 ister.<\/strong> Taray\u0131c\u0131 sunucuya istek g\u00f6nderir.<\/li><li><strong>Site kodu veri taban\u0131na ba\u011flan\u0131r.<\/strong> Ba\u011flant\u0131, sitenin yap\u0131land\u0131rma dosyas\u0131nda yaz\u0131l\u0131 bilgilerle kurulur.<\/li><li><strong>Sorgu \u00e7al\u0131\u015f\u0131r ve kay\u0131tlar d\u00f6ner.<\/strong> \u0130stenen yaz\u0131, \u00fcr\u00fcn ya da kullan\u0131c\u0131 bilgisi veri taban\u0131ndan okunur.<\/li><li><strong>Sayfa olu\u015fturulup g\u00f6nderilir.<\/strong> Kay\u0131tlar \u015fablona yerle\u015ftirilir ve tamamlanan sayfa taray\u0131c\u0131ya iletilir.<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130kinci ad\u0131mdaki ba\u011flant\u0131 i\u00e7in d\u00f6rt bilgi gerekir: sunucu ad\u0131, veri taban\u0131 ad\u0131, kullan\u0131c\u0131 ad\u0131 ve \u015fifre. Payla\u015f\u0131ml\u0131 bar\u0131nd\u0131rmada sunucu ad\u0131 genellikle <code>localhost<\/code> olur, \u00e7\u00fcnk\u00fc veri taban\u0131 sunucusu web sunucusuyla ayn\u0131 makinede \u00e7al\u0131\u015f\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu zincirin en \u00f6nemli sonucu ta\u015f\u0131malarda ortaya \u00e7\u0131kar: bir sitenin dosyalar\u0131n\u0131 yeni sunucuya kopyalamak tek ba\u015f\u0131na yetmez, veri taban\u0131 da ta\u015f\u0131nmal\u0131d\u0131r. Yaln\u0131zca dosyalar\u0131 ta\u015f\u0131yan bir ge\u00e7i\u015fte site a\u00e7\u0131l\u0131r ama i\u00e7erik gelmez; \u00e7\u00fcnk\u00fc tema ve kod yeni sunucudad\u0131r, yaz\u0131lar eski sunucudaki veri taban\u0131nda kalm\u0131\u015ft\u0131r. Ta\u015f\u0131man\u0131n do\u011fru s\u0131ras\u0131 i\u00e7in <a href=\"https:\/\/verimin.com.tr\/blog\/hosting-tasima\/\">Hosting Ta\u015f\u0131ma Nas\u0131l Yap\u0131l\u0131r? Kesintisiz Ge\u00e7i\u015f Rehberi<\/a> yaz\u0131s\u0131na bakabilirsiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Barindirmada_hangi_veri_tabani_calisir\"><\/span>Bar\u0131nd\u0131rmada hangi veri taban\u0131 \u00e7al\u0131\u015f\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Linux tabanl\u0131 bar\u0131nd\u0131rma paketlerinde standart, MySQL ve onunla uyumlu MariaDB&#8217;dir. \u0130kisi ayn\u0131 k\u00f6kten gelir ve pratikte ayn\u0131 komutlarla \u00e7al\u0131\u015f\u0131r; sa\u011flay\u0131c\u0131lar\u0131n \u00e7o\u011fu MariaDB kurar ama panelde MySQL ad\u0131yla g\u00f6r\u00fcn\u00fcr.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Windows taraf\u0131nda MSSQL kullan\u0131l\u0131r ve ASP.NET projelerinin standart veri taban\u0131d\u0131r. PostgreSQL baz\u0131 paketlerde ek olarak sunulur; ili\u015fkisel yap\u0131s\u0131 daha kat\u0131 ve geli\u015fmi\u015f sorgu yeteneklerine sahiptir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL&#8217;in bar\u0131nd\u0131rmada nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131, ba\u011flant\u0131 bilgilerinin nereden al\u0131nd\u0131\u011f\u0131 ve yede\u011finin nas\u0131l aktar\u0131ld\u0131\u011f\u0131 ayr\u0131 bir konudur; ayr\u0131nt\u0131s\u0131n\u0131 <a href=\"https:\/\/verimin.com.tr\/blog\/mysql-hosting\/\">MySQL Nedir? MySQL Hosting Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/a> yaz\u0131s\u0131nda bulabilirsiniz. Windows taraf\u0131ndaki gereksinimler i\u00e7in <a href=\"https:\/\/verimin.com.tr\/blog\/windows-hosting\/\">Windows Hosting Nedir? Hangi Teknolojiler \u0130\u00e7in Gereklidir?<\/a> yaz\u0131s\u0131na bakabilirsiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"WordPress_veri_tabanini_nasil_kullanir\"><\/span>WordPress veri taban\u0131n\u0131 nas\u0131l kullan\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">WordPress&#8217;te neyin nerede durdu\u011fu s\u0131k kar\u0131\u015ft\u0131r\u0131l\u0131r. Yaz\u0131lar, sayfalar, yorumlar, kullan\u0131c\u0131lar ve b\u00fct\u00fcn site ayarlar\u0131 veri taban\u0131ndad\u0131r. G\u00f6rseller, tema dosyalar\u0131, eklenti dosyalar\u0131 ve y\u00fckledi\u011finiz belgeler ise diskte, <code>wp-content<\/code> klas\u00f6r\u00fcn\u00fcn i\u00e7indedir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu ayr\u0131m yedeklemenin neden iki par\u00e7al\u0131 oldu\u011funu do\u011frudan a\u00e7\u0131klar: veri taban\u0131 yede\u011fi yaz\u0131lar\u0131n\u0131z\u0131 kurtar\u0131r ama g\u00f6rsellerinizi kurtarmaz, dosya yede\u011fi g\u00f6rsellerinizi kurtar\u0131r ama yaz\u0131lar\u0131n\u0131z\u0131 kurtarmaz. WordPress kurulumlar\u0131 veri taban\u0131ndaki tablolara bir \u00f6n ek verir; varsay\u0131lan \u00f6n ek <code>wp_<\/code> bi\u00e7imindedir ve ayn\u0131 veri taban\u0131nda birden fazla kurulum bar\u0131nd\u0131rmay\u0131 m\u00fcmk\u00fcn k\u0131lar. WordPress&#8217;in bar\u0131nd\u0131rma taraf\u0131ndaki gereksinimleri i\u00e7in <a href=\"https:\/\/verimin.com.tr\/blog\/wordpress-hosting-nedir\/\">WordPress Hosting Nedir? Web Hosting ile Fark\u0131 Nedir?<\/a> yaz\u0131s\u0131na bakabilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_nasil_yonetilir\"><\/span>Veri taban\u0131 nas\u0131l y\u00f6netilir?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Veri taban\u0131 \u00fc\u00e7 yerden y\u00f6netilir ve hangisini kullanaca\u011f\u0131n\u0131z yapmak istedi\u011finiz i\u015fe ba\u011fl\u0131d\u0131r:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Kontrol panelinin veri taban\u0131 b\u00f6l\u00fcm\u00fc.<\/strong> Yeni veri taban\u0131 olu\u015fturma, kullan\u0131c\u0131 a\u00e7ma ve yetkilendirme buradan yap\u0131l\u0131r. Yap\u0131sal i\u015flemlerin yeri buras\u0131d\u0131r.<\/li><li><strong>phpMyAdmin.<\/strong> Veri taban\u0131n\u0131n i\u00e7eri\u011fini g\u00f6r\u00fcnt\u00fclemek, d\u0131\u015fa aktarmak ve i\u00e7e aktarmak i\u00e7in kullan\u0131l\u0131r. Tablolar\u0131n i\u00e7ine bakmak istedi\u011finizde a\u00e7aca\u011f\u0131n\u0131z ara\u00e7 budur.<\/li><li><strong>Uygulaman\u0131n kendi aray\u00fcz\u00fc.<\/strong> G\u00fcnl\u00fck i\u015fler (yaz\u0131 ekleme, \u00fcr\u00fcn g\u00fcncelleme) uygulaman\u0131n y\u00f6netim panelinden yap\u0131l\u0131r ve arka planda zaten veri taban\u0131na yazar.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin \u00fczerinde yap\u0131lan de\u011fi\u015fikliklerin geri alma d\u00fc\u011fmesi yoktur. Bir tabloyu silmek ya da bir alan\u0131 toplu de\u011fi\u015ftirmek an\u0131nda ve kal\u0131c\u0131d\u0131r. Bu y\u00fczden her m\u00fcdahaleden \u00f6nce ilgili veri taban\u0131n\u0131n d\u0131\u015fa aktar\u0131m\u0131n\u0131 almak, iste\u011fe ba\u011fl\u0131 bir tedbir de\u011fil standart bir ad\u0131md\u0131r. Panelin bu b\u00f6l\u00fcmlerinin nerede oldu\u011funu <a href=\"https:\/\/verimin.com.tr\/blog\/cpanel-nedir\/\">cPanel Nedir? Ne \u0130\u015fe Yarar ve Hosting Hesab\u0131 Nas\u0131l Y\u00f6netilir?<\/a> yaz\u0131s\u0131nda bulabilirsiniz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1672\" height=\"941\" src=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi.avif\" alt=\"Dosya yede\u011fi ile veri taban\u0131 yede\u011finin kapsam ve al\u0131nma bi\u00e7imi fark\u0131\" class=\"wp-image-2304\" srcset=\"https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi.avif 1672w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-300x169.avif 300w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-1024x576.avif 1024w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-768x432.avif 768w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-1536x864.avif 1536w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-195x110.avif 195w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-390x220.avif 390w, https:\/\/verimin.com.tr\/blog\/wp-content\/uploads\/2026\/08\/veri-tabani-yedegi-1170x658.avif 1170w\" sizes=\"auto, (max-width: 1672px) 100vw, 1672px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_yedegi_neden_ayri_alinir\"><\/span>Veri taban\u0131 yede\u011fi neden ayr\u0131 al\u0131n\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sitenin yede\u011fi, dosya yede\u011fi ve veri taban\u0131 yede\u011fi olmak \u00fczere iki par\u00e7adan olu\u015fur. Bunun sebebi teknik ve nettir: dosyalar diskte duran nesnelerdir, kopyalanabilirler. Veri taban\u0131 ise \u00e7al\u0131\u015fan bir servistir; dosyalar\u0131 kopyalamak yeterli olmaz, \u00e7\u00fcnk\u00fc kopyalama an\u0131nda bellekte bekleyen ve hen\u00fcz diske yaz\u0131lmam\u0131\u015f i\u015flemler bulunabilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu y\u00fczden veri taban\u0131 kopyalanmaz, <strong>d\u0131\u015fa aktar\u0131l\u0131r<\/strong>. D\u0131\u015fa aktarma i\u015flemi, veri taban\u0131n\u0131n o anki tutarl\u0131 h\u00e2lini bir metin dosyas\u0131 olarak \u00fcretir; bu dosya geri y\u00fcklendi\u011finde veri taban\u0131 ayn\u0131 h\u00e2line d\u00f6ner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tek par\u00e7al\u0131 yede\u011fin neden i\u015fe yaramad\u0131\u011f\u0131 da buradan anla\u015f\u0131l\u0131r: yaln\u0131zca dosyalar\u0131 geri y\u00fcklerseniz site a\u00e7\u0131l\u0131r, tasar\u0131m gelir, ama i\u00e7erik bo\u015f \u00e7\u0131kar. Yaln\u0131zca veri taban\u0131n\u0131 geri y\u00fcklerseniz i\u00e7erik yerindedir ama g\u00f6rseller k\u0131r\u0131k g\u00f6r\u00fcn\u00fcr. Yedekleme s\u00fcrecinin iki par\u00e7as\u0131n\u0131 da kapsayan bir y\u00f6ntem i\u00e7in <a href=\"https:\/\/verimin.com.tr\/blog\/wordpress-yedekleme\/\">WordPress Yedekleme Nas\u0131l Yap\u0131l\u0131r? Dosya ve Veritaban\u0131 Rehberi<\/a> yaz\u0131s\u0131na, sunucu d\u00fczeyinde anl\u0131k kay\u0131t almak i\u00e7in <a href=\"https:\/\/verimin.com.tr\/blog\/snapshot-nedir\/\">Snapshot Nedir? Sunucu Anl\u0131k G\u00f6r\u00fcnt\u00fcs\u00fc Ne \u0130\u015fe Yarar?<\/a> yaz\u0131s\u0131na bakabilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_hakkinda_sik_sorulan_sorular\"><\/span>Veri taban\u0131 hakk\u0131nda s\u0131k sorulan sorular<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Her_web_sitesi_veri_tabani_kullanir_mi\"><\/span>Her web sitesi veri taban\u0131 kullan\u0131r m\u0131?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Hay\u0131r. Yaln\u0131zca HTML dosyalar\u0131ndan olu\u015fan statik siteler veri taban\u0131 kullanmaz; i\u00e7erik do\u011frudan dosyalar\u0131n i\u00e7inde durur. Bir i\u00e7erik y\u00f6netim sistemi kullanan, \u00fcyelik alan, form kaydeden ya da \u00fcr\u00fcn listeleyen her site veri taban\u0131na ihtiya\u00e7 duyar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Hosting_paketimde_kac_veri_tabani_acabilirim\"><\/span>Hosting paketimde ka\u00e7 veri taban\u0131 a\u00e7abilirim?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Bu say\u0131 pakete g\u00f6re de\u011fi\u015fir ve pratikte \u00f6nemli bir s\u0131n\u0131rd\u0131r: her uygulama kurulumu genellikle kendi veri taban\u0131n\u0131 ister. Yani veri taban\u0131 say\u0131s\u0131, ayn\u0131 hesapta ka\u00e7 ayr\u0131 uygulama \u00e7al\u0131\u015ft\u0131rabilece\u011finizi belirler. Paketinizin s\u0131n\u0131r\u0131n\u0131 panelde veya paket a\u00e7\u0131klamas\u0131nda g\u00f6rebilirsiniz; kar\u015f\u0131la\u015ft\u0131rma i\u00e7in <a href=\"https:\/\/verimin.com.tr\/web-hosting\">Limitsiz Web Hosting \u00c7\u00f6z\u00fcmleri<\/a> sayfas\u0131na bakabilirsiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_silinirse_site_geri_gelir_mi\"><\/span>Veri taban\u0131 silinirse site geri gelir mi?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Hay\u0131r. Dosyalar yerinde dursa bile i\u00e7erik veri taban\u0131ndad\u0131r; silinen veri taban\u0131n\u0131n geri gelmesinin tek yolu yedektir. Bu, veri taban\u0131 yede\u011finin neden ayr\u0131ca al\u0131nmas\u0131 gerekti\u011finin en somut cevab\u0131d\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Veri_tabani_sitemi_yavaslatir_mi\"><\/span>Veri taban\u0131 sitemi yava\u015flat\u0131r m\u0131?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Evet, yava\u015flatabilir; ama sebep veri taban\u0131n\u0131n kendisi de\u011fildir. Yava\u015fl\u0131\u011f\u0131n kayna\u011f\u0131 sayfa ba\u015f\u0131na \u00e7al\u0131\u015fan sorgu say\u0131s\u0131 ve pakete ayr\u0131lan i\u015flemci ile bellek pay\u0131d\u0131r. Eklenti say\u0131s\u0131 artt\u0131k\u00e7a her sayfa y\u00fcklemesinde \u00e7al\u0131\u015fan sorgu say\u0131s\u0131 artar ve ayn\u0131 kaynak daha \u00e7ok i\u015fe b\u00f6l\u00fcn\u00fcr.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu y\u00fczden do\u011fru soru &#8220;veri taban\u0131 m\u0131 yava\u015f&#8221; de\u011fil, &#8220;paketin i\u015flemci ve bellek pay\u0131 bu siteye yetiyor mu&#8221; olmal\u0131d\u0131r. Sorgu taraf\u0131nda yap\u0131labilecekleri <a href=\"https:\/\/verimin.com.tr\/blog\/veritabani-optimizasyon\/\">Veritaban\u0131 Performans\u0131 Nas\u0131l \u0130yile\u015ftirilir?<\/a> yaz\u0131s\u0131nda anlatt\u0131k; kaynak taraf\u0131nda s\u0131n\u0131ra dayan\u0131yorsan\u0131z <a href=\"https:\/\/verimin.com.tr\/sanal-sunucu\">Sanal Sunucu Kiralama (NVMe VDS Sunucu)<\/a> sayfas\u0131ndaki paketleri inceleyebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veri taban\u0131, bilgiyi d\u00fczenli ve tekrar eri\u015filebilir bi\u00e7imde saklayan sistemdir. Bir web sitesinin yaz\u0131lar\u0131, kullan\u0131c\u0131lar\u0131,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2292,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2350","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel"],"_links":{"self":[{"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/posts\/2350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=2350"}],"version-history":[{"count":1,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/posts\/2350\/revisions"}],"predecessor-version":[{"id":2360,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/posts\/2350\/revisions\/2360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/media\/2292"}],"wp:attachment":[{"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=2350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=2350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/verimin.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=2350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}