Page 2 of 2
Re: Character Import/Export tool
Posted: Sat Aug 22, 2015 8:44 pm
by Desufire
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.
Re: Character Import/Export tool
Posted: Sun Nov 01, 2015 3:49 pm
by whasf
I have merged this tool into my main administration program, which can be found at
https://github.com/DarkstarProject/dspAdmin
Re: Character Import/Export tool
Posted: Thu Apr 07, 2016 1:03 pm
by zillory
anyone have a script for this in linux by chance?
Re: Character Import/Export tool
Posted: Mon Apr 11, 2016 5:18 pm
by KOSMOS
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
Re: Character Import/Export tool
Posted: Mon Apr 11, 2016 7:33 pm
by zillory
Thanks, more organized than the one i had made
but was looking for just a character specific export/import.
Re: Character Import/Export tool
Posted: Thu Apr 14, 2016 6:59 pm
by KOSMOS
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