Life is Feudal Official Forum

[Sherwood23]

Where can I find the character and world data? What files are those in specificly?

I'm trying to transfer the server I was hosting off my computer, onto my new professional host.. trying not to lose 66 hours of gameplay...

Thanks everyone!

[SaresITA89]

I follow

[Sartur]

From what I gather it's located at 'Life is Feudal Your Own\daemon\mariadb' in particular the 'data' folder.
Although I had no success yet transferring it over to a dedicated server.

[Longh]

Better to dump the db and send it to the new server.

[Sherwood23]

Probably going to end up restarting now..

[MH6]

If you have SQL access on the new server, you can easily transfer the data through an SQL client such as HeidiSQL. Otherwise you may be able to copy the database file itself.

[Nasir]

If you have SQL access on the new server, you can easily transfer the data through an SQL client such as HeidiSQL. Otherwise you may be able to copy the database file itself.

This ^

[Sartur]

In case somebody else is trying to get the database from the 'client hosted' server to a dedicated one:

(Since I'm not familiar with MySQL I might have taken a more complicated way than necessary.
Also I wasn't able to test the result extensively yet. But at a quick glance everything seemed to be at it's place.)

First of all got to 'Life is Feudal Your Own\daemon\mariadb' open the 'my.ini' and change:

Code: Select all

skip-networking=ON
into
skip-networking=OFF

Now go into the 'Life is Feudal Your Own\daemon\mariadb\bin' folder and create a batch file (e.g. pwrest.bat) with the following content:

Code: Select all

start "" "YourPath\Life is Feudal Your Own\daemon\mariadb\bin\mysqld.exe" --defaults-file="YourPath\Life is Feudal Your Own\daemon\mariadb\my.ini" --init-file="C:\mysql-init.txt" --console
pause

(You'll have to change the YourPath part to match your Steam common folder e.g. 'D:\Games\Steam\SteamApps\common\'.)
As you may have noticed a 'mysql-init.txt' is mentioned - go to your C: drive, create it with the following content:

Code: Select all

UPDATE mysql.user SET Password=PASSWORD('YourPassword') WHERE User='root';
FLUSH PRIVILEGES;

Run the batch file. It will use YourPassword as the new password this will be important in the next step.

Next create a new batch file (e.g. mysqld.bat), again in 'Life is Feudal Your Own\daemon\mariadb\bin',:

Code: Select all

start "" "YourPath\Life is Feudal Your Own\daemon\mariadb\bin\mysqld.exe" --defaults-file="YourPath\Life is Feudal Your Own\daemon\mariadb\my.ini" --console
pause

And a second one (e.g. dump.bat) in the same location:

Code: Select all

mysqldump.exe --user="root" --password="YourPassword" --databases lif_1 > lif_1.sql
pause

(If you used a different password change the YourPassword part. In case you want to dump a different world change the lif_1 part into the matching number.)

Now you'll need the 'mysqldump.exe', if you already have MariaDB installed for your dedicated server you'll find it in it's 'bin' folder.
Copy it to 'Life is Feudal Your Own\daemon\mariadb\bin'.

Run the mysqld.bat, wait until it's loaded, then run the dump.bat this will created a file called lif_1.sql.

Assuming you already have your dedicated server and MariaDB set up:
Run the server with the world you want to import, in this case world 1 and let it create a fresh database.
Once it's done shut it down and import the life_1.sql (via HeidiSQL for example) into the fresh lif_1 database the server created and you should be done.

[Saddamo]

I have found easier way, probably not the right one, but, its working 100%

If u have maria installed...

copy files from

C:\Program Files\MariaDB 5.5\data\mysql

to:

C:\Games\Steam\SteamApps\common\Life is Feudal Your Own\daemon\mariadb\data\mysql

stop mysql service with ctrl alt del

run your old singleplayer server

it will run mysql 32 bit

connect with Heidisql to database, it will have same account like new maria in c:

dump sql file

stop singleplayer server,exit game

terminate mysql 32 bit in task manager

run server mysql in services, connect to database, import dumped sql and its done

[Evg]

Tried both options, maybe did something wrong, but none of them worked for me. Does anybody has other solutions? I really don't want to start all over on dedicated server, just want to transfer current map with buildings.

[Gearknot]

In case somebody else is trying to get the database from the 'client hosted' server to a dedicated one:

(Since I'm not familiar with MySQL I might have taken a more complicated way than necessary.
Also I wasn't able to test the result extensively yet. But at a quick glance everything seemed to be at it's place.)

First of all got to 'Life is Feudal Your Own\daemon\mariadb' open the 'my.ini' and change:

Code: Select all

skip-networking=ON
into
skip-networking=OFF

Now go into the 'Life is Feudal Your Own\daemon\mariadb\bin' folder and create a batch file (e.g. pwrest.bat) with the following content:

Code: Select all

start "" "YourPath\Life is Feudal Your Own\daemon\mariadb\bin\mysqld.exe" --defaults-file="YourPath\Life is Feudal Your Own\daemon\mariadb\my.ini" --init-file="C:\mysql-init.txt" --console
pause

(You'll have to change the YourPath part to match your Steam common folder e.g. 'D:\Games\Steam\SteamApps\common\'.)
As you may have noticed a 'mysql-init.txt' is mentioned - go to your C: drive, create it with the following content:

Code: Select all

UPDATE mysql.user SET Password=PASSWORD('YourPassword') WHERE User='root';
FLUSH PRIVILEGES;

Run the batch file. It will use YourPassword as the new password this will be important in the next step.

Next create a new batch file (e.g. mysqld.bat), again in 'Life is Feudal Your Own\daemon\mariadb\bin',:

Code: Select all

start "" "YourPath\Life is Feudal Your Own\daemon\mariadb\bin\mysqld.exe" --defaults-file="YourPath\Life is Feudal Your Own\daemon\mariadb\my.ini" --console
pause

And a second one (e.g. dump.bat) in the same location:

Code: Select all

mysqldump.exe --user="root" --password="YourPassword" --databases lif_1 > lif_1.sql
pause

(If you used a different password change the YourPassword part. In case you want to dump a different world change the lif_1 part into the matching number.)

Now you'll need the 'mysqldump.exe', if you already have MariaDB installed for your dedicated server you'll find it in it's 'bin' folder.
Copy it to 'Life is Feudal Your Own\daemon\mariadb\bin'.

Run the mysqld.bat, wait until it's loaded, then run the dump.bat this will created a file called lif_1.sql.

Assuming you already have your dedicated server and MariaDB set up:
Run the server with the world you want to import, in this case world 1 and let it create a fresh database.
Once it's done shut it down and import the life_1.sql (via HeidiSQL for example) into the fresh lif_1 database the server created and you should be done.

I used this method and everything seemed to work except when i go to launch my dedicated server I get this error in the logs:

ECHO 2015-08-09 18:57:47.915 {02} <initServer> Validating database...
ERRR 2015-08-09 18:57:47.916 {02} <initServer> DB error #1305: PROCEDURE lif_3.sp_checkForeignKeys does not exist. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
WARN 2015-08-09 18:57:47.917 {02} <initServer> DB::mfRS(1 ms) CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ERRR 2015-08-09 18:57:47.918 {02} <initServer> CmServerInfoManager::_applyDbPatch() - call to sp_checkForeignKeys failed
ERRR 2015-08-09 18:57:47.918 {02} <initServer> CmServerInfoManager::processLocalWorlds() - can't access to db for world id=3
ERRR 2015-08-09 18:57:47.919 {02} <initServer> Fatal: Can't init local world (id=3). Terminating.
ECHO 2015-08-09 18:57:47.919 {00} <NOSCOPE> Engine initialized...
core/scripts/server/server.cs (78): Unable to find function destroyWorld

Would really like to get this working any help is appreciated.