updating 1.12.1 mangos to current TBC mangos

[LeutianKane]

just a quick question if anyone could point me to a thread that explains updating my current 1.12.1 mangos server to the current TBC mangos version keeping all my current logins and accounts of course.

Thanks in advance
LeutianKane

[MentaL]

[stefan600]

[WIKI]
http://rapidshare.com/files/26676802/1.12....2.0.12_v1.2.rar

This contains 3 files:

- Mangos1.12.xto2.0.12.py: this is the main converter that generate a file named GoTo2.0.12.sql.
Configure the tool and run it, then apply the resulting sql file. No modification done on database at runtime.
- Talents_112.py: This file is a dependency to Mangos1.12.xto2.0.12.py containing information to reset the talent and credit the money back to characters, do not run it.

- Reset Auras.py: Use this file after you migrated to 2.0.12 and checked that it was working fine to remove all aura from all characters. I saw there is often a lot of Auras on characters that comes from old ages and it's time with 2.0.12 release to clean them. This tool also generate a file named DeleteAuras.sql and does no modification to the database at runtime.

Requirements for Windows:
Python : http://www.python.org/ftp/python/2.4.3/python-2.4.3.msi
MySQLdb : http://prdownloads.sourceforge.net/mysql-p....4.exe?download

Backup you database before applying the sql files.

Have fun with 2.0.12

How to use it:
1) Install Python 2.4 and MySQLdb
2) Configure the tools (Mangos1.12.xto2.0.12.py and Reset Auras.py) by editing the database information in the configuration section (edit with notepad, vi or whatever you want)
The target database must be containing the 1.12.x characters and must be updated to 2.0.x (Modb installed on top or whatever database you want).
3) Run Mangos1.12.xto2.0.12.py. It's better to run it from a command prompt to be able to see anything displayed.
4) Import file GoTo2.0.12.sql to your database(you must have imported a new TBC dB!): this updates the characters, the items and resets talents
5) Run Reset Auras.py
6) Import file DeleteAura.sql to your database. END

Note:
- If the database contains some 2.0.x accounts already, they will be broken. Same for items. This is a full migration tool, not a half migration one.
- The AuraCleanup tool REQUIRES the characters to be already migrated to 2.0.12 in database.
[/WIKI]

[LeutianKane]

Awesome thanks a ton you just saved me a TON of time digging around for this stuff.