SQL import error

[gatsu]

Hi!

I am getting this error when I am trying to import the .sql to my database. What is wrong?
The webhost support told me that there is something in the code that dont work and that its the "DROP TRIGGER IF EXISTS `oncreate_players` ;" part.

How can this be fixed?


SQL-fråga:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL sa: Dokumentation
#1227 - Access denied; you need the SUPER privilege for this operation

 

[Hazher]

man if u have the database of TFS 0.2.5 and the phpmyadmin 2.11 don't have problem.
The new database:
http://rapidshare.com/files/59987908/forgottenserver.sql.html

Tutorial how change ur phpmyadmin to the last version:
http://otland.net/showthread.php?t=1522

bye

 

[gatsu]

thank you, the problem was that my webshost didnt have 2.11 =)

 

[noea]

Hey, I have phpMyAdmin 2.11.+ I followed the tutorial on updating phpymyadmin, and I have read lots of tutorials and I still have this problem:

Error

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;

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 'IF EXISTS `oncreate_players`' at line 1

I also tried importing via cmd and it didn't work.

Any help is really appreciated, thanks

 

[noea]

bump . . . .

 

[noea]

so.. anyone got an idea? I thought people were focused on TFS on this forum...