#How to clear old map from SQL database?

1 messages · Page 1 of 1 (latest)

unkempt grail
#

This may be an elementary question, but I’m hoping this helps someone else who has the same issue as me in the future and that I can come back to this thread when I inevitably have to clear an old map out of my database to make room for a new one.

How can I clear all tiles from my SQL database while maintaining the permissions I’ve set up for the Dynmap user? Is it a simple drop tables command?

timber minnowBOT
#

Thank you! Please provide any errors you are experiencing and upload your configuration.txt. Someone from our <@&801354402010628138> team will respond to help shortly. As a general reminder, everyone on our support team is a volunteer, please be kind!

unkempt grail
#

If I need to upload my configuration file, then I will, but it probably isn’t needed for this request

craggy girder
#

Truncating should do what you want.
Example:

TRUNCATE TABLE tiles;
unkempt grail
#

Oh perfect thank you. I’ll try this later tonight and update if it works!

craggy girder
#

Alright.

unkempt grail
#

Totally wasn’t expecting such a fast reply lol thanks again

craggy girder
#

You are welcome. 🤗

unkempt grail
#

Forgot to update but this worked!!

#

Closing the thread now

#

(How do I close lol)