Hi. I got almost all the way to the end of the server creation tutorial, but then had issues importing the trinity database.
I'm using SQLyog, created a database called "trinity" as instructed in the guide and selected "Import\Restore from SQL dump", pointing it to the PDS_Pure_Blizz.sql file. It gets about 60% through and then errors out with the following message:
Query:
DELETE FROM `creature` WHERE `id`=3939
Error occured at:2009-08-15 21:42:22
Line no.:2
Error Code: 1146 - Table 'mangos.creature' doesn't exist
Query:
INSERT INTO `db_version` VALUES
('Mangos default database.','Creature EventAI not provided.',NULL)
Error occured at:2009-08-16 11:50:57
Line no.:37
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO `db_version` VALUES
('Mangos default database.','Creature EventAI not provided.',NULL)
Error occured at:2009-08-16 11:52:02
Line no.:37
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO `locales_creature` VALUES ('12385', '', '', '', '', '', '', '', 'Усовершенствованный манекен-мишень орудийного расчета', null, null, null, null, null, null, null, null)
Error occured at:2009-08-16 13:01:04
Line no.:1576212
Error Code: 1406 - Data too long for column 'name_loc8' at row 1
Query:
INSERT INTO `locales_creature` VALUES ('12385', '', '', '', '', '', '', '', 'Усовершенствованный манекен-мишень орудийного расчета', null, null, null, null, null, null, null, null)
Error occured at:2009-08-16 13:26:41
Line no.:1576635
Error Code: 1406 - Data too long for column 'name_loc8' at row 1
Query:
INSERT INTO `locales_creature` VALUES ('12385', '', '', '', '', '', '', '', 'Усовершенствованный манекен-мишень орудийного расчета', null, null, null, null, null, null, null, null)
Error occured at:2009-08-16 14:02:24
Line no.:1576212
Error Code: 1406 - Data too long for column 'name_loc8' at row 1
I also tried with Navicat lite but got errors right away (I could only execute batch on the database root, not the individual DBs, is this a Lite version limitation?)
I'll admit I'm a total noob at SQL and that there could be something really obvious I'm overlooking, but I've searched high and low and had no luck so far. Any help would be greatly appreciated.