Well, here's my idea:
1) Create the new database
2) Source in the necessary files for the new database
3) Configure the server to use the new database
4) Log into the game and verify the bots are working properly
If the bots work the way then you should do the following:
.Log into MySQL (phpMyAdmin or commandline or use whatever database management tool you prefer)
.Access the OLD database
.Export the following tables as flat sql files:
Bot SQL file:
botinventory
bots
Character Data SQL file:
character_
character_activities
character_enabledtasks
character_tasks
inventory
.Access the NEW database
.Import the SQL files you exported above into the new database
Assuming everything works properly with a fresh database the above should achieve your end goal.
Hope this helps
|