I HIGHLY advise correcting your .sql file with the below fixes and resourcing the sql.
FYI, when I sourced I got he following output:
Code:
C:\mysql\bin>mysql -f eq<MW_057DR2_alpha_1.sql
ERROR 1061 at line 18254: Duplicate key name 'slotid'
ERROR at line 21993: Unknown command '\\'.
ERROR 1064 at line 21993: 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 'The dead must rest\\"","1","0","0","-1
","0","0","255","0","3276
ERROR 1061 at line 169041: Duplicate key name 'account'
C:\mysql\bin>mysql -f eq<MW_057DR2_alpha_1.sql
To fix these errors, you have to change the following lines:
Delete (in inventory table):
Code:
20484: KEY slotid (slotid),
20485: KEY slotid (charid)
and replace with:
Code:
UNIQUE KEY slotid (slotid,charid)
Delete (in items table):
Code:
24217: INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \\"The dead must rest\\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");
and replace with:
Code:
INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \"The dead must rest\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");
Delete (in sharedbank table):
Code:
171271: UNIQUE account (acctid),
171272: UNIQUE account (slotid)
and replace with:
Code:
UNIQUE KEY account (acctid,slotid)
Not sure if these errors were causing the inventory stuff before, but no more errors when sourcing 
|