Jump to content
TrinityCore

Location of Databases (Character DB)


Great Name No Game
 Share

Recommended Posts

Hey folks. Just had a question thats been on my mind for the day. Racked my brain trying to think of locations. Is there a definite location in my Trinity folders and / or drive that has the location of all the character files? I'd like to back it up in case anything goes wrong. As far as backups go, whats the best folder to back up for rapid rollback in the event anything goes wrong? I'm currently having an issue that is suggested to drop the DB from my lists, but if it wipes out all characters on my server (Master), I really don't want to have to do that without a viable backup for it. ANy guidance would be appreciated. Thanks! - JH

Link to comment
Share on other sites

If you check your DB server, there should be 3 databases that contain TC data:

- auth: useraccounts and server connection profiles (realms)
- characters: what it says on the tin
- world: what it says on the tin

The first 2 databases contain 'unique' information in the sense that it's unique to your server, it contains everything people did on your server. The world database is the only one that you can ignore for backup purposes, as it can be reconstructed.
 

Link to comment
Share on other sites

@Thulium - Thanks! I'll work on it. I had the misfortune of trying to create a 335 server while simultaneously hosting a Master server. :blink: Yeah....lesson learned. Im gonna have to see if I can weed through my old DB and see if anything can be salvaged. Not holding my breath though unless anyone has any suggestions. (I didn't have a *WHOLE* lot, but one character was all beefed up......) :ph34r:

Link to comment
Share on other sites

2 hours ago, Great Name No Game said:

Moving forward, I think that's the best course of action. As far as setting up 2 servers on one machine, what other precautions should I take?

You can run 2 or more TC environments on one machine. Completely separated as if they are hosted on separately. I do hourly backups and replication on my databases. Since, I have a pretty large box with bandwidth, I just do dev work on the machine, compile only taking up 8 out of the 16 cores.

This is all of course on Linux. I think Windows is a pig and just takes up unnecessary resources.

That way if there are any crashes or compile issues, the other servers are only taking 6-8 cores and no lag. The other environments have no idea that anything else is running on the same node. Also, you run screen sessions on linux. Just some tips ;)

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...