Wiki Server Setup Guide

[Delaide]

Is there a guide describing how to update the server database without losing characters data?

https://wiki.dspt.info/index.php/Building_the_Server

After you've done your initial load, you can use the following script that will preserve character data

Code: Select all

cd c:\darkstar\sql
del auction_house.sql
del chars.sql
del accounts.sql
del accounts_banned.sql
del char_effects.sql
del char_equip.sql
del char_exp.sql
del char_inventory.sql
del char_jobs.sql
del char_look.sql
del char_pet.sql
del char_pet_name.sql
del char_points.sql
del char_profile.sql
del char_skills.sql
del char_stats.sql
del char_storage.sql
del char_vars.sql
del char_weapon_skill_points.sql
del chars.sql
del conquest_system.sql
del delivery_box.sql
del linkshells.sql
FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X

Or, as I do when I update, I have a folder that I keep my backup data in. I backup the data listed there (normally, I leave out char_pet_name, char_weapon_skill_points, delivery_box, and linkshells. I suggest you open them in navicat and see if there is anything in these first if you choose to leave them out) by dumping the SQL (Right click on the table you want to keep, select Dump SQL File), and then, after I copy all the files from the update folder to the server folder (I keep mine in separate folders so I don't pollute them, as well as always zip the server folder before deleting the files in there and replacing with the new code), I will copy the dumped SQL files into the server sql folder so when I run the .bat, it will just use those.

[RenO]

Thank you for your advice. Actually i have only read the linux installation so i missed those lines.

[Lugaid]

What is required for the computer to run the server with a few users on ?
Minimum performance computer, CPU, RAM memory , etc?

[kjLotus]

for just a few people, you could probably run it on a potato

the only thing really that it needs is a bit of memory to store all those mobs, something like 500-600mb for the game server (and more probably if your sql server is on the same machine)

[Lugaid]

Ok, thanks.
Maybe i can use my old "server" and run vmware for another server on the server then

[Silverwolf]

It would be really cool if there was a tutorial for updating your server after its set up...... If it is listed somewhere my apologizes. I searched around and haven't found much but random pieces here and there.. It would be ideal to have it included with the setup guide possibly?

[kjLotus]

it's pretty much the same steps as setting up, just do git pull -> rebuild the servers -> reimport any SQL tables that have changed

[Aiman]

I've been trying to follow this guide, but I can't figure it out.

I'm code illiterate. Sorry!

For some reason when I do a Pull request, I get this error:

git.exe pull -v --no-rebase --progress "origin"

From http://github.com/DarkstarProject/darkstar
= [up to date] master -> origin/master
= [up to date] NeoDynamis -> origin/NeoDynamis
Updating 82e8de3..f796b66
error: Your local changes to the following files would be overwritten by merge:
scripts/commands/mobhere.lua
scripts/commands/npchere.lua
scripts/globals/settings.lua
src/map/entities/baseentity.cpp
Please, commit your changes or stash them before you can merge.
Aborting


git did not exit cleanly (exit code 1) (2605 ms @ 2/25/2015 5:49:05 PM)

If I try to stash, I get this:

git.exe stash save


*** Please tell me who you are.

Run

git config --global user.email "you@example.com"
git config --global user.name "Your Name"

to set your account's default identity.
Omit --global to set the identity only in this repository.

fatal: unable to auto-detect email address (got 'Admin@AsinaServer.(none)')
Cannot save the current index state

I am missing something but I have no idea what it is.

[kjLotus]

have you tried running git config to set your email/name? (it just needs that so it knows who stashed stuff)

[Delaide]

Stashing means you are saving your changes, so you are uploading. That is why you get that. This is honestly why I keep my gitpulls separate from my actual server build, because what you are getting is errors that they do not match.

I use tortoisegit, and how I solved that was by selecting "Revert" or "Clean [up]", or if you do not use tortoisegit, you can do a "git reset --hard" from the git command bash. However, this will set you back to what the original server git pull was, instead of including what you changed. But it will resolve your issue. If you still want to stash your changes, then log in to your git email address with password. The one you log into on github, not on another site.
Here is the information on what a git stash is: http://git-scm.com/book/en/v1/Git-Tools-Stashing