mysql.sql

[fansubs]

Yo!

I need some help understanding the mysql.sql part in the server..

So.. I've downloaded many servers now without this file and i'm wondering where do i get the right one from? or can i use any mysql.sql from another server?

 

[Limos]

This should come with your server pack, same as config.lua and the data folder.
It depens on which server you are using how it's called, it can also be forgotten.sql or schema.sql.
In TFS 0.3/0.4 servers it's in the folder schemas and called mysql.sql.

You can use one from an other server if this server is similar, however, there will probable still a few problems/errors if there are differences.

 

[fansubs]

This should come with your server pack, same as config.lua and the data folder.
It depens on which server you are using how it's called, it can also be forgotten.sql or schema.sql.
In TFS 0.3/0.4 servers it's in the folder schemas and called mysql.sql.

You can use one from an other server if this server is similar, however, there will probable still a few problems/errors if there are differences.

Thank you for the fast reply!

this is how it looks in the server folderright now, no folder called schemas or any file named x.sql

http://gyazo.com/b75293665cdd8062c1b7222addaeec95

 

[Limos]

Which server version is it?

 

[fansubs]

10.76 i believe

 

[Limos]

https://otland.net/threads/how-to-see-which-server-you-are-using.230892/

 

[fansubs]

i think i just found my fault.. I'm pretty new to this server thingy so dont judge

this is what im trying to do something with: https://otland.net/threads/10-76-tfs-1-0-sources-cast-system-update-v8-1.230271/
i guess its not the server itself but a fix if im not wrong...

 

[Limos]

Here you can find the mysql schema (schema.sql) for TFS 1.0.
https://github.com/otland/forgottenserver/tree/1.0
Official release (it's also added there).
https://otland.net/threads/the-forgotten-server-1-0.223775/

 

[fansubs]

Thanks! i just uploaded the schema.sql to the database, and the config is looking like this:

mysqlHost = "127.0.0.1"
mysqlUser = "weed"
mysqlPass = "9JctCjpz2PPLs38c"
mysqlDatabase = "weed"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

The server starts loading alot of stuff and then it insta crashes, here's a pic of what i caught going on..
http://gyazo.com/6c0774124317b540885aed1718faccf3

 

[Wason]

so u have to fix it by urself

 

[Limos]

Looks like you are missing the lib file with the Storage table.

[12513] = Storage.thievesGuild.Reward,

You can change Storage.thievesGuild.Reward to 12513 or look if 051-storages.lua is added.

 

[fansubs]

mmmh, ill have to learn abit more before i do this. I'll be back!

Thanks for the help though!