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:

  1. Hover over "Customize" in Prisma and click "File Manager" to open Prisma's file manager.

  2. Open the plugins folder, then open the dynmap folder.

  3. Locate and open the configuration.txt file.

  4. Add a number sign (#) in front of the line that contains type: filetree so it looks like this: #type: filetree 

  5. Remove the number signs from the type: myql line, all the way down to the password: dynmap line 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.

Did this answer your question?