Having trouble updating my world DB to the point where the worldserver executable will stop giving me unknown entry errors.
I've ran the update batch file (for windows), and I've got 5 world_update sql files in my updates directory, along with the update_1,2, etc folders.
world_updates ( the one that is modified with the batch file I believe) executes fine in sqlyog, but when I go to execute world_updates1 I run into many errors.
Query:
CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
Error occured at:2013-02-14 21:06:29
Line no.:3
Error Code: 1007 - Can't create database 'world'; database exists
Query:
CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
Error occured at:2013-02-14 21:06:50
Line no.:3
Error Code: 1007 - Can't create database 'world'; database exists
Query:
DROP TABLE IF EXISTS `access_requirement`
Error occured at:2013-02-17 17:26:08
Line no.:22
Error Code: 1046 - No database selected
Query:
UPDATE `version` SET `db_version`='TDB 335.49', `cache_id`=49 LIMIT 1
Error occured at:2013-02-17 17:27:09
Line no.:2
Error Code: 1146 - Table 'world.version' doesn't exist
a portion of the sqlyog error file after the execution of world_updates1 aborts.
Ideas?