Character Import/Export tool

[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.

[whasf]

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

[zillory]

anyone have a script for this in linux by chance?

[KOSMOS]

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]

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

[KOSMOS]

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