OOTP & MySQL DB

[mjkuhlen]

Hey all, I've been working on a discord bot that brings some data from OOTP to discord for my online franchise. While I've been exporting SQL dump files from the Automator Panel, i noticed that on the Database panel in Game Settings there's an option to "Export data directly into a MySQL Database" this seems preferable to my setup but I can't quite seem to get it to work. I know the hostname, I know the port and database name but providing those doesn't seem to initiate a connection or transfer any data.

Has anyone had any luck working with this, or if someone from the OOTP teams sees this would you mind providing some insight? Thanks!

[mjkuhlen]

Well I see that it attempts to start but will generate these errors in the log:
2023-08-22 19:00:19 write_to_mysql: Error, could not connect to MySQL database
2023-08-22 19:00:19 write_to_mysql: Error, no connection to MySQL database

[Syd Thrift]

I've never been able to get the game to connect directly to my MySQL instance and load the data in directly. Instead I have it generate the scripts and then run them. They are of course very very large but MySQL seems to do OK with them. The one thing I do do with those is I run the command line prompt to concatenate all the files in the directory to one giant SQL script:

https://superuser.com/questions/1118...multiple-files

I don't think Windows will try to write the file into itself if you tell it to write all files ending in *.sql into my-db.sql but just to be on the safe side I have it write to like my-db.txt and then manually change the extension. Again, the file is pretty huge, like 50 megs or more, but MySQL consumes it just fine (it'll take forever to load if you try to open it in that or any other text editor though).

[mjkuhlen]

Thanks for the tip Syd. I am communicating with one of the team members via discord, they are speaking with the devs for me. Lets get this resolved! lol. One issue we've noticed is that window isn't correctly sized, so it's not showing the username/password field properly (without scrolling). But, even after adding that, I get an error that it can't connect to my db. I've double checked all of my settings and that connection works via other apps (mysql workbench) so I know I'm fairly confident it's not that.