How are you trying to insert it? I just tried, and it worked fine.Quote:
It still has the same error
Albetros.itemaddition doesnt exist
Do you name the navicat database Albetros?
Justin@Grimmjow ~ $ mysql -u root -p < FullBackup.sql Enter password: ********* Justin@Grimmjow ~ $ mysql -u root -p Enter password: ********* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.5.8 MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> USE `Albetros`; Database changed mysql> SHOW TABLES; +--------------------+ | Tables_in_albetros | +--------------------+ | accounts | | bugs | | characters | | chatlogging | | cq_map | | droprules | | dyna_rank_rec | | events | | eventspawns | | friend | | guild | | guildattr | | item | | itemaddition | | itemrefine | | items | | itemtype | | levexp | | message | | mobspawns | | mobspawnsold | | monsterinfos | | monsterinfosold | | news | | nobility | | npcs | | npcscript | | patch_notes | | portals | | proficiency | | refinery | | refinerytype | | skills | | sobs | | spellinfo | | title | | vote | | vote2 | | website | | websitefaq | | websitenews | | websitevote | +--------------------+ 42 rows in set (0.11 sec) mysql>
[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working [Err] CREATE TABLE `accounts` ( `UID` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL, `password` varchar(16) NOT NULL, `email` varchar(40) DEFAULT NULL, `emailver` varchar(20) DEFAULT NULL, `emailstatus` int(3) NOT NULL DEFAULT '0', `answer` varchar(22) DEFAULT NULL, `question` varchar(55) DEFAULT NULL, `Permission` int(3) NOT NULL DEFAULT '1', `Hash` int(11) DEFAULT NULL, `Timestamp` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`UID`,`username`) ) ENGINE=InnoDB AUTO_INCREMENT=10000041 DEFAULT CHARSET=latin1; [Msg] Finished - Unsuccessfully --------------------------------------------------
Try this file, I changed the engine for each of the tables from InnoDB to MyISAM:Quote:
That what it comes up with when i execute sql fileHTML Code:[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working [Err] CREATE TABLE `accounts` ( `UID` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL, `password` varchar(16) NOT NULL, `email` varchar(40) DEFAULT NULL, `emailver` varchar(20) DEFAULT NULL, `emailstatus` int(3) NOT NULL DEFAULT '0', `answer` varchar(22) DEFAULT NULL, `question` varchar(55) DEFAULT NULL, `Permission` int(3) NOT NULL DEFAULT '1', `Hash` int(11) DEFAULT NULL, `Timestamp` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`UID`,`username`) ) ENGINE=InnoDB AUTO_INCREMENT=10000041 DEFAULT CHARSET=latin1; [Msg] Finished - Unsuccessfully --------------------------------------------------