accent .sql error

[Beret]

Well everytime I convert my db item_db and mob _ and put with UTF-8 error when you import the tables someone tell me what's wrong ...

One of the mistakes and give this:

# 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 ' REPLACE INTO ' mob_db ' VALUES (' W_BRADIUM_GOLEM ', 2049, Golem ' Bradium ', ' Golem ' at line 28

[Asura]

Hi Beret,

How are you importing the SQL file? Are you copying and pasting into phpMyAdmin and running the query; cause this is not a good way to import big .sql files such as mob_db and item_db.

I would suggest using some sort of MySQL Query program; or if you have a Linux-based service, to use the 'mysql' command to import the file.

[Beret]

I managed to add the item_db and mob_db with accents thanks Asura by tips.

Can close.