problem on importing sql into phpmyadmin - Hercules bug tracker archive

Issue information

Issue ID

#7409

Status

Invalid

Severity

None

Started

bgamez23

Jun 21, 2013 21:26

Last Post

Haru

May 1, 2016 13:29

Confirmation

Yes (1)

No (0)

bgamez23 - Jun 21, 2013 21:26

mob_skill_db.sql[code=auto:0] Error SQL query: # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','chase',90,5,4000,0,0,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','chase',90,5,10000,0,0,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','attack',90,5,4000,0,0,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','chase',91,5,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','chase',91,5,10000,0,5000,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','attack',91,5,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_ski[...] 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 'REPLACE INTO `mob_skill_db` VALUES (1399,'Event Baphomet@AL_TELEPORT','idle',26,' at line 86 [/code]

mob_skill_db_re.sql[code=auto:0] Error SQL query: # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','chase',90,5,4000,0,0,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','chase',90,5,10000,0,0,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_EARTHSPIKE','attack',90,5,4000,0,0,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'0',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','chase',91,5,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','chase',91,5,10000,0,5000,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_skill_db` VALUES (1395,'Wind Crystal@WZ_HEAVENDRIVE','attack',91,5,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'21',NULL); # REPLACE INTO `mob_ski[...] 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 'REPLACE INTO `mob_skill_db` VALUES (1399,'Event Baphomet@AL_TELEPORT','idle',26,' at line 86 [/code]

bgamez23 - Jun 24, 2013 5:59

bump

bgamez23 - Jun 27, 2013 21:26

bump

Ind - Jun 27, 2013 23:32

Some files are too big for phpmyadmin, you have to import them manually

bgamez23 - Jun 28, 2013 14:10

[quote name="Ind" timestamp="1372375931"]
Some files are too big for phpmyadmin, you have to import them manually[/quote]

hmmm so i need to use navicat instead of phpmyadmin right? but the files size of the sql is almost 1.17mb. the maximum upload for mine is (Max: 2,048KiB)

Ind - Jul 1, 2013 19:25

[quote name="bgamez23" timestamp="1372428627"]

[quote name="Ind" timestamp="1372375931"]
Some files are too big for phpmyadmin, you have to import them manually[/quote]hmmm so i need to use navicat instead of phpmyadmin right? but the files size of the sql is almost 1.17mb. the maximum upload for mine is (Max: 2,048KiB)

[/quote]Command line should work too

Samuel - Jul 24, 2013 0:39

It seems to be there is a problem with those lines above
[quote]
REPLACE INTO `mob_skill_db` VALUES (1399,'Event Baphomet@AL_TELEPORT','idle',26,1,2000,0,0,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,'20',NULL);[/quote]

with [b]#[/b] sign

I have deleted those lines and retry and it worked