> For the complete documentation index, see [llms.txt](https://wiki.incredibleplugins.com/upgradeablespawners/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://wiki.incredibleplugins.com/upgradeablespawners/setup/database.md).

# Database

## Database

UpgradeableSpawners stores placed spawners and player data in a database.

By default, it uses SQLite. You can enable MySQL in `config.yml` if you want a shared external database.

## SQLite

SQLite is the default file-based database. It is the simplest option for single-server setups.

Before updating or migrating, stop the server and back up the plugin folder.

## MySQL

To use MySQL:

1. Stop the server.
2. Configure the `database.mysql` section in `config.yml`.
3. Set MySQL to enabled.
4. Start the server.

Make sure the database, username, password, host, and port are correct before starting the server.

## Migrating Data

Use `/spawners admin migratedb mysql` to copy the current data to MySQL.

Use `/spawners admin migratedb sqlite` to copy the current data back to SQLite.

After migration, enable the target database type in `config.yml` and restart the server.

Always make a backup before migrating.