Database
There are 4 available database providers:
PostgreSQL: Recommended for advanced & big servers.
MySQL: Recommended for advanced & big servers.
SQLite: Used for small servers.
YAML: Used for small servers.
If your server has more than 100 active players per day, please use PostgreSQL or MySQL.
Warning: If you selected PostgreSQL or MySQL, please create a new database (for PostgreSQL) or a new schema (for MySQL) under the name: "homestead_data"
The picture below is for MySQL, using MySQL Workbench 8.0 CE.
Migrating Data to another provider
Prepare your new provider's details (username, password...) in the config.yml file.
Save the changes and reload the configuration via the command:
/hsadmin reload
Migrate the current data to the new provider using the command:
/hsadmin migratedata [provider]
Turn off your server, and change the provider to the provider you migrated to earlier in config.yml. Remember to save the changes!
Start the server.
You're good to go!
Caution: RELOADING THE PLUGIN INSTEAD OF SHUTTING DOWN AND RESTARTING THE SERVER WILL CAUSE CORRUPTION OF ALL DATA. PLEASE BE CAREFUL.
# How would you like to store regions data?
# Available database providers:
# - PostgreSQL: postgresql (Recommended for advanced servers)
# - MySQL: mysql (Recommended for advanced servers)
# - SQLite: sqlite (Recommended for small servers)
# - YAML: yaml
# WARNING 1: If you selected PostgreSQL or MySQL, please create a new database (postgre) or a new chema (mysql) with the name: "homestead_data"
# WARNING 2: PostgreSQL JDBC Driver is bundled within the plugin's dependencies! There is no need to download the driver and load it in the server's libraries.
database:
provider: "sqlite"
# PostgreSQL configuration:
postgresql:
username: "USERNAME"
password: "PASSWORD"
host: "localhost"
port: 3306
# MySQL configuration:
mysql:
username: "USERNAME"
password: "PASSWORD"
host: "localhost"
port: 3306
# SQLite configuration:
# NOTE: The data file will be saved in the server's main directory.
sqlite: "homestead_data.db"
Last updated