{"id":26600,"date":"2019-01-04T10:00:39","date_gmt":"2019-01-04T07:00:39","guid":{"rendered":"https:\/\/blog.natro.com\/?p=26600"},"modified":"2019-01-03T14:07:41","modified_gmt":"2019-01-03T11:07:41","slug":"wordpress-veritabani-baglanti-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.natro.com\/blog\/wordpress-veritabani-baglanti-hatasi-cozumu\/","title":{"rendered":"WordPress Veritaban\u0131 Ba\u011flant\u0131 Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>MySQL ve PHP dilleri kullan\u0131larak yaz\u0131lm\u0131\u015f olan WordPress\u2019te web sitesi her ziyaret edildi\u011finde sayfa o an olu\u015fturulmaktad\u0131r. Bilgi i\u00e7eren koleksiyonlar olarak da s\u00f6ylenebilen veritabanlar\u0131 arka plan \u00f6\u011feleri olsa da olduk\u00e7a \u00f6nemli olmaktad\u0131r. Platformun \u00e7al\u0131\u015fabilmesi i\u00e7in veritaban\u0131 \u015fartt\u0131r. Kullan\u0131c\u0131 verileri, sitedeki yorumlar, yaz\u0131lar, sitedeki s\u0131n\u0131fland\u0131rmalar gibi bir\u00e7ok \u015fey veritaban\u0131na kaydedilir. Ancak kullan\u0131c\u0131lar\u0131n bir k\u0131sm\u0131 WordPress veritaban\u0131 ba\u011flant\u0131 hatas\u0131 ile kar\u015f\u0131la\u015fmaktad\u0131r. Buna neden olan birden fazla durum ve \u00e7\u00f6zebilecek de birden fazla \u00e7\u00f6z\u00fcm olmaktad\u0131r.<\/p>\n<h4 id=\"veritabani-baglanti-hatasi-neden-gerceklesir\"><strong>Veritaban\u0131 Ba\u011flant\u0131 Hatas\u0131 Neden Ger\u00e7ekle\u015fir?<\/strong><\/h4>\n<p>WordPress ba\u011flant\u0131 hatalar\u0131 insanlar\u0131n kar\u015f\u0131la\u015ft\u0131\u011f\u0131 \u00f6nemli sorunlardan bir tanesidir. Bu duruma neden olan en yayg\u0131n sebepler \u015fu \u015fekildedir;<\/p>\n<ul>\n<li>Bozuk bir veritaban\u0131n\u0131n olmas\u0131 veritaban\u0131nda ba\u011flant\u0131 hatalar\u0131 olu\u015fturabilmektedir. A\u00e7\u0131lmak istenen dosya yerine \u00e7ok farkl\u0131 \u015fekilde garip semboller ya da yaz\u0131lar g\u00f6r\u00fclebilir. WordPress istenilen veriyi okuyamad\u0131\u011f\u0131 takdirde bu uyar\u0131 ile kar\u015f\u0131la\u015fmak m\u00fcmk\u00fcnd\u00fcr.<\/li>\n<li>Sunucunun kapal\u0131 olmas\u0131ndan kaynakl\u0131 olarak sunucu ile veritaban\u0131 ba\u011flant\u0131 kuramayabilir. Bu \u015fekildeki sorunlarda ba\u011flant\u0131 hatas\u0131 uyar\u0131s\u0131 ile kar\u015f\u0131la\u015f\u0131labilir.<\/li>\n<li>Hatal\u0131 olarak giri\u015f yap\u0131ld\u0131\u011f\u0131 takdirde bu uyar\u0131 ile kar\u015f\u0131la\u015fmak m\u00fcmk\u00fcnd\u00fcr. Veritaban\u0131 tam eri\u015fim olarak \u00e7al\u0131\u015ft\u0131\u011f\u0131 i\u00e7in, giri\u015f yap\u0131l\u0131rken olu\u015fan yanl\u0131\u015fl\u0131klar veritaban\u0131na eri\u015fim durumunu engeller.<\/li>\n<\/ul>\n<h4 id=\"veritabani-baglanti-hatasi-nasil-giderilir\"><strong>Veritaban\u0131 Ba\u011flant\u0131 Hatas\u0131 Nas\u0131l Giderilir?<\/strong><\/h4>\n<p>WordPress veritaban\u0131 tamir \u00f6zelli\u011fi kullan\u0131larak hata gidermek m\u00fcmk\u00fcnd\u00fcr. \u00d6nceden olu\u015fturulmu\u015f olan bir yede\u011fe ula\u015f\u0131lamad\u0131\u011f\u0131 takdirde WordPress bozuk dosyalar\u0131 onarabilme ad\u0131na Veritaban\u0131 Tamir \u00d6zelli\u011fi olu\u015fturmu\u015ftur. Bu \u00f6zellik etkinle\u015ftirildikten sonra FTP istemcisi a\u00e7\u0131l\u0131r ve siteye giri\u015f yap\u0131l\u0131r. Daha sonra sa\u011f tarafta bulunan WordPress root klas\u00f6r\u00fc a\u00e7\u0131l\u0131r. Burada bulunan wp-config.php dosyas\u0131na sa\u011f t\u0131klanarak d\u00fczenle se\u00e7ene\u011fine bas\u0131l\u0131r. Burada bulunan that\u2019s all, stop editing! Happy blogging sat\u0131r\u0131 yerine define( \u2018WP_ALLOW_REPAIR\u2019, true ); yaz\u0131l\u0131r ve kaydedilir. Daha sonra kendi sitesine gidilerek Veritaban\u0131n\u0131 Tamir Et se\u00e7ene\u011fi t\u0131klan\u0131r.<\/p>\n<p>E\u011fer ki kullan\u0131c\u0131 ad\u0131 ve \u015fifre hatal\u0131 ise WordPress bir ba\u011flant\u0131 ger\u00e7ekle\u015ftiremez. Kontrol paneli a\u00e7\u0131l\u0131r ve veritaban\u0131 y\u00f6netimi ekran\u0131 ile kar\u015f\u0131la\u015f\u0131l\u0131r. Manage butonuna bas\u0131l\u0131r ve \u015fifre de\u011fi\u015ftir se\u00e7en\u011fi bulunarak yeni bir \u015fifre belirlenir. WordPress root klas\u00f6r\u00fc a\u00e7\u0131l\u0131r, wp-config.php dosyas\u0131na sa\u011f t\u0131klanarak g\u00f6r\u00fcnt\u00fcle\/d\u00fczenle se\u00e7ene\u011fine t\u0131klanarak define DB name sat\u0131r\u0131nda veritaban\u0131 isminin do\u011fru olup olmad\u0131\u011f\u0131na bak\u0131l\u0131r.<\/p>\n<p>T\u00fcm bu ad\u0131mlar neticesinde sorun giderilmez ise en yak\u0131n zamanda al\u0131nan yedeklemeden yeniden y\u00fckleme ger\u00e7ekle\u015ftirilmelidir.<\/p>\n","protected":false},"excerpt":{"rendered":"MySQL ve PHP dilleri kullan\u0131larak yaz\u0131lm\u0131\u015f olan WordPress\u2019te web sitesi her ziyaret edildi\u011finde sayfa o an olu\u015fturulmaktad\u0131r. Bilgi&hellip;\n","protected":false},"author":7,"featured_media":26601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[179,30],"class_list":{"0":"post-26600","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"tag-veritabani","9":"tag-wordpress"},"_links":{"self":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/26600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/comments?post=26600"}],"version-history":[{"count":0,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/26600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media\/26601"}],"wp:attachment":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media?parent=26600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/categories?post=26600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/tags?post=26600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}