****Dbeaver7. Error in importing SQL file error executing process failed (exit code = 1). See error log. Process failed (exit code = 1). See error log

It may be because the import file contains the datetime type and the default table is 0. In the mysql configuration file (my.ini), check whether it contains sql_mode=ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, if not, add it at the end of the document Can.

Read More:

• [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
• [Solved] Job for mysqld.service failed because the control process exited with error code
• [Solved] mariadb Startup Error: Job for mariadb.service failed because the control process exited with error code.
• [Solved] MySQL Startup Error: Job for mysqld.service failed because the control process exited with error code
• [Solved] Canal Error: Could not find first log file name in binary log index file
• RECEIVED ERROR PACKET: ERRNO = 1236, SQLSTATE = HY000 ERRMSG = COULD NOT FIND FIRST LOG FILE NAME IN BINARY LOG INDEX FILE
• Dbeaver connects hive to solve the problem that hive custom UDF functions cannot be used in SQL queries in dbeaver
• Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
• [Solved] Rabbitmq Startup Error: Job for rabbitmq-server.service failed because the control process exited with
• MYSQL gruop by Error: this is incompatible with sql_mode=only_full_group_by
• [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
• MYSQL8 Startup Error: mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘
• [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
• [Solved] MYSQL 5.7 gruop by eRROR: this is incompatible with sql_mode=only_full_group_by
• MySQL 8.0.12 runs SQL error #1055 [How to Solve]
• [Solved] MySQL Error: ERROR 1055 (42000)sql_mode=only_full_group_by
• [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
• [Solved] MySQL5.6.44 [Err] 1067 – Invalid default value for create_date settlement programme
• [Solved] ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
• [Solved] ERROR: child process failed, exited with error number 14 (error number 1, error number 100)