Step by step guide to update your server?

[kjLotus]

depends, have you modified those files?

[enkidou]

Yeah, they have been.

[kjLotus]

then the extra step is to commit your files (and push them to your fork if you want to do that) before doing pull or merge

[enkidou]

That might have done it. I believe i had to resolve some issues (conflicts?) and then commit before it let me merge. Thanks!

Also, Delaide, I'm interested in your loading the game without having the console window!

[Delaide]

Also, Delaide, I'm interested in your loading the game without having the console window!

I have uploaded my current work to here: https://github.com/helixhamin/DSP-Control
Sorry, I am new at programming, and using this as a learning tool since I don't want risk messing up DSP if I try to change things. But, it is currently working as expected, if not very efficient/effective.

Right now, I am simply not having the console boxes drawn unless you select Show Server from the view menu. I still need to figure out why if you don't sent a path, it doesn't give the error message, but instead crashes. It was working before I simplified the path storage, but I will get it worked out. Unfortunately, I left some of my working stuff in there, so you can get a slight sample of what I plan to do with some useless boxes and buttons. I hope to output the text of the server consoles with hide/show features, so I won't even need to offer a show console function. However, none of that is working right now, so it is just screen garbage, but that is the next step for my launcher.

[enkidou]

Awesome. I'll check it out!

No need to be sorry. I'm a rookie at this and using this kind of project as a way to learn as well.

[enkidou]

1. Backup appropriate MySQL tables. Always do this before doing anything else. If you want a script, I have a .bat file posted here: viewtopic.php?f=16&t=2428 It does correctly pull the appropriate tables, but make sure you put in your user name and password.

Delaide, is this .bat file only backing up the character related .sql files or is executing all of the other .sql files in the folder at the same time? In other words, after running this do I need to then go into Navicat and manually execute the files?

[Delaide]

character, action house, delivery boxes, linkshells, etc. It is based on the required files in the wiki. Basically, all the stuff you need to keep when updating server to keep from losing player data.

You can cross check the list in my bat files with the list at the wiki: https://wiki.dspt.info/index.php/Building_the_Server

And, then I just copy those over the git pulled ones, and rerun the DSP_Import.bat. It doesn't matter if it is fresh git or your backed up tables, DSP_Import.bat just populates the mysql database with whatever sql you have in the folder.

[enkidou]

character, action house, delivery boxes, linkshells, etc. It is based on the required files in the wiki. Basically, all the stuff you need to keep when updating server to keep from losing player data.

You can cross check the list in my bat files with the list at the wiki: https://wiki.dspt.info/index.php/Building_the_Server

And, then I just copy those over the git pulled ones, and rerun the DSP_Import.bat. It doesn't matter if it is fresh git or your backed up tables, DSP_Import.bat just populates the mysql database with whatever sql you have in the folder.

Gotcha. So...

1. Run your .bat file

2. Copy and overwrite the backed up sql's back into your sql folder.

3. Run the DSP_Import.bat

Then good to go?

[Delaide]

Correct. This is how I do it. I do however have a couple steps I do between 2 and 3.

1.
2.
2.1 - Drop dspdb database in mysql using your preferred application
2.2 - Create new dspdb
3.

This way I make sure nothing is polluted in my database. But that is why I also have a backup of the entire database. The bat file I created also creates a dump of the entire dspdb, so the entire database can be restored if I mess something up during server updates. The dspdb.sql should not be copied into your dsp sql folder, or you will get conflicts, since the DSP_Import.bat tries to import everything in your folder. So, you have individual tables being imported, as well as the entire old database (if dspdb.sql is put into the sql folder). I am not sure what happens, but I would be worried about having some sort of conflicts and possible polluted information.