Помогите импорт permissions.yml в бд

[TekTonneR]

прописал команду pex dump sql permisseons.yml, все прошло гуд
но когда заливаю в бд то вот такая ошибка

Спойлер

Ошибка

SQL-запрос:
INSERT INTO `permissions_entity` ( `name` , `type` , `prefix` , `suffix` , `default` )
VALUES (
'user', 0, '&E', '&E', 1
);


Ответ MySQL:
#1062 - Duplicate entry 'user' for key 'name'

пермы

Спойлер

groups:
user:
default: true
permissions:
- modifyworld.*
- -bukkit.command.plugins
- iConomy.holdings
- iConomy.payment
- iConomy.help
- iConomy.user
- ChestShop.shop.buy.itemID
- ChestShop.shop.sell.itemID
- essentials.help
- essentials.help.[pluginname]
- essentials.info
- essentials.mail
- essentials.mail.send
- essentials.motd
- essentials.msg
- essentials.rules
- essentials.spawn
- essentials.sethome
- essentials.home
- essentials.delhome
- essentials.warp.list
- essentials.suicide
- falsebook.blocks.*
- essentials.sethome.multiple
- essentials.sethome.multiple.user
prefix: '&E'
suffix: '&E'
vip:
default: false
inheritance:
- user
permissions:
- essentials.warp
- essentials.msg.color
- essentials.msg.format
- essentials.msg.magic
- essentials.msg.url
- essentials.afk
- essentials.me
- essentials.kit
- essentials.kit.vip
- essentials.fly
- falsebook.cart.*
- essentials.sethome.multiple.vip
prefix: '&D[VIP]&8'
suffix: '&D'
moder:
default: false
inheritance:
- vip
permissions:
- ChestShop.shop.create
- essentials.gamemode
- essentials.list
- essentials.seen
- essentials.seen.banreason
- essentials.ban
- essentials.ban.offline
- essentials.unban
- essentials.kick
- essentials.mute
- essentials.mute.exempt
- essentials.tempban
- essentials.tempban.*
- essentials.sethome.multiple.unlimited
- essentials.weather
- essentials.whois
- essentials.near
prefix: '&A[Moder]&9'
suffix: '&A'
Admin:
default: false
permissions:
- authme.admin.register
- authme.admin.unregister
- authme.admin.reload
- authme.admin.changepassword
- '*'
prefix: '&4[Admin]&4'
suffix: '&C'

Спойлер

INSERT INTO `permissions_entity` ( `name`, `type`, `prefix`, `suffix`, `default` ) VALUES ( 'user', 0, '&E','&E', 1 );
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'modifyworld.*', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, '-bukkit.command.plugins', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'iConomy.holdings', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'iConomy.payment', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'iConomy.help', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'iConomy.user', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'ChestShop.shop.buy.itemID', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'ChestShop.shop.sell.itemID', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.help', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.help.[pluginname]', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.info', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.mail', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.mail.send', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.motd', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.msg', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.rules', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.spawn', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.sethome', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.home', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.delhome', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.warp.list', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.suicide', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'falsebook.blocks.*', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.sethome.multiple', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('user', 0, 'essentials.sethome.multiple.user', '', '');
INSERT INTO `permissions_entity` ( `name`, `type`, `prefix`, `suffix`, `default` ) VALUES ( 'vip', 0, '&D[VIP]&8','&D', 0 );
INSERT INTO `permissions_inheritance` ( `child`, `parent`, `type` ) VALUES ( 'vip', 'user', 0);
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.warp', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.msg.color', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.msg.format', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.msg.magic', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.msg.url', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.afk', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.me', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.kit', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.kit.vip', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.fly', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'falsebook.cart.*', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('vip', 0, 'essentials.sethome.multiple.vip', '', '');
INSERT INTO `permissions_entity` ( `name`, `type`, `prefix`, `suffix`, `default` ) VALUES ( 'moder', 0, '&A[Moder]&9','&A', 0 );
INSERT INTO `permissions_inheritance` ( `child`, `parent`, `type` ) VALUES ( 'moder', 'vip', 0);
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'ChestShop.shop.create', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.gamemode', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.list', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.seen', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.seen.banreason', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.ban', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.ban.offline', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.unban', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.kick', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.mute', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.mute.exempt', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.tempban', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.tempban.*', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.sethome.multiple.unlimited', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.weather', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.whois', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('moder', 0, 'essentials.near', '', '');
INSERT INTO `permissions_entity` ( `name`, `type`, `prefix`, `suffix`, `default` ) VALUES ( 'Admin', 0, '&4[Admin]&4','&C', 0 );
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('Admin', 0, 'authme.admin.register', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('Admin', 0, 'authme.admin.unregister', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('Admin', 0, 'authme.admin.reload', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('Admin', 0, 'authme.admin.changepassword', '', '');
INSERT INTO `permissions` ( `name`, `type`, `permission`, `world`, `value`) VALUES ('Admin', 0, '*', '', '');

 

[WhiteSS]

prefix: '&E'
suffix: '&E'

Одинаковые строчки,чую в них проблема

 

[Raptor2108]

Удали все данные в бд, там по умолчанию создается группа default и прочее, это все надо стереть, а потом уже импортировать.

 

[Sanchez218]

Чую .yml туда не импортируется.
Только .sql
Сделай дамп, AimFire