I’m migrating a site to a new server and in the process of uploading the database to MyPHP I am receiving the following message:

ERROR 1064 (42000) at line 1: 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 ‘▼’ at line 1

The desired outcome is to upload my database to the new site… Below is my approach:

mysql –binary-mode=1 -u root testnew < C:xampp1htdocsTHM_1FILESTOUPLOADDataDB.gz

Reading forums and guides I see that ‘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 ‘▼’ at line 1′ can refer to an issue with the file itself or it can be SQL syntax.

It would be great to understand if the community have experienced this issue.