ERROR 1064 (42000) at line 15172: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '6) ON UPDATE CURRENT_TIMESTAMP(6), `user_host` mediumtext NOT NULL, `thread_' at..

ERROR 1064 (42000) at line 15172: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_' at line 2

 

단순하게 해결하려면 sql 파일을 열어서 

ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_' at line 2

 

 

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE IF NOT EXISTS `slow_log` (

  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),

  `user_host` mediumtext NOT NULL,

  `query_time` time(6) NOT NULL,

  `lock_time` time(6) NOT NULL,

  `rows_sent` int(11) NOT NULL,

  `rows_examined` int(11) NOT NULL,

  `db` varchar(512) NOT NULL,

  `last_insert_id` int(11) NOT NULL,

  `insert_id` int(11) NOT NULL,

  `server_id` int(10) unsigned NOT NULL,

  `sql_text` mediumtext NOT NULL

) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

/*!40101 SET character_set_client = @saved_cs_client */;

 

  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),

  `user_host` mediumtext NOT NULL,

이 두줄을 찾아서 싹~ 지워준다