What is MySQL and why use it?
MySQL is an alternate storage method used by certain plugins (like Dynmap and CoreProtect) that need to store large amounts of data. Using MySQL allows you to separate this task from your own server and improve performance.
Creating your MySQL Database
If you haven't yet created a MySQL database for your server, you'll need to create one by hovering over "Advanced" in Prisma and clicking "MySQL Database". Once you've done this, you should see the following popup.
To create your server's MySQL database, all you have to do is click the "Create Database" button and one will be generated for you automatically. Once the database has been generated, you should see all of the information needed to login to the MySQL server.
Configuring Dynmap to use MySQL
Before you'll be able to configure Dynmap, you'll need to have already installed and started the server with Dynmap installed at least once so all of the configuration files can generate. If you haven't already downloaded Dynmap, you can download the Paper/Spigot/Bukkit version here and you can find our guide on how to install it here. Once you've done this, you can follow the steps below to configure Dynmap to use MySQL:
- Hover over "Customize" in Prisma and click "File Manager" to open Prisma's file manager.
- Open the
pluginsfolder, then open the
- Locate and open the
- Add a number sign (
#) in front of the line that contains
type: filetreeso it looks like this:
- Remove the number signs from the
type: myqlline, all the way down to the
password: dynmapline like so:
6. Copy and paste your MySQL information from the "Advanced" -> "MySQL Database" into their respective fields and save the changes.
7. Restart your server. Dynmap should connect to the MySQL server and automatically generate any necessary tables. If you don't see any error messages in the console, you should be good to go!
How do I create another database?
We only offer one MySQL database per server, but plugins can create additional tables on the same database so they will not interfere with each other. If you do plan to connect multiple plugins to MySQL, we recommend setting a prefix to avoid duplicate tables.
I'm lost... Help?
We're always happy to help. Please reach out to us at any time through the blue button found in the bottom-right of our website and let us know what troubles you're having.