Linux mysql - problem with import

[kacpersky]

when i import database i get this error:

ERROR 1146 (42S02) at line 4531: Table 'roxor.player_skills' doesn't exist

line 4531:

INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `redskull`, `redskulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `created`, `nick_verify`, `hide_char`, `comment`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`) VALUES

someone could help me ?

 

[Saj]

Create a new table and name it to: roxon.player_skills

 

[kacpersky]

CREATE TABLE `roxon`.`roxon.player_skills` (
`sd` VARCHAR( 12 ) NOT NULL
) ENGINE = MYISAM

#1103 - Incorrect table name 'roxor.player_skills'

i create i table : player_skills. Now its ok, bu i get another error:

Cannot add or update a child row: a foreign key constraint fails (`roxon/#sql-1c3f_334`, CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE)