SERVER Admin QUESTION: Proper Server & SQL patching

General discussion about Life is Feudal MMO and Life is Feudal: Your Own, The main section and backbone of the forums.
User avatar
Razoreqx
 
Posts: 91
Joined: 06 Oct 2014, 13:13

SERVER Admin QUESTION: Proper Server & SQL patching

Post by Razoreqx » 06 Oct 2014, 13:27

I have a question about server & sql patching.
I have 2 servers, one running SQL and the other running LIF server software. Neither of these boxes are running steam so I have to manually copy any file updates from my game PC to the servers.

Last week there was a patch which included a server update. Is there a set or fixed list of files which would NOT be copied from the Steam download on my game PC to the dedicated server?

I don't want to over right our data files is my only concern.

As far as SQL: When the tables are changed in updates do we get notified? Also do they provide a script to patch the db?

Sorry for all the questions, just trying to avoid one really pissed off wife if I erase her game.. LOL
Razors Edge
A Life is Feudal Persistent World
http://razors-edge.org
22 Custom MODS / Custom Graphics models Planned. Visit our Gallery.

User avatar
Razoreqx
 
Posts: 91
Joined: 06 Oct 2014, 13:13

Re: SERVER Admin QUESTION: Proper Server & SQL patching

Post by Razoreqx » 06 Oct 2014, 15:37

If this question has been addressed I didnt find it in the search. If someone could point me to the link i would appreciate it.


thanks.
Razors Edge
A Life is Feudal Persistent World
http://razors-edge.org
22 Custom MODS / Custom Graphics models Planned. Visit our Gallery.

User avatar
Razoreqx
 
Posts: 91
Joined: 06 Oct 2014, 13:13

Re: SERVER Admin QUESTION: Proper Server & SQL patching

Post by Razoreqx » 07 Oct 2014, 13:11

BUMP
Razors Edge
A Life is Feudal Persistent World
http://razors-edge.org
22 Custom MODS / Custom Graphics models Planned. Visit our Gallery.

User avatar
Gagi2
 
Posts: 6
Joined: 30 Sep 2014, 18:57

Re: SERVER Admin QUESTION: Proper Server & SQL patching

Post by Gagi2 » 07 Oct 2014, 14:43

use steamcmd to download/install the serverfiles...

i use it for almost every server i host on my machine which is running on steam...

for making it simple i use this script
Code: Select all
@echo off

SETLOCAL ENABLEDELAYEDEXPANSION

       :: DEFINE the following variables where applicable to your install

    SET STEAMLOGIN=yoursteamloginname yoursteampassword
    SET BRANCH=320850
        :: For stable use 320850
                :: Note, the missing qotation marks, these need to be wrapped around the entire "+app_data......"

    SET Path=c:\Gameserver\LifeIsFeudal
        SET STEAMPATH=C:\Gameserver\steamcmd_win32


:: _________________________________________________________

echo.
echo     You are about to update Life is Feudal: your own
echo        Dir: %Path%
echo        Branch: %BRANCH%
echo.
echo     Key "ENTER" to procede
pause
%STEAMPATH%\steamcmd.exe +login %STEAMLOGIN% +force_install_dir %Path% +"app_update %BRANCH%" validate +quit
echo .
echo     Life is Feudal: your own is now up to date
echo     key "ENTER" to exit
pause

you need to edit and adjust your paths where you have located your steamcmd and where you want to install the files etc...

User avatar
Razoreqx
 
Posts: 91
Joined: 06 Oct 2014, 13:13

Re: SERVER Admin QUESTION: Proper Server & SQL patching

Post by Razoreqx » 07 Oct 2014, 17:09

Great thank you. This covers the game files. Now I just need to find out if a script is released for any database changes. I did see a patch.sql so I'm hoping this was the last sql change made. Ive yet to hit an update for sql since I started hosting our server. I guess I'll wait and see how that goes :)


Gagi2 wrote:use steamcmd to download/install the serverfiles...

i use it for almost every server i host on my machine which is running on steam...

for making it simple i use this script
Code: Select all
@echo off

SETLOCAL ENABLEDELAYEDEXPANSION

       :: DEFINE the following variables where applicable to your install

    SET STEAMLOGIN=yoursteamloginname yoursteampassword
    SET BRANCH=320850
        :: For stable use 320850
                :: Note, the missing qotation marks, these need to be wrapped around the entire "+app_data......"

    SET Path=c:\Gameserver\LifeIsFeudal
        SET STEAMPATH=C:\Gameserver\steamcmd_win32


:: _________________________________________________________

echo.
echo     You are about to update Life is Feudal: your own
echo        Dir: %Path%
echo        Branch: %BRANCH%
echo.
echo     Key "ENTER" to procede
pause
%STEAMPATH%\steamcmd.exe +login %STEAMLOGIN% +force_install_dir %Path% +"app_update %BRANCH%" validate +quit
echo .
echo     Life is Feudal: your own is now up to date
echo     key "ENTER" to exit
pause

you need to edit and adjust your paths where you have located your steamcmd and where you want to install the files etc...
Razors Edge
A Life is Feudal Persistent World
http://razors-edge.org
22 Custom MODS / Custom Graphics models Planned. Visit our Gallery.

Return to General Discussion