• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Problem with importing database

Spo teh pro

New Member
Joined
Jan 3, 2008
Messages
319
Reaction score
1
Hello, since my host PC started to lag at kinda 80~ players, we try to host the server now at a real life friend
But when we try to import the database this error appears:

Code:
--
-- Daten für Tabelle `guilds`
--
INSERT INTO `guilds` ( `id` , `world_id` , `name` , `ownerid` , `creationdata` , `motd` , `description` , `logo_gfx_name` )
VALUES ( 3, 0, 'Curentum Iudicium', 150, 1239849381, 'Today our guild has been founded. A warm Welcome and hope for a good future.', 'Curentum Iudicium - The First Guild On This Server:\r\nWe inviting only Rookstayers of level 20 or higher for a little fee [550 gp] to avoid Noobs. Message ''Vepsterus'' for inviting.\r\nBE PART OF THE LEGEND!', 'curentum_iudicium.jpg' ) , ( 8, 0, 'Znow Karamy Razem', 162, 1240038938, '', 'New guild. Leader must edit this text :)', '' ) , ( 5, 0, 'Fajna Gildia', 229, 1239904412, '', 'Polska Gildia. Przyjmuje wszystkich ktorzy chca dolaczyc do mojej gildii. Pzdr', '' ) , ( 7, 0, 'Fairy Tail', 65, 1240022281, '', 'New guild. Leader must edit this text :)', '' ) , ( 9, 0, 'Black And White', 213, 1240039069, '', 'New guild. Leader must edit this text :)', '' ) , ( 10, 0, 'GrupaRemontowa', 384, 1240056882, '', 'Lord Gildi Dark Rose ZapraszA Wszystkich Do Naszej Gildi ^^\r\nGwarantujemy Udane Wary...\r\nWspulne Questy...\r\nPo Wiecej Info MOJE GG 4491262 :]\r\n Sinteria 7.6 Dark Rose ... THE BEST OF CLUB FIGHT !', '' ) ;

MySQL meldet: Dokumentation
#1146 - Table 'forgottenserver.guild_ranks' doesn't exist

could anyone help me please?
its important !!=D
 
Yes, create guild_ranks.
Code:
CREATE TABLE IF NOT EXISTS `guild_ranks` (
  `id` int(11) NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL COMMENT 'guild',
  `name` varchar(255) NOT NULL COMMENT 'rank name',
  `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
  PRIMARY KEY  (`id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;
 
Well at my host it works (the server is running atm at my host)

When i try to give the database to my mate (EXACTLY THE SAME) nothing changed this error appears

If i creat guildranks and i try to import the rest there's still a error <_<
 
Back
Top