Wsrtjtyk

Im trying to import my sql file backup to my new server, but i receive error:

Error 1067: Invalid default value for created_at

this is my SQL file header:

-- phpMyAdmin SQL Dump

-- version 4.8.3

-- https://www.phpmyadmin.net/

--

-- Host: localhost:3306

-- Generation Time: Nov 07, 2018 at 07:43 AM

-- Server version: 5.7.24

-- PHP Version: 7.2.7



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

START TRANSACTION;

SET time_zone = "+00:00";





/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;



--

-- Database: `.....

Error:

i added sql_mode line inside the conf file at:
/etc/mysql/my.cnf

restart mysql and apache2, but still not resolved

any idea please?

Colums with the CURRENT_TIMESTAMP attribute must have the data type TIMESTAMP, not DATETIME, in MySQL versions prior to 5.6.

So you need

`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP

or a later version of MySQL.