Backup accounts help
Backup accounts help
I need to move my private server to another PC due to hardware failure, how do I backup the accounts, char, char_inventory ect so that when I reinstall database all my characters are as they were on old machine (note: I can still access old machine it just keeps crashing on me.)
Sorry if this a really noob question!
Thanks
Sorry if this a really noob question!
Thanks
-
- Developer
- Posts: 539
- Joined: Sun Jul 22, 2012 12:17 am
Re: Backup accounts help
In Navicat, you want to right-click on the following tables and select "Dump SQL file."
accounts
auction_house (optional)
char_effects (buffs, so optional)
char_equip
char_exp
char_inventory
char_jobs
char_look
char_points
char_skills
char_stats
char_titles
char_vars
chars
delivery_box (optional)
linkshells (if in use, and optional)
That should back up your individual server's database. When you install the new database, use the files you create instead of the trunk files for those tables.
accounts
auction_house (optional)
char_effects (buffs, so optional)
char_equip
char_exp
char_inventory
char_jobs
char_look
char_points
char_skills
char_stats
char_titles
char_vars
chars
delivery_box (optional)
linkshells (if in use, and optional)
That should back up your individual server's database. When you install the new database, use the files you create instead of the trunk files for those tables.
Test Server: Hanekawa | Fantasy World: Naito
An occasionally updated list of what works
Bugs reports go here. | Project chat here.
Things I've found, but don't plan to work on.
An occasionally updated list of what works
Bugs reports go here. | Project chat here.
Things I've found, but don't plan to work on.
Re: Backup accounts help
Since this is a fairly old post, is this method for backing up character date still valid? I will be moving my server to a new machine in 2-3 weeks time when I finish building my new one.
Re: Backup accounts help
It doesn't contain all the tables you need, no. There are other threads that talk about it, but basically if you follow *account*,auction_house.sql,blacklist.sql,*char_*,chars.sql,delivery_box.sql,linkshells.sql filters ( assuming you have made no other modifications above and beyond the current SQL ) should be all you need to backup.
Still, the smarter choice has always been to just implement whatever is changed each time and just backup the whole database and current file structure routinely ( particularly if again, you have your own mods to the code ). You can view what gets changed in a SQL file either by using your own comparison software or by going to the Github pages for the darkstar project and clicking on history in changes. Then you won't need to replace entire tables for a few measly changes.
Still, the smarter choice has always been to just implement whatever is changed each time and just backup the whole database and current file structure routinely ( particularly if again, you have your own mods to the code ). You can view what gets changed in a SQL file either by using your own comparison software or by going to the Github pages for the darkstar project and clicking on history in changes. Then you won't need to replace entire tables for a few measly changes.
Re: Backup accounts help
I am still learning how to do a lot of this but am fairly tech savvy. So if I am understanding this right, rather than just backing up/dumping the files listed, just create a backup of the entire SQL database to populate the tables in Navicat on the new comp?
Re: Backup accounts help
I have done this, but please note, you will need to do one thing.Cyprus wrote:I am still learning how to do a lot of this but am fairly tech savvy. So if I am understanding this right, rather than just backing up/dumping the files listed, just create a backup of the entire SQL database to populate the tables in Navicat on the new comp?
You will need to drop the mob_pools and add it from the standard set.
You can see this discussion if you want to see what happens when you just add everything, without replacing the mob_pools: viewtopic.php?f=14&t=2094
Re: Backup accounts help
Awesome...thanks for the info. My new comp will be put together here in a couple weeks & I want to make sure we don't lose progress. This should do the trick!
Re: Backup accounts help
Ok, everything seems to have transferred over just fine with the exception of GM functionality. I went back into the tables to confirm & everything looked right for each character. I set them all again then logged back in. On the game server, I get: cmdhandler::call: Character *character name* attempting to use higher permission command togglegm. A little help here?
Re: Backup accounts help
the chars table changed, look at your server log when you log in
"unknown column mentor"
"unknown column mentor"