Page 1 of 1

mysql import

PostPosted: 02. May 2012 00:28
by Rondawg
Hey all, i recently bought a linux vps for a game server, Ive been running the server on a windows OS for a while though, So im a linux noob but the problem is when i try to import the .sql i exported from xampp on the windows server i get an error about the Syntax being wrong.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql root mta < ./mta.sql' at line 1

Any help with this would be much apreciated, thanks.

Re: mysql import

PostPosted: 02. May 2012 05:19
by Altrea
Hi Rondawg,

Rondawg wrote:Any help with this would be much apreciated, thanks.

How should we help you without knowing the .sql file?
All we can say is, that MySQL don't like the file. That is not an Linux only Issue, this could happen on Windows too.
Take a look at the chars before mysql root mta.

best wishes,
Altrea