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

Want to talk about war3ft or make suggestions? Post them here

Moderator: Forum Moderator

Post Reply
User avatar
ghostbuster
Peon
Posts: 6
Joined: Wed Aug 31, 2005 6:53 am
Location: Sweden
Contact:

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

Post by ghostbuster » Fri Oct 31, 2008 8:53 am

Hi !

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


/GB
Image

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

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

Post by YamiKaitou » Fri Oct 31, 2008 11:55 am

It is built in to the plugin
Image

No support via PM or Email

User avatar
ghostbuster
Peon
Posts: 6
Joined: Wed Aug 31, 2005 6:53 am
Location: Sweden
Contact:

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

Post by ghostbuster » Sun Dec 07, 2008 11:13 am

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
Image

Post Reply