Page 1 of 1

Upgrading database from 2.x to 3.x possible?

Posted: Fri Oct 31, 2008 8:53 am
by ghostbuster
Hi !

Can't find info how to upgrade mysql database from 2.x to 3.x .
Can this be done ?
How ?


/GB

Re: Upgrading database from 2.x to 3.x possible?

Posted: Fri Oct 31, 2008 11:55 am
by YamiKaitou
It is built in to the plugin

Re: Upgrading database from 2.x to 3.x possible?

Posted: Sun Dec 07, 2008 11:13 am
by ghostbuster
Hi !

Found out what was going wrong.

1. Had to add plaierip varchar(30) to old table !
2. Modified upgrade script
changed
"INSERT INTO wc3_player select '', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",
to
"INSERT INTO wc3_player select '0', playerid, playerip, playername, time FROM `war3users` GROUP BY playerid;",

in "db_mysqlx.inl" and compiled war3ft again. Then it worked :P

/GB