Upgrading database from 7.3.5 to 8.1.5?

How do I apply the SQL update files located in SQL\updates to bring my server up from 7.3.5 to 8.1.5?

I have downloaded the current master branch(, compiled it using vmaps, mmaps, gt, dbc and cameras files extracted from the latest retail client (8.1.5 30706). When I launch worldserver.exe I see it populating the databases from the included SQL files (TDB_world_735.00_2018_02_19.sql and TDB_hotfixes_735.00_2018_02_19.sql).

The problem is that when I then exit and restart worldserver.exe I get about 80,000 errors like the following:

SmartAIMgr::LoadSmartAIFromDB: Entry 18931 SourceType 0, Event 3, Link Source Event not found or invalid. Event will never trigger.

SmartAIMgr: Entry 2225800 SourceType 9 Event 7 Action 11 uses non-existent Spell entry 38679, skipped.

TSCR: DB table script_waypoint has waypoint for creature entry 17238, but creature does not have ScriptName defined and then useless.

Table waypoint_scripts uses deprecated direct updatefield modify command SCRIPT_COMMAND_FIELD_SET_DEPRECATED for script id 463

Scriptname: spell_hun_improved_mend_pet spell (Id: -19572) does not exist.


I can log in to the server and create a new character, but the game is broken (no exclamation points showing for quests, can’t cast spells, etc). When I run SELECT * FROM ‘VERSION’ my database version is still 7.3.5 even though I see in the SQL\updates folders there are .sql files that look like they’ll update the version of my databases to 8.1.5. But when I attempt to execute them I get SQL errors so I don’t think I am applying these update files correctly.

Help, please?

If you can not apply the updates .sql is because you are using mysql 5.5, you need to update to mysql 5.6 and re-create the database.

But a lot of work is still missing for a DB 8.1.5.
From what I have tried, the “Pandaren” have npcs but do not have quests, and the “Demon Hunter” do not have npcs (the classic races seem to work a little better).

Good luck :wink:

I am using MySQL 5.6.

Can you tell me more about how to apply the updates? In the four folders (auth, world, characters and hotfixes) there are over three hundred files. I can’t imagine that I’m supposed to execute each file one at a time in MySQL Workbench. How am I supposed to apply these?

Modify the configuration files in the following way:
(specifying the path of the Source folder (downloaded via git))

SourceDirectory = “D:/Source815example/
Updates.EnableDatabases = 1

SourceDirectory = “D:/Source815example/
Updates.EnableDatabases = 15

Run the server and the updates will be autoapplied .

leave core to do the job, it will import all needed updates, the version is 7.3.5 because there is no full 8.1.5 database.