Thread: OOTP & MySQL DB
View Single Post
Old 08-23-2023, 04:42 PM   #3
Syd Thrift
Hall Of Famer
 
Syd Thrift's Avatar
 
Join Date: May 2004
Posts: 10,606
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).
__________________
Quote:
Originally Posted by Markus Heinsohn
You bastard....
The Great American Baseball Thrift Book - Like reading the Sporting News from back in the day, only with fake players. REAL LIFE DRAMA THOUGH maybe not

Last edited by Syd Thrift; 08-23-2023 at 04:46 PM.
Syd Thrift is offline   Reply With Quote