Welcome to the RaGEZONE - MMORPG development forums.

Data base

This is a discussion on Data base within the Travia Online forums, part of the - Old Archived Files category; no posible DB files.. sql script? (.sql not .bak?)...

Results 1 to 15 of 15
  1. #1
    Infraction Banned
    Rank
    Member +
    Join Date
    Jul 2005
    Location
    Latvia
    Posts
    229
    Liked
    0

    Data base

    Click
    no posible DB files.. sql script? (.sql not .bak?)

  2. #2
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    May 2003
    Location
    The Moon!
    Posts
    333
    Liked
    1

    Re: Data base

    Why would you want the .sqls when all the BAKs have everything in?

    Aqualungs release has the Account and Game DB in .sql

    Wolfos.

  3. #3
    Infraction Banned
    Rank
    Member +
    Join Date
    Jul 2005
    Location
    Latvia
    Posts
    229
    Liked
    0

    Re: Data base

    ooo :D yee...true.. but Chart.bak - In MSSQL 2K .bak format! <----- for this i need MYSQL 2000?

  4. #4
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    May 2003
    Location
    The Moon!
    Posts
    333
    Liked
    1

    Re: Data base

    lol you cant run a travia server in MySQL..... Anyways MySQL is useless for server databases its only good for website dbs.

  5. #5
    Infraction Banned
    Rank
    Member +
    Join Date
    Jul 2005
    Location
    Latvia
    Posts
    229
    Liked
    0

    Re: Data base

    but i have windows vista...i have problem with OBDC....i run this but i can run server....OBDC connect fail....OBDC files not work :/

  6. #6
    Hardcore Member
    Rank
    Member
    Join Date
    Nov 2007
    Location
    travia-online.com
    Posts
    137
    Liked
    3

    Re: Data base

    reinstal winxp, after setup mssql 2000 have fun.

  7. #7
    Infraction Banned
    Rank
    Member +
    Join Date
    Jul 2005
    Location
    Latvia
    Posts
    229
    Liked
    0

    Re: Data base

    i have 6GB ram...but win xp 32 not use all....and winxp x64 sux....

  8. #8
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    May 2003
    Location
    The Moon!
    Posts
    333
    Liked
    1

    Re: Data base

    Maybe just buy a crappy 100gb hard drive and put xp on that just for hosting servers.

    Another option would be virtual pc if you have 6gb of ram.

  9. #9
    Member
    Rank
    Member
    Join Date
    Apr 2008
    Location
    Ukraine
    Posts
    25
    Liked
    0

    Re: Data base

    Quote Originally Posted by Wolfos View Post
    lol you cant run a travia server in MySQL..... Anyways MySQL is useless for server databases its only good for website dbs.
    now I see your position about MySQL... WoW server MaNGOS runs on MySQL but it's DB is much bigger then Travia DB... so where do you see it's useless?

  10. #10
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    May 2003
    Location
    The Moon!
    Posts
    333
    Liked
    1

    Re: Data base

    I just don't see the point in recoding the majority of the database when it works fine already. As the old saying goes "If it aint broke don't fix it". I'm sure there may be some minor advantages in using MYSQL, I personally have never had any problems with it. But it all seems a big waste of time on a game of Travia's age with the massive list of problems that it already has. Having a more stable database is not what Travia needs to make it a better game for developers and players.

    As I stated in the other thread all the classes need balancing, the quests need to be translated, mob spawns need to be editable, the Korean 3.60 client with rotating camera and small items.... The list goes on and on.

    Although if you believe going through the effort of doing what you plan and working in MYSQL to help implement the major changes that Travia needs to be a top mmorpg for devs and players I wish the best of luck to you sir!

  11. #11
    Member
    Rank
    Member
    Join Date
    Apr 2008
    Location
    Ukraine
    Posts
    25
    Liked
    0

    Re: Data base

    Quote Originally Posted by Wolfos View Post
    I just don't see the point in recoding the majority of the database when it works fine already. As the old saying goes "If it aint broke don't fix it". I'm sure there may be some minor advantages in using MYSQL, I personally have never had any problems with it. But it all seems a big waste of time on a game of Travia's age with the massive list of problems that it already has. Having a more stable database is not what Travia needs to make it a better game for developers and players.

    As I stated in the other thread all the classes need balancing, the quests need to be translated, mob spawns need to be editable, the Korean 3.60 client with rotating camera and small items.... The list goes on and on.

    Although if you believe going through the effort of doing what you plan and working in MYSQL to help implement the major changes that Travia needs to be a top mmorpg for devs and players I wish the best of luck to you sir!
    Oh you just don't see that most problems of installing travia server is problems with connecting to DB...

    "If it aint broke don't fix it".- who said it's will be a fix? it's addition, MSSQL support remains...

  12. #12
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    May 2003
    Location
    The Moon!
    Posts
    333
    Liked
    1

    Re: Data base

    As far as installing a Travia server goes I personally have never had problems other than having to update MSSQL however I'm sure having MYSQL as an additional option would be fantastic for new users to Travia server development especially those who have come from Emulated servers such as WoW.

    I still feel there are many more important issues with Travia that would need to be resolved before we can have a big community with major user imput and high usercount private servers.

  13. #13
    Member
    Rank
    Member
    Join Date
    Apr 2008
    Location
    Ukraine
    Posts
    25
    Liked
    0

    Re: Data base

    Quote Originally Posted by Wolfos View Post
    I still feel there are many more important issues with Travia that would need to be resolved before we can have a big community with major user imput and high usercount private servers.
    Yeah... I feel them too...

  14. #14
    Hardcore Member
    Rank
    Member
    Join Date
    Nov 2007
    Location
    travia-online.com
    Posts
    137
    Liked
    3

    Re: Data base

    Quote Originally Posted by SamkuS View Post
    no posible DB files.. sql script? (.sql not .bak?)
    .sql Restore from Query Analyzer

  15. #15
    Account Upgraded | Title Enabled!
    Rank
    Member +
    Join Date
    Feb 2004
    Location
    Just around the bend
    Posts
    207
    Liked
    11

    Re: Data base

    lets fix the server first, it aint broke but we need to make it work with the korean 3.60 client, then maybe we can port the db to mysql which means more trouble/bugs during migration. Do you have the client for the server as is? (chinese old client).

    But its good there are still people interested with travia.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •