Character Import/Export tool

Applications/Tools written to make running DarkStar easier for the rest of us.
Desufire
Posts: 162
Joined: Sun Feb 22, 2015 2:58 am

Re: Character Import/Export tool

Post by Desufire » Sat Aug 22, 2015 8:44 pm

One of my gms got his character deleted on accident during the deleting of the merit blob. Been trying to get it back using a recent chars backup with no luck. Think I'm gonna resort to copying all the tables in navicat, executing the backup, then pasting over everything but his character lol. I know there's an easier way, but my brain is fried from personal crap.

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Character Import/Export tool

Post by whasf » Sun Nov 01, 2015 3:49 pm

I have merged this tool into my main administration program, which can be found at https://github.com/DarkstarProject/dspAdmin
-- Whasf

zillory
Posts: 7
Joined: Mon Apr 04, 2016 10:00 pm

Re: Character Import/Export tool

Post by zillory » Thu Apr 07, 2016 1:03 pm

anyone have a script for this in linux by chance?

KOSMOS
Posts: 67
Joined: Thu Jan 29, 2015 10:36 pm

Re: Character Import/Export tool

Post by KOSMOS » Mon Apr 11, 2016 5:18 pm

zillory wrote:anyone have a script for this in linux by chance?
I have backup and import scripts for linux. Need to be using bash or change it to whatever you are using for shell.

viewtopic.php?f=19&t=2967

zillory
Posts: 7
Joined: Mon Apr 04, 2016 10:00 pm

Re: Character Import/Export tool

Post by zillory » Mon Apr 11, 2016 7:33 pm

Thanks, more organized than the one i had made :) but was looking for just a character specific export/import.

KOSMOS
Posts: 67
Joined: Thu Jan 29, 2015 10:36 pm

Re: Character Import/Export tool

Post by KOSMOS » Thu Apr 14, 2016 6:59 pm

zillory wrote:Thanks, more organized than the one i had made :) but was looking for just a character specific export/import.
Remove these lines everything else in the script is for chars.

Code: Select all

touch backup/delivery_box.sql
touch backup/linkshells.sql
touch backup/server_variables.sql
touch backup/auction_house.sql

mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} delivery_box > backup/delivery_box.sql
mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} linkshells > backup/linkshells.sql
mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} server_variables > backup/server_variables.sql
mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} auction_house > backup/auction_house.sql

Post Reply