{"id":11059,"date":"2025-08-19T09:41:28","date_gmt":"2025-08-19T06:41:28","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=11059"},"modified":"2025-08-19T10:27:52","modified_gmt":"2025-08-19T07:27:52","slug":"mysql-1293-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-1293-hatasi-cozumu\/","title":{"rendered":"MySQL 1293 Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>PhpMyAdmin \u00fczerinden bir SQL dosyas\u0131n\u0131 yeni bir hosting ortam\u0131na ta\u015f\u0131rken SQL s\u00fcr\u00fcm\u00fcn\u00fcn uyumsuzlu\u011fundan dolay\u0131 kar\u015f\u0131m\u0131za \u00e7\u0131kan bu hatay\u0131 \u00e7\u00f6z\u00fcmlemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n<h2 style=\"text-align: center;\">\u00d6rnek Hata \u00c7\u0131kt\u0131s\u0131<\/h2>\n<p><code>#<span class=\"hljs-number\">1046<\/span> <span class=\"hljs-operator\">-<\/span> <span class=\"hljs-keyword\">No<\/span> database selected<br \/>\n#<span class=\"hljs-number\">1293<\/span> <span class=\"hljs-operator\">-<\/span> Incorrect <span class=\"hljs-keyword\">table<\/span> definitions; there can be <span class=\"hljs-keyword\">only<\/span> <span class=\"hljs-keyword\">one<\/span> <span class=\"hljs-type\">TIMESTAMP<\/span> <span class=\"hljs-keyword\">column<\/span> <span class=\"hljs-keyword\">with<\/span> <span class=\"hljs-built_in\">CURRENT_TIMESTAMP<\/span> <span class=\"hljs-keyword\">in<\/span> <span class=\"hljs-keyword\">default<\/span><\/code><\/p>\n<h2 style=\"text-align: center;\">Hata \u00c7\u00f6z\u00fcm\u00fc<\/h2>\n<p>MySQL CURRENT_TIMESTAMP hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc i\u00e7in sunucunuza SSH ba\u011flant\u0131s\u0131 yap\u0131n ve MySQL s\u00fcr\u00fcm\u00fcn\u00fc y\u00fckseltin.<\/p>\n<h3>DirectAdmin MySQL S\u00fcr\u00fcm\u00fc Y\u00fckseltme<\/h3>\n<p><code>cd \/usr\/local\/directadmin\/custombuild<br \/>\n.\/build set mysql 10.3  # veya mevcut en g\u00fcncel s\u00fcr\u00fcm\u00fc belirtin<br \/>\n.\/build set mysql_inst mysql<br \/>\n.\/build set mysql_backup yes<br \/>\n.\/build update<br \/>\n.\/build mysql<\/code><\/p>\n<h3>cPanel MySQL S\u00fcr\u00fcm\u00fc G\u00fcncelleme<\/h3>\n<p>#MySQL yede\u011fini al<br \/>\n<code>mysqldump --all-databases &gt; all_databases_backup.sql<\/code><\/p>\n<p>#Mevcut MySQL s\u00fcr\u00fcm\u00fcn\u00fc kontrol et<br \/>\n<code>mysql -V<\/code><\/p>\n<p>#G\u00fcncel MySQL s\u00fcr\u00fcm\u00fcn\u00fc y\u00fckle<br \/>\n<code>yum install mysql-server #CentOS i\u00e7in<br \/>\napt-get install mysql-server #Ubuntu i\u00e7in<\/code><\/p>\n<p>#MySQL&#8217;i ba\u015flat<br \/>\n<code>systemctl start mysqld<\/code><\/p>\n<p>Bu \u015fekilde MySQL s\u00fcr\u00fcm\u00fcn\u00fcz\u00fc g\u00fcncelledikten sonra hata \u00e7\u00f6z\u00fcmlenecektir.\u00a0 Daha fazla i\u00e7erik i\u00e7in blog sayfam\u0131z\u0131 takip etmeyi unutmay\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PhpMyAdmin \u00fczerinden bir SQL dosyas\u0131n\u0131 yeni bir hosting ortam\u0131na ta\u015f\u0131rken SQL s\u00fcr\u00fcm\u00fcn\u00fcn uyumsuzlu\u011fundan dolay\u0131 kar\u015f\u0131m\u0131za \u00e7\u0131kan bu hatay\u0131 \u00e7\u00f6z\u00fcmlemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz. \u00d6rnek Hata \u00c7\u0131kt\u0131s\u0131 #1046 &#8211; No database selected #1293 &#8211; Incorrect&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":11073,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-11059","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=11059"}],"version-history":[{"count":18,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11059\/revisions"}],"predecessor-version":[{"id":11078,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11059\/revisions\/11078"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/11073"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=11059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=11059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=11059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}