{"id":6067,"date":"2019-05-08T18:10:30","date_gmt":"2019-05-08T09:10:30","guid":{"rendered":"https:\/\/auctionpro.co.kr\/?p=6067"},"modified":"2019-06-14T10:04:56","modified_gmt":"2019-06-14T01:04:56","slug":"mysql-data-import-error-1067-42000-at-line-431","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=6067","title":{"rendered":"[mysql] Data Import ERROR 1067 (42000) at line 431"},"content":{"rendered":"<pre class=\"lang:vim decode:true  \">17:40:33 Restoring C:\\Users\\Administrator\\Downloads\\backup_2019-04-24-1154_C_test__8e4fc2ead977-db\\Csharpdb\r\nRunning: mysql.exe --defaults-file=\"c:\\users\\admini~1\\appdata\\local\\temp\\tmpdtqlgo.cnf\"  --protocol=tcp --host= user=dsfd --port= --default-character-set=utf8 --comments --database=ctset  &lt; \"C:\\\\Users\\\\Administrator\\\\Downloads\\\\backup_2019-04-24-1154_C_test__8e4fc2ead977-db\\\\testpdb\"\r\nERROR 1067 (42000) at line 431: Invalid default value for 'user_registered'\r\n\r\nOperation failed with exitcode 1\r\n17:40:35 Import of C:\\Users\\Administrator\\Downloads\\backup_2019-04-24-1154_C_test__8e4fc2ead977-db\\Csharpdb has finished with 1 errors<\/pre>\n<p>solution:<br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6068 size-full\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal.png\" alt=\"\" width=\"1240\" height=\"575\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal.png 1240w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal-300x139.png 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal-768x356.png 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal-1024x475.png 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal-150x70.png 150w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal-400x185.png 400w\" sizes=\"auto, (max-width: 1240px) 100vw, 1240px\" \/><\/a><\/p>\n<pre class=\"lang:vim decode:true \">use dbtest;\r\nSET GLOBAL sql_mode = '';<\/pre>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>17:40:33 Restoring C:\\Users\\Administrator\\Downloads\\backup_2019-04-24-1154_C_test__8e4fc2ead977-db\\Csharpdb Running: mysql.exe &#8211;defaults-file=&#8221;c:\\users\\admini~1\\appdata\\local\\temp\\tmpdtqlgo.cnf&#8221; &#8211;protocol=tcp &#8211;host= user=dsfd &#8211;port= &#8211;default-character-set=utf8 &#8211;comments &#8211;database=ctset &lt; &#8220;C:\\\\Users\\\\Administrator\\\\Downloads\\\\backup_2019-04-24-1154_C_test__8e4fc2ead977-db\\\\testpdb&#8221; ERROR 1067 (42000) at line 431: Invalid default value for <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=6067\" title=\"[mysql] Data Import ERROR 1067 (42000) at line 431\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":6068,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[88],"tags":[],"class_list":["post-6067","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_featured_media_url":"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2019\/05\/MysqlWorkbench_SET_Grobal.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6067"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6067\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/media\/6068"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}