Error while executing main.sql

[Kami675]

Hello everyone! I am attempting to setup an offline sever(fairly new to this so I apologize) and I am receiving errors while attempting to execute the main.sql in workbench. I attempted to delete said portion causing the error but then another error arises and a lot of warnings. I'm not quite sure what to do and turn to you guys for assistance! The photos below are 1.) photo of when i try to execute without erasing anything 2.) when I erase the clan portion of the main.sql. I'm not entirely sure how to fix this. I am following the rathena wiki installation instructions and it gave me this error and I also tried this other tutorial which also gives me the same errors. Does anyone have any insight on how to solve these errors? I appreciate any and all help!

 

[Takuyakii]

make sure to double click your schema

[Kami675]

7 hours ago, Takuyakii said:

make sure to double click your schema

i did double click it, still gives me the same error(s)

[Emistry]

you executed the mains.sql more than one time, or you didnt clear the existing data before you execute the script.

[evilnezt]

i get the same error.  error with main.sql. the others works fine. and error only with latest rathena. need solution 

[sfj209jfo-p]

the duplicate entry error is obviously because you already ran the script once, it cant override stuff, SQL wont work like that...

 

simply drop the database rathena, create a new database with the same name and import again i guess...