This is an automated archive.

The original was posted on /r/mysql by /u/realzunker on 2023-08-19 07:47:21+00:00.

Probably a really amateur question but I figure the fix would be quick enough that it would be worth asking about in here.

I run a Minecraft server and use mysql database stuff to sync players info across game servers. In the past I’ve used mysql databases provided by my server host that are automatically created through the click of a button. Unfortunately said databases are fairly inconsistent so I decided to pay for dedicated hosting for the databases.

My issue is that these new databases seem to be set up differently from the auto created ones by my host and don’t connect to the systems in my MC server. When I click back and forth between the two I do notice a couple differences, specifically the page that shows up when I click the databases name(xxx.x.x.x:3306) in phpMyAdmin it displays a “Database server” and a “Web server” tab that the new ones I’m hosting do not contain.

That being said I’m wondering if it’s possible to take a fresh database from my MC server host, export all of it’s settings, and then replace the stuff in the newly hosted DB so it works the same. I’ve tried the export and import options from the settings tab but they don’t seem to be working as I need.

Any kind of answer/support would be greatly appreciated. If you’re interested you can add me on Discord @ Zunker where I should be able to make it worth your time to walk me through it a little bit if necessary.