[Help]sql files failed to install

[hidde]

hey guys, i'm using l2j server interlude project, when i'm installing DB, it gives me an error, some sql files can't install

example

first error armor.sql

i'm noob in l2java and please dont beat me :D

 

p.s i'm using win 7 ultimate 64 bit SP1

[Zaldron]

press "C" and when u finish the installation add the armor.sql to navicat alone.

[hidde]

there is also other errors with other sql files, maybe 10 or more error

armor.sql

-- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('50','Leather Gloves','gloves','false','none','650','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('51','Bracer','gloves','false','none','650','leather','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('52','Hemp Cloak','underwear','false','none','260','cloth','none','0','-1','2','0','0','37','0','true','true','true','true','0','0'),
('53','Cotton Cloak','underwear','false','none','250','cloth','none','0','-1','3','0','0','607','0','true','true','true','true','0','0'),
('54','Silk Cloak','underwear','false','none','250','cloth','none','0','-1','4','0','0','2650','0','true','true','true','true','0','0'),
('55','Cotton Undergarment','underwear','false','none','170','cotton','none','0','-1','4','0','0','18','0','true','true','true','true','0','0'),
('56','Wool Undergarment','underwear','false','none','170','wood','none','0','-1','5','0','0','304','0','true','true','true','true','0','0'),
('58','Mithril Breastplate','chest','true','heavy','8670','mithril','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('59','Mithril Gaiters','legs','true','heavy','3830','mithril','d','0','-1','61','0','0','127000','230','true','true','true','true','0','0'),
('60','Composite Armor','fullarmor','true','heavy','10980','fine_steel','c','0','-1','224','0','0','1440000','576','true','true','true','true','0','0'),
('61','Mithril Gloves','gloves','true','none','630','mithril','d','0','-1','29','0','0','97800','177','true','true','true','true','0','0'),
('62','Mithril Boots','feet','true','none','1230','leather','c','0','-1','32','0','0','126000','50','true','true','true','true','0','0'),
('63','Gauntlets','gloves','true','none','640','cloth','d','0','-1','24','0','0','50800','92','true','true','true','true','0','0'),
('64','Composite Boots','feet','true','none','1220','fine_steel','c','0','-1','36','0','0','245000','98','true','true','true','true','0','0'),
('112','Apprentice\'s Earring','rear,lear','false','none','150','silver','none','0','-1','0','11','0','49','0','true','true','true','true','0','0'),
('113','Mystic\'s Earring','rear,lear','false','none','150','silver','none','0','-1','0','13','0','811','0','true','true','true','true','0','0'),
('114','Earring of Strength','rear,lear','false','none','150','gold','none','0','-1','0','16','0','3510','0','true','true','true','true','0','0'),
('115','Earring of Wisdom','rear,lear','false','none','150','gold','none','0','-1','0','16','0','3510','0','true','true','true','true','0','0'),
('116','Magic Ring','rfinger,lfinger','false','none','150','gold','none','0','-1','0','7','0','33','0','true','true','true','true','0','0'),
('117','Ring of Mana','rfinger,lfinger','true','none','150','silver','b','0','-1','0','34','0','404000','53','true','true','true','true','0','0'),
('118','Necklace of Magic','neck','false','none','150','silver','none','0','-1','0','15','0','66','0','true','true','true','true','0','0'),
('119','Necklace of Binding','neck','true','none','150','adamantaite','c','0','-1','0','64','0','565000','226','true','true','true','true','0','0'),
('347','Ring Mail Breastplate','chest','true','heavy','8820','steel','d','0','-1','77','0','0','83500','151','true','true','true','true','0','0'),
('348','Scale Mail','chest','true','heavy','8720','steel','d','0','-1','87','0','0','133000','241','true','true','true','true','0','0'),
('349','Compound Scale Mail','chest','true','heavy','8620','fine_steel','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('350','Dwarven Scale Mail','chest','true','heavy','8540','fine_steel','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('351','Blast Plate','chest','true','heavy','8420','fine_steel','d','0','-1','97','0','0','203000','369','true','true','true','true','0','0'),
('352','Brigandine Tunic','chest','true','heavy','8320','fine_steel','d','0','-1','103','0','0','299000','543','true','true','true','true','0','0'),
('353','Half Plate Armor','chest','true','heavy','8220','fine_steel','d','0','-1','111','0','0','391000','710','true','true','true','true','0','0'),
('354','Chain Mail Shirt','chest','true','heavy','8120','fine_steel','c','0','-1','120','0','0','505000','202','true','true','true','true','0','0'),
('355','Dwarven Chain Mail Shirt','chest','true','heavy','8070','fine_steel','c','0','-1','129','0','0','644000','257','true','true','true','true','0','0'),
('356','Full Plate Armor','fullarmor','true','heavy','10480','fine_steel','c','0','-1','239','0','0','2090000','836','true','true','true','true','0','0'),
('357','Zubei\'s Breastplate','chest','true','heavy','7970','mithril','b','0','-1','157','0','0','2080000','277','true','true','true','true','0','0'),
('358','Blue Wolf Breastplate','chest','true','heavy','7820','oriharukon','b','0','-1','166','0','0','3220000','429','true','true','true','true','0','0'),
('359','Shining Dragon Armor','fullarmor','true','heavy','6400','mithril','b','0','-1','301','0','0','6770000','902','true','true','true','true','0','0'),
('360','Armor of Victory','chest','true','heavy','3360','oriharukon','b','0','-1','175','0','0','3220000','429','true','true','true','true','0','0'),
..................... etc

is something wrong?

[Zaldron]

..................... etc

What's this? If u add this then nothing is wrong . Just execute the sql it's so simple .

[hidde]

yea i add this

 

i tried to execute but navicat gives me an error

 

[Err] 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 'TYPE=MyISAM' at line 24
[Err] -- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;
[Err] 1146 - Table 'l2jdb.armor' doesn't exist
[Err] -- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Zaldron]

[Err] 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 'TYPE=MyISAM' at line 24
[Err] -- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
TYPE=MyISAM;
[Err] 1146 - Table 'l2jdb.armor' doesn't exist
[Err] -- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Try to do it like this one

[hidde]

tried but same error ;(

[Zaldron]

The problem is here

) TYPE=MyISAM;

it's not typed well . I dont know a lot for sql so wait for another person to reply u .