Storage

PacificSMP stores each player's slot count and active Dolphin types in SQL storage. SQLite is the default and needs no separate database server. MySQL is available for servers that want a shared database.

SQLite

The default setting is storage.type: SQLITE. The database file is data.db in the PacificSMP plugin folder. Change storage.sqlite.file to use a different file name.

MySQL

Set storage.type to MYSQL, then enter the connection details in storage.mysql.

storage:
  type: MYSQL
  table-prefix: pacificsmp_
  mysql:
    host: localhost
    port: 3306
    database: minecraft
    username: root
    password: ""
    ssl: false
    pool-size: 4

Use the database host, port, name and credentials provided by your database host. Set ssl to true when the connection requires encryption. The connection pool uses at least one connection.

What is stored

Each player record contains their UUID, last known name, saved slot count and active Dolphin type ids. The table is named with the configured prefix followed by players.

Changing a player's name does not change their UUID-based record. Admin commands that clear Dolphins or set slots can look up saved players by name.

Keep player data safe

Back up the SQLite database file or your MySQL database before maintenance. /resetplugin confirm moves the settings, Dolphin definitions and language files to an archive folder. It does not reset or move player data.