Makalasya Posted November 11, 2014 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 1 Reputation: 0 Joined: 11/11/14 Last Seen: November 2, 2016 Share Posted November 11, 2014 (edited) Hi i have 1 error on load main.sql in navicat [Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working [Err] -- -- Table structure for table `skillcooldown` -- CREATE TABLE IF NOT EXISTS `skillcooldown` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `skill` smallint(11) unsigned NOT NULL DEFAULT '0', `tick` int(11) NOT NULL, KEY `account_id` (`account_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `auction` -- CREATE TABLE IF NOT EXISTS `auction` ( `auction_id` bigint(20) unsigned NOT NULL auto_increment, `seller_id` int(11) unsigned NOT NULL default '0', `seller_name` varchar(30) NOT NULL default '', `buyer_id` int(11) unsigned NOT NULL default '0', `buyer_name` varchar(30) NOT NULL default '', `price` int(11) unsigned NOT NULL default '0', `buynow` int(11) unsigned NOT NULL default '0', `hours` smallint(6) NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `item_name` varchar(50) NOT NULL default '', `type` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; -- -- Table structure for table `cart_inventory` -- CREATE TABLE IF NOT EXISTS `cart_inventory` ( `id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char` -- CREATE TABLE IF NOT EXISTS `char` ( `char_id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `char_num` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL DEFAULT '', `class` smallint(6) unsigned NOT NULL default '0', `base_level` smallint(6) unsigned NOT NULL default '1', `job_level` smallint(6) unsigned NOT NULL default '1', `base_exp` bigint(20) unsigned NOT NULL default '0', `job_exp` bigint(20) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `max_hp` mediumint(8) unsigned NOT NULL default '0', `hp` mediumint(8) unsigned NOT NULL default '0', `max_sp` mediumint(6) unsigned NOT NULL default '0', `sp` mediumint(6) unsigned NOT NULL default '0', `status_point` int(11) unsigned NOT NULL default '0', `skill_point` int(11) unsigned NOT NULL default '0', `option` int(11) NOT NULL default '0', `karma` tinyint(3) NOT NULL default '0', `manner` smallint(6) NOT NULL default '0', `party_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `pet_id` int(11) unsigned NOT NULL default '0', `homun_id` int(11) unsigned NOT NULL default '0', `elemental_id` int(11) unsigned NOT NULL default '0', ` [Msg] Finished - Unsuccessfully -------------------------------------------------- any solution? thx Edited November 11, 2014 by Makalasya Quote Link to comment Share on other sites More sharing options...
Jolteo Posted November 11, 2014 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 12 Reputation: 0 Joined: 02/26/14 Last Seen: April 26, 2023 Share Posted November 11, 2014 Hi i have 1 error on load main.sql in navicat [Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working [Err] -- -- Table structure for table `skillcooldown` -- CREATE TABLE IF NOT EXISTS `skillcooldown` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `skill` smallint(11) unsigned NOT NULL DEFAULT '0', `tick` int(11) NOT NULL, KEY `account_id` (`account_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `auction` -- CREATE TABLE IF NOT EXISTS `auction` ( `auction_id` bigint(20) unsigned NOT NULL auto_increment, `seller_id` int(11) unsigned NOT NULL default '0', `seller_name` varchar(30) NOT NULL default '', `buyer_id` int(11) unsigned NOT NULL default '0', `buyer_name` varchar(30) NOT NULL default '', `price` int(11) unsigned NOT NULL default '0', `buynow` int(11) unsigned NOT NULL default '0', `hours` smallint(6) NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `item_name` varchar(50) NOT NULL default '', `type` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; -- -- Table structure for table `cart_inventory` -- CREATE TABLE IF NOT EXISTS `cart_inventory` ( `id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char` -- CREATE TABLE IF NOT EXISTS `char` ( `char_id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `char_num` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL DEFAULT '', `class` smallint(6) unsigned NOT NULL default '0', `base_level` smallint(6) unsigned NOT NULL default '1', `job_level` smallint(6) unsigned NOT NULL default '1', `base_exp` bigint(20) unsigned NOT NULL default '0', `job_exp` bigint(20) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `max_hp` mediumint(8) unsigned NOT NULL default '0', `hp` mediumint(8) unsigned NOT NULL default '0', `max_sp` mediumint(6) unsigned NOT NULL default '0', `sp` mediumint(6) unsigned NOT NULL default '0', `status_point` int(11) unsigned NOT NULL default '0', `skill_point` int(11) unsigned NOT NULL default '0', `option` int(11) NOT NULL default '0', `karma` tinyint(3) NOT NULL default '0', `manner` smallint(6) NOT NULL default '0', `party_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `pet_id` int(11) unsigned NOT NULL default '0', `homun_id` int(11) unsigned NOT NULL default '0', `elemental_id` int(11) unsigned NOT NULL default '0', ` [Msg] Finished - Unsuccessfully -------------------------------------------------- any solution? thx Search in the MySQL my.cnf and look for: # Read the manual if you want to enable InnoDB! skip-innodb and replace to: # Read the manual if you want to enable InnoDB! #skip-innodb Do not forget to restart MySQL. Quote Link to comment Share on other sites More sharing options...
Jolteo Posted November 12, 2014 Group: Members Topic Count: 4 Topics Per Day: 0.00 Content Count: 12 Reputation: 0 Joined: 02/26/14 Last Seen: April 26, 2023 Share Posted November 12, 2014 · Hidden by Emistry, November 12, 2014 - non-related Hidden by Emistry, November 12, 2014 - non-related hehehe Link to comment
Question
Makalasya
Hi
i have 1 error on load main.sql in navicat
any solution?
thx
Edited by MakalasyaLink to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.