item_db.sql importing problem

[superman1001]

i have a problem importing sql script into mysql, i get the pre-compiled r16113 from sourceforge...

when i try to import item_db.sql mysql swhows this error:

# REPLACE INTO `item_db` VALUES (5693,'No_Fear_Underware','No Fear Underwear',5,0,NULL,0,NULL,10,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,0,30,'bonus bStr,1; bonus bInt,1; bonus bDex,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5694,'No_Fear_P_Headgear','No Fear P Headgear',5,0,NULL,0,NULL,1,NULL,1,0xFFFFFFFE,7,2,256,NULL,20,0,614,'bonus bVit,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5695,'E_Blue_Drooping_Kitty','E Blue Drooping Kitty',5,250000,NULL,500,NULL,1,NULL,0,0,7,2,256,NULL,0,1,277,'bonus bMdef,15;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5696,'E_Flying_Angel','E Flying Angel',5,20,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,10,1,264,'bonus bInt,1; bonus bAgi,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5697,'E_Smoking_Pipe_','E Smoking Pipe',5,20,NULL,100,NULL,0,NULL,0,0,7,2,1,NULL,0,0,55,'bonus bVit,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5698,'E_Pair_OE_Red_Ribbon_','E Pair OE Red Ribbon',5,20,NULL,100,NULL,1,NULL,0,0,7,2,512,NULL,45,0,169,NUL[...]
MySQL said:
#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 `item_db` VALUES (5741,'Im_Egg_Shell_Hat','Eternal Egg Shell',5,20,' at line 49

what's wrong?

[Asura]

Hi superman1001,

How are you importing the item_db? I've found that using phpMyAdmin fails, it's better to use alternative methods.

[superman1001]

Hi Asura, thx for your reply.

i used mysql workbench but it crash down every time i execute the script, so i try with phpmyadmin that shows that error

[Asura]

Hi superman1001,

What kind of server is your MySQL hosted on? Is it Windows or Linux?

[java]

hahaha same like my problem dude.. it's because mysql version ..

so i made changes

search at itemdb.sql

# REPLACE INTO `item_db` VALUES (542,'Festive_Cookie','Festival Cookie',0,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(325,405),0;',NULL,NULL);

remove #

REPLACE INTO `item_db` VALUES (542,'Festive_Cookie','Festival Cookie',0,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(325,405),0;',NULL,NULL);

repeat this, and try to import ur itemdb.sql again have fun

[Bahmut]

no don't do this. Just search and replace # with --

[java]

no don't do this. Just search and replace # with --

why?

[superman1001]

i solved it!

i removed all empty and commented lines, then split every 1500 lines

it works both phpmyadmin and mysql workbench

thx for all

Edited May 18, 2012 by superman1001

[java]

i solved it!

i removed all empty and commented lines, then split every 1500 lines

it works both phpmyadmin and mysql workbench

thx for all

great to hear ur problem is solved