[ONE] mysql syntax error

[wormrunner]

I am using the precompiled mangos one server. I am running debian sid 64bit.

# mysql --version

mysql Ver 14.14 Distrib 5.5.39, for debian-linux-gnu (x86_64) using readline 6.3

https://www.getmangos.eu/mangos/file-554-mangos-server-0-18-0-rev2057-x32-september-2014-a-mangosone_2057_x32_sept2014-zip&v=39589924528516.63

I am setting up the databases using phpmyadmin and got an error importing mangos_full_db.sql. I got past needing to change limits in my php.ini file and seemingly successfully did the import, but I am getting the following error:

----

MySQL said: Documentation

#1064 - 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_CO' at line 21

----

Of course I would like to get some direction on how to fix this, or know how important it is. I am not well versed in sql databases, though I can learn. I am wondering if I should just be using a different version of mysql? I can set up a completely independent machine on which to do it if I need.

[antz]

Are you using a very old version of MySQL ?

[madmax]

Closing due to no reply.

[madmax]

[MENTION=4448]wormrunner[/MENTION] i reopened your thread as requested

[wormrunner]

Are you using a very old version of MySQL ?

As noted above, it is MySQL 5.5 which is not the latest, but is the standard version for Debian SID (the unstable "bleeding edge" version of Debian).

[bels]

If you open the file on your linux box does it have ^M at the end of the lines? That's one thing I would look at. Can you post the entirety of line 21 from the file you are trying to import? Can you not just use?

mysql -u root -p manogs < world.sql