Problem with importing database

[Spo teh pro]

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:

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

 

[ExibeR]

Yes, create guild_ranks.

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 ;

 

[Bintzer]

You don't have the table guild_ranks in the database "theforgottenserver"

Exactly what the error says....

 

[Spo teh pro]

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 <_<

 

[Nikkster]

The error clearly tells you what's wrong, just read >_<

 

[exique]

@up
Listen to Nikkster :O

He is pro!
(Bintzer to)

 

[Spo teh pro]

#1146 - Table 'forgottenserver.guild_ranks' doesn't exist


But the table guild_ranks
DOES exist...

 

[Nikkster]

Try re-importing the database once again, try without any backup and see if it works.