Using MySQL¶
A MySQL database is recommended for improved performance and allowing you to have ticket transcripts/archives. SQLite is too slow to support storing messages.
Edit .env
¶
- Set
DB_TYPE
tomysql
- Set the
DB_HOST
to the IP or hostname of your MySQL server - If your MySQL server is not running on the default port, also set the
DB_PORT
- Set the name of your database as
DB_NAME
- Set the username of your database user as
DB_USER
- Set the password of your database user as
DB_PASS
Install mysql2
¶
Standard and docker installations¶
1 |
|
Pterodactyl installations¶
If you are using the Discord Tickets egg, add mysql2
to the "Plugins" field in your server settings.
If you are using a generic egg, add mysql2
to the additional node/npm packages field.
Info
You can also try using maria
, postgres
, or microsoft
, however only sqlite
and mysql
are officially supported. You are much more likely to encounter issues regarding the database if you use one of these unsupported databases.
Last update:
October 11, 2021
This website supports keyboard
shortcuts