5165 Server Maintenance or network congestion problem

06/24/2012 22:54 Zeroxelli#16
Quote:
Originally Posted by Themilkshakeman View Post
Last question

i tried execut sql file what do i name the data base as it has came up with alot of errors

aiden
Name it Albetros
06/24/2012 22:56 Themilkshakeman#17
it came up it navicat with alot of errors again like...

Albetros.something doesnt exist
06/24/2012 23:00 Zeroxelli#18
Quote:
Originally Posted by Themilkshakeman View Post
it came up it navicat with alot of errors again like...

Albetros.something doesnt exist
Here, use this SQL file:

Edit: Reuploaded it. Try now
06/24/2012 23:02 Themilkshakeman#19
still didnt work....

said something like

Albetros.itemtype doesnt exist
06/24/2012 23:05 Zeroxelli#20
Quote:
Originally Posted by Themilkshakeman View Post
still didnt work....

said something like

Albetros.itemtype doesnt exist
Sorry, redownload it from my last post. Had to reupload the attachment.
06/24/2012 23:07 Themilkshakeman#21
It still has the same error

Albetros.itemaddition doesnt exist

Do you name the navicat database Albetros?
06/24/2012 23:11 Zeroxelli#22
Quote:
Originally Posted by Themilkshakeman View Post
It still has the same error

Albetros.itemaddition doesnt exist

Do you name the navicat database Albetros?
How are you trying to insert it? I just tried, and it worked fine.

Code:
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>
06/24/2012 23:15 Themilkshakeman#23
HTML 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
--------------------------------------------------
That what it comes up with when i execute sql file
06/24/2012 23:27 Zeroxelli#24
Quote:
Originally Posted by Themilkshakeman View Post
HTML 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
--------------------------------------------------
That what it comes up with when i execute sql file
Try this file, I changed the engine for each of the tables from InnoDB to MyISAM:
06/25/2012 03:52 Themilkshakeman#25
i have fixed the problem thank you very much

Aiden
06/25/2012 04:25 Zeroxelli#26
Quote:
Originally Posted by Themilkshakeman View Post
i have fixed the problem thank you very much

Aiden
No problem.