5165 Server Maintenance or network congestion problem

[Zeroxelli]

Originally Posted by Themilkshakeman

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

[Themilkshakeman]

it came up it navicat with alot of errors again like...

Albetros.something doesnt exist

[Zeroxelli]

Originally Posted by Themilkshakeman

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

[Themilkshakeman]

still didnt work....

said something like

Albetros.itemtype doesnt exist

[Zeroxelli]

Originally Posted by Themilkshakeman

still didnt work....

said something like

Albetros.itemtype doesnt exist

Sorry, redownload it from my last post. Had to reupload the attachment.

[Themilkshakeman]

It still has the same error

Albetros.itemaddition doesnt exist

Do you name the navicat database Albetros?

[Zeroxelli]

Originally Posted by Themilkshakeman

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.

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>

[Themilkshakeman]

[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

[Zeroxelli]

Originally Posted by Themilkshakeman

[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:

[Themilkshakeman]

i have fixed the problem thank you very much

Aiden

[Zeroxelli]

Originally Posted by Themilkshakeman

i have fixed the problem thank you very much

Aiden

No problem.