collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: database migration when upgrading from 0.2 to 0.4  (Read 1559 times)

0 Members and 1 Guest are viewing this topic.

Offline lulifuz

  • BeBot User
  • **
  • Posts: 40
  • Karma: +0/-0
database migration when upgrading from 0.2 to 0.4
« on: August 25, 2007, 10:53:52 am »
Hi there,

now that I got BeBot 0.4.1 running I wonder if someone can give me a hint how to get the old database into the new one.
I did not find any post here, but I think this should be of generally interest.

Thanks,

 lulifuz

Offline Ebag333

  • Contributor
  • *******
  • Posts: 134
  • Karma: +0/-0
Re: database migration when upgrading from 0.2 to 0.4
« Reply #1 on: August 25, 2007, 06:56:50 pm »
There's really not much that needs to be converted.

Basically the only way would be to use a data transformation tool, or simply manually do it yourself. :)

Offline lulifuz

  • BeBot User
  • **
  • Posts: 40
  • Karma: +0/-0
Re: database migration when upgrading from 0.2 to 0.4
« Reply #2 on: August 26, 2007, 11:54:54 am »
Hi again,

ups, sorry, I asked before I looked.
Now I did and found out, that the table structure staid the same for the relevant tables. I assumed there was some change.
So I will do it manually to.
To be sure, I list the tables to be ex/imported here and ask for your confirmation:

0.2.x0.4.1
altsalts
logon<dbname>_logon
news<dbname>_news
org_city<dbname>_org_city
raid_points<dbname>_raid_points
tower_attack<dbname>_tower_attack
tower_result<dbname>_tower_result

Hm, where are the guests gone? I assume they go into <db-name>_users with a userlevel of 1.

Thanks allot and regards,

 lulifuz
« Last Edit: August 26, 2007, 11:59:46 am by lulifuz »

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: database migration when upgrading from 0.2 to 0.4
« Reply #3 on: August 26, 2007, 12:53:11 pm »
Yes, guests and members (and all characters on notify) are stored in the users table now. user_level 2 means member, 1 means guest.

Admin groups were changed to the new security system, best is to readd people there though.

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 663
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal