so heres the basic Guide:
Download the dedicated server off Steam in "Tools"
in the dedicated server folder theres a readme.txt open that
- Code: Select all
Installation:
1. Create as many copies of \config\world_X.xml (X - number of server instance and must be unique on one server and on one DB engine)
2. Download a MariaDB 5.5 Series Engine (https://downloads.mariadb.org/)
3. Install a MariaDB engine on the same server or somewhere in your network, where that MariaDB can be reached by your game server.
4. Use docs\my.ini as MariaDB config.
5. Copy docs\config_local.cs into root folder of server and adjust according your DB location (located in a root folder of server).
6. Launch server via "ddctd_cm_yo_server.exe -worldID X" (X - number of server instance with correctly created world_X.xml file). You can create a batch file or automate that process as you like.
So following the above steps:
Step 1 not only make copies edit the XML file its your main server Settings file. (Typically if your setting up 1 server just edit the 1 XML file to your liking)
Step 2 . Make sure you get the Stable Maria 5.5 not the new 10.x Alpha
Step 3. do it defaults are fine to use, Note the password you set for Root you will need it soon.
Step 4. the file my.ini they supply you in docs inside the dedicated server folder looks like this
- Code: Select all
[mysqld]
default_storage_engine=innodb
character-set-server=utf8
innodb_file_per_table=ON
innodb_file_format=Barracuda
innodb_flush_log_at_trx_commit=1
max_sp_recursion_depth=255
max_allowed_packet=10M
query_cache_size=0
query_cache_type=OFF
the my.ini found in your mariaDB/data folder will look something like this
- Code: Select all
[mysqld]
datadir=C:/Program Files/MariaDB 5.5/data
port=3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=1022M
innodb_log_file_size=50M
[client]
port=3306
you need to basically merge these files if you stright up replace the mariadb with the one from the dedicated server it'll crash your mysql server it'll never restart.
here is how i merged ours on the dedicated server:
- Code: Select all
[mysqld]
datadir=C:/Program Files/MariaDB 5.5/data
port=3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
character-set-server=utf8
innodb_file_per_table=ON
innodb_file_format=Barracuda
innodb_flush_log_at_trx_commit=1
max_sp_recursion_depth=255
max_allowed_packet=10M
innodb_buffer_pool_size=1022M
innodb_log_file_size=50M
query_cache_size=0
query_cache_type=OFF
[client]
port=3306
After you merge the ini files go into windows services (i assume you know how to get to your running services if your running dedicated servers) stop the service MYSQL and restart it with the new INI merged it should restart without a problem if the service errors out go back and check your my.ini file you missed soemthing.
5. copy that config into the root of your dedicated server folder edit it and insert your "Root" password you set when installing MariaDB
6. make a startserver.bat file in your dedicated server directory for 1 server it should just be a single line
- Code: Select all
ddctd_cm_yo_server.exe -worldID 1
that's it it should run it'll auto generate its own database and server will be up and running.
