0

My MYSQL database is in .sql file format, I am trying to import it into MySQL using HeidiSQL. But, as I starting importation from the Load SQL file, the importation process is halted by this error message

SQL Error (1064): You have an error in your SQL syntax; check the manual that correspondes to your MySQL server version for the right syntax to use near ‘curdate()) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC’ at line 17

See the snapshot:

enter image description here enter image description here

Akina
  • 39,301
  • 5
  • 14
  • 25
Musekwa
  • 1
  • 2

1 Answers1

0

I had faced same issue : I fixed it by removing DEFUALT CHARSET=utf8mb4 from my .sql file

TomCat
  • 83
  • 7
  • 1
    Shown issue CANNOT be fixed by this way. You have had some another error message (I think it was "unknown charset/collation" due to old MySQL version). – Akina Sep 15 '21 at 08:26