{"id":2344,"date":"2019-07-25T01:54:40","date_gmt":"2019-07-24T22:54:40","guid":{"rendered":"http:\/\/blog.okanacar.com.tr\/?p=2344"},"modified":"2024-09-13T00:00:39","modified_gmt":"2024-09-12T21:00:39","slug":"mysql-fulltext-indexes-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/okanacar.com.tr\/blog\/?p=2344","title":{"rendered":"MySql FULLTEXT indexes Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p><strong>Workbench\u00a0<\/strong>yada benzeri bir ara\u00e7la veritaban\u0131n\u0131 ubuntu 14.04 sunucu i\u00e7erisine import ederken kar\u015f\u0131la\u015ft\u0131\u011f\u0131m bir hata \u015f\u00f6yle g\u00f6r\u00fcn\u00fcyordu:<\/p>\n<pre class=\"lang:mysql decode:true \">ERROR 1214 (HY000) at line 207: The used table type doesn't support FULLTEXT indexes<\/pre>\n<p>Veritaban\u0131 tablo t\u00fcr\u00fcyle alakal\u0131 olan bu hatan\u0131n \u00e7\u00f6z\u00fcm\u00fcne gelecek olursak;<\/p>\n<p>1) \u0130lgili\u00a0<strong>sql\u00a0<\/strong>dosyas\u0131n\u0131 a\u00e7\u0131n (<em>E\u011fer boyutu b\u00fcy\u00fckse\u00a0<strong>SQLite<\/strong>,\u00a0<strong>EmEdit\u00f6r\u00a0<\/strong>vb. programlar kullan\u0131n b\u00fcy\u00fck de\u011filse notepad++, sublimetext kullanabilirsiniz.<\/em>)<br \/>\n2)\u00a0<strong>ENGINE=InnoDB<\/strong>\u00a0de\u011ferini bulun ve\u00a0<strong>ENGINE=MyISAM<\/strong>\u00a0\u015feklinde de\u011fi\u015ftirin<br \/>\n3) CTRL+S yap\u0131p kaydedi.<br \/>\n4) Tekrar import etmeyi deyebilirsiniz.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Workbench\u00a0yada benzeri bir ara\u00e7la veritaban\u0131n\u0131 ubuntu 14.04 sunucu i\u00e7erisine import ederken kar\u015f\u0131la\u015ft\u0131\u011f\u0131m bir hata \u015f\u00f6yle g\u00f6r\u00fcn\u00fcyordu: ERROR 1214 (HY000) at line 207: The used table type doesn&#8217;t support FULLTEXT indexes Veritaban\u0131 tablo t\u00fcr\u00fcyle alakal\u0131 olan bu hatan\u0131n \u00e7\u00f6z\u00fcm\u00fcne gelecek olursak; 1) \u0130lgili\u00a0sql\u00a0dosyas\u0131n\u0131 a\u00e7\u0131n (E\u011fer boyutu b\u00fcy\u00fckse\u00a0SQLite,\u00a0EmEdit\u00f6r\u00a0vb. programlar kullan\u0131n b\u00fcy\u00fck de\u011filse notepad++, sublimetext kullanabilirsiniz.) 2)\u00a0ENGINE=InnoDB\u00a0de\u011ferini bulun &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2345,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[140],"tags":[141,143,142],"_links":{"self":[{"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2344"}],"collection":[{"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2344"}],"version-history":[{"count":1,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2344\/revisions"}],"predecessor-version":[{"id":2346,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2344\/revisions\/2346"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=\/wp\/v2\/media\/2345"}],"wp:attachment":[{"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/okanacar.com.tr\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}