{"id":137,"date":"2018-05-22T16:31:17","date_gmt":"2018-05-22T13:31:17","guid":{"rendered":"https:\/\/buraksuatgorgun.com.tr\/?p=137"},"modified":"2018-05-22T16:31:17","modified_gmt":"2018-05-22T13:31:17","slug":"unknown-collation-utf8mb4_unicode_520_ci-hatasinin-cozumu","status":"publish","type":"post","link":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/2018\/05\/22\/unknown-collation-utf8mb4_unicode_520_ci-hatasinin-cozumu\/","title":{"rendered":"Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217; Hatas\u0131n\u0131n \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<h3><a href=\"#Alt-Baslik\">Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217; Hatas\u0131n\u0131n \u00c7\u00f6z\u00fcm\u00fc<\/a><\/h3>\n<p>Merhabalar,<\/p>\n<p>Farkl\u0131 bir sunucudan yedekleri\u011finiz MySQL veritaban\u0131n\u0131, sunucunuza y\u00fckler iken;<\/p>\n<p>Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217;<\/p>\n<p>Hatas\u0131n\u0131 al\u0131yor iseniz s\u00fcr\u00fcm ve collation farklar\u0131ndan \u00f6t\u00fcr\u00fc ya\u015fand\u0131\u011f\u0131 ve \u00e7\u00f6z\u00fcm\u00fcn\u00fcn basit oldu\u011funu bilmelisiniz.<\/p>\n<p>\u00c7\u00f6z\u00fcm i\u00e7in, Veritaban\u0131n\u0131 .sql olarak yedekleyin.<\/p>\n<p>Notepad ++ gibi \u00e7o\u011ful olarak bul &#8211; de\u011fi\u015ftir i\u015flemi ger\u00e7ekle\u015ftiren bir program ile veritaban\u0131n\u0131z\u0131 a\u00e7\u0131n.<\/p>\n<p>utf8mb4_unicode_ci de\u011ferlerini utf8_general_ci olarak de\u011fi\u015ftirin.<\/p>\n<p>utf8mb4_unicode_520_ci de\u011ferlerini utf8_general_ci olarak de\u011fi\u015ftirin.<\/p>\n<p>utf8mb4 de\u011ferlerini utf8 olarak de\u011fi\u015ftirin.<\/p>\n<p>\u0130\u015flem bu kadard\u0131r.<\/p>\n<p>\u0130yi \u00e7al\u0131\u015fmalar dilerim.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217; Hatas\u0131n\u0131n \u00c7\u00f6z\u00fcm\u00fc Merhabalar, Farkl\u0131 bir sunucudan yedekleri\u011finiz MySQL veritaban\u0131n\u0131, sunucunuza y\u00fckler iken; Unknown collation: &#8216;utf8mb4_unicode_520_ci&#8217; Hatas\u0131n\u0131 al\u0131yor iseniz s\u00fcr\u00fcm ve collation farklar\u0131ndan \u00f6t\u00fcr\u00fc ya\u015fand\u0131\u011f\u0131 ve \u00e7\u00f6z\u00fcm\u00fcn\u00fcn basit oldu\u011funu bilmelisiniz. \u00c7\u00f6z\u00fcm i\u00e7in, Veritaban\u0131n\u0131 .sql olarak yedekleyin. Notepad ++ gibi \u00e7o\u011ful olarak bul &#8211; de\u011fi\u015ftir i\u015flemi ger\u00e7ekle\u015ftiren bir program ile veritaban\u0131n\u0131z\u0131 a\u00e7\u0131n. utf8mb4_unicode_ci de\u011ferlerini [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[26,27,43,58,71,86,88,91],"class_list":["post-137","post","type-post","status-publish","format-standard","hentry","category-linux","tag-collation","tag-cozumu","tag-hatasi","tag-mysql","tag-restore","tag-unknown","tag-utf8mb4_unicode_520_ci","tag-ve"],"_links":{"self":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":0,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}