Help Acis Spanwlist Sql File Error

[Red-Hair-Shanks]

hi guys i have a probleam with the spawnlist sql file...i can import it into the database....i have acis pack...can anybody help me;

Edited December 13, 2013 by ourat1995

[Versus]

Post the error maybe?

[Red-Hair-Shanks]

[Err] 2013 - Lost connection to MySQL server during query

[Err] INSERT INTO `spawnlist` VALUES

('20088','-30646','180732','-5242','38594','27','0'),

('20087','-31531','180805','-5291','0','27','0'),

('20088','-31430','180983','-5291','0','27','0'),

('20087','-31228','180983','-5291','0','27','0'),

('20086','-28112','179770','-5361','0','60','0'),

('20087','-28314','180126','-5361','0','27','0'),

('20088','-27506','180054','-5312','15570','27','0'),

('20089','-28011','179948','-5361','0','70','0'),

('20087','-27709','180126','-5361','0','27','0'),

('20088','-27762','180771','-5312','20081','27','0'),

('20089','-27306','180482','-5361','0','70','0'),

('20086','-26617','180762','-5451','0','60','0'),

('20087','-26516','180940','-5451','0','27','0'),

('20088','-26416','180762','-5451','0','27','0'),

('20089','-26315','180940','-5451','0','70','0'),

('20086','-26215','180762','-5451','0','60','0'),

('20087','-26315','180584','-5451','0','27','0'),

('20088','-26114','180940','-5451','0','27','0'),

('20089','-26014','180762','-5451','0','70','0'),

('20086','-26114','180584','-5451','0','60','0'),

('20087','-26415','181118','-5451','0','27','0'),

('20088','-26617','181118','-5451','0','27','0'),

('20089','-25913','180940','-5451','0','70','0'),

('20086','-26214','181118','-5451','0','60','0'),

('20086','-27536','182269','-5451','0','60','0'),

('20088','-27435','182447','-5451','0','27','0'),

('20088','-27335','182269','-5451','0','27','0'),

('20086','-27637','182447','-5451','0','60','0'),

('20087','-27334','182625','-5451','0','27','0'),

('20089','-27234','182447','-5451','0','70','0'),

('20090','-27536','182625','-5451','0','70','0'),

('20086','-27233','182803','-5451','0','60','0'),

('20089','-27133','182625','-5451','0','70','0'),

('20090','-27435','182803','-5451','0','70','0'),

('20086','-27032','182803','-5451','0','60','0'),

('20089','-27033','182447','-5451','0','70','0'),

('20090','-27133','182269','-5451','0','70','0'),

('20086','-26931','182625','-5451','0','60','0'),

('20087','-27892','181577','-5312','55831','27','0'),

('20088','-28468','182298','-5365','0','27','0'),

('20090','-28002','182128','-5312','56643','70','0'),

('20087','-28669','181942','-5365','0','27','0'),

('20088','-28065','181586','-5365','0','27','0'),

('20089','-28670','182298','-5365','0','70','0'),

('20087','-28367','182120','-5365','0','27','0'),

('20088','-28468','182654','-5365','0','27','0'),

('20089','-28569','182120','-5365','0','70','0'),

('20087','-28065','182298','-5365','0','27','0'),

('20088','-28568','181764','-5365','0','27','0'),

('20089','-28064','181942','-5365','0','70','0'),

('20087','-27964','181764','-5365','0','27','0'),

('20088','-27763','181764','-5365','0','27','0'),

('20089','-27762','182120','-5365','0','70','0'),

('20087','-28288','182217','-5312','60277','27','0'),

('20088','-28569','182476','-5365','0','27','0'),

('20089','-28468','181942','-5365','0','70','0'),

('20087','-28770','182120','-5365','0','27','0'),

('20088','-27863','181942','-5365','0','27','0'),

('20089','-28367','182476','-5365','0','70','0'),

('20087','-27662','182298','-5365','0','27','0'),

('20088','-27764','182397','-5312','65245','27','0'),

('20089','-28165','181764','-5365','0','70','0'),

('20087','-29341','181251','-5282','28700','27','0'),

('20088','-28230','182410','-5312','57659','27','0'),

('20089','-28950','181331','-5312','20275','70','0'),

('20087','-28286','182101','-5312','40316','27','0'),

('20088','-28602','181464','-5312','7498','27','0'),

('20089','-29363','181213','-5309','34567','70','0'),

('20089','-29158','182839','-5365','0','70','0'),

('20090','-29057','183017','-5365','0','70','0'),

('20089','-28957','182839','-5365','0','70','0'),

('20090','-29259','183017','-5365','0','70','0'),

('20089','-28956','183195','-5365','0','70','0'),

('20090','-28856','183017','-5365','0','70','0'),

('20089','-29158','183195','-5365','0','70','0'),

('20090','-28855','183373','-5365','0','70','0'),

('20089','-28755','183195','-5365','0','70','0'),

('20090','-29057','183373','-5365','0','70','0'),

('20086','-24041','181507','-

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[Red-Hair-Shanks]

and the sql file start ...

DROP TABLE IF EXISTS `spawnlist`;

 

CREATE TABLE `spawnlist` (

  `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',

  `locx` mediumint(6) NOT NULL DEFAULT '0',

  `locy` mediumint(6) NOT NULL DEFAULT '0',

  `locz` mediumint(6) NOT NULL DEFAULT '0',

  `heading` mediumint(6) NOT NULL DEFAULT '0',

  `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',

  `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'

);

 

INSERT INTO `spawnlist` VALUES

('32043','94108','-105820','-3313','8191','60','0'),

('32007','140968','-123600','-1904','18000','60','0'),

('35601','141152','-124272','-1864','10000','60','0'),

('35602','140704','-124020','-1904','34000','60','0'),

('35602','140732','-123796','-1904','2000','60','0'),

('35603','152924','-126604','-2304','33000','60','0'),

('35604','143944','-119196','-2136','1000','60','0'),

('35604','143944','-119196','-2136','1000','60','0'),

('35605','140824','-124844','-1864','10000','60','0'),

('35638','56736','-26400','568','49000','60','0'),

('35639','58128','-32000','301','0','60','0'),

('35640','58024','-25744','592','49000','60','0'),

('35641','58080','-29552','568','49000','60','0'),

('35641','58137','-29223','568','16500','60','0'),

('35642','58024','-26456','592','49000','60','0'),

('31034','-40307','34037','-3595','0','60','0'),

('31034','-38317','45945','-3595','0','60','0'),

[SweeTs]

I faced such problem executing large files, like you now. The only way I could 'skip' it was by using the db installer :P

Edited December 10, 2013 by SweeTs

[Red-Hair-Shanks]

  On 12/10/2013 at 4:40 PM, SweeTs said:

I faced such problem executing large files, like you now. The only way I could 'skip' it was by using the db installer :P

my db installer dosent work..wrong path write..and i can't fixed....:P

[xdem]

use sql command line, F6

[Red-Hair-Shanks]

spawnlist does not have a primary key.

Updated to this table will be done using the following pseudo statement:

update spawnlist set modifiedFieldsAndValues Where AllFieldsAndOldValues LIMIT 1  

 

 

everytime i open the spawnlist it show me this!