# Database

# 1 Database

KingdomCraft by default saves all data in the **database.h2.mv.db** file.


:::tip
Make sure to **backup** your server regularly to avoid losing data in case of a crash.

:::

## 1.1 Remove player data

You can clear and reset all player data with the following command.

| /k playerdata clear | kingdom.playerdata.clear |
|---------------------|--------------------------|

# 2 Database engines

You can choose to use a dedicated database like MySQL or PostgreSQL. This is very advanced and is only recommended if you know what you are doing.


:::warning
**NB.** You **cannot** use the same database for both KingdomCraft Starter and Premium. This requires 2 separate databases.

:::

## 2.1 MySQL

You can add more parameters to the url if necessary. [More info](https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html).

```yaml
database:
  driver: 'com.mysql.jdbc.Driver'
  url: 'jdbc:mysql://{host}:{port}/{database}'
  username: 'user'
  password: 'pass'
```

## 2.2 PostgreSQL

You can add more parameters to the url if necessary. [More info](https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING).

```yaml
database:
  driver: 'org.postgresql.Driver'
  url: 'jdbc:postgresql://{host}:{port}/{database}'
  username: 'user'
  password: 'pass'
```

## 2.3 H2

Just save all data in the plugin directory. **(default)**

```yaml
database:
  driver: 'org.h2.Driver'
  url: 'jdbc:h2:file:./plugins/KingdomCraft/database.h2'
  username: 'user'
  password: ''
```

---

**Documents**

- [Getting started](https://wiki.guflimc.com/s/kingdomcraft/doc/getting-started-D6nO7R93ys)
- [Configuration](https://wiki.guflimc.com/s/kingdomcraft/doc/configuration-DMcGaWt85O)
- [Kingdom setup](https://wiki.guflimc.com/s/kingdomcraft/doc/kingdom-setup-ZDcgXrOKXu)
- [Ranks setup](https://wiki.guflimc.com/s/kingdomcraft/doc/ranks-setup-8ZxHwOcwuN)
- [Players guide](https://wiki.guflimc.com/s/kingdomcraft/doc/players-guide-52cG3r3F9w)
- [Chat system](https://wiki.guflimc.com/s/kingdomcraft/doc/chat-system-BI5h4CO5nK)
- [Relations](https://wiki.guflimc.com/s/kingdomcraft/doc/relations-DWqWWHEum8)
- [Admin mode](https://wiki.guflimc.com/s/kingdomcraft/doc/admin-mode-XiPDZwgCU9)
- [Translations](https://wiki.guflimc.com/s/kingdomcraft/doc/translations-P1RH2hwYjp)
- [Rank permissions](https://wiki.guflimc.com/s/kingdomcraft/doc/rank-permissions-pJn6oSjLYI)
- [All permissions](https://wiki.guflimc.com/s/kingdomcraft/doc/all-permissions-abZLW9OAkb)
- [Database](https://wiki.guflimc.com/s/kingdomcraft/doc/database-XlNdVs86Jz)