OOTP Developments Forums - View Single Post - Has anyone gotten Export Directly to MySQL Working?

NoOne · 03-16-2018, 07:26 PM

the exported file should crete tables and add data...

isn't it just a massive sql statement? or is it some proprietery thing?

instead try to use create sql dump for mysql...

access can use that too. or d/l hiedisql (free) and then run that in a query tab.. *** make sure it's creating tables and such within a dB, or oyu have to create a dB first, then run teh sql command. all that info will be at top of sql query

can copy/paste or load from file (name.sql) etc..

*** i have never tried to do this, for the record.. .but took a class 20 years ago and also do similar stuff with an eqemu dB.. so not just theory.

03-16-2018, 07:26 PM	#7
NoOne Banned Join Date: Apr 2015 Posts: 7,273 Infractions: 1/2 (4)	the exported file should crete tables and add data... isn't it just a massive sql statement? or is it some proprietery thing? instead try to use create sql dump for mysql... access can use that too. or d/l hiedisql (free) and then run that in a query tab.. * make sure it's creating tables and such within a dB, or oyu have to create a dB first, then run teh sql command. all that info will be at top of sql query can copy/paste or load from file (name.sql) etc.. * i have never tried to do this, for the record.. .but took a class 20 years ago and also do similar stuff with an eqemu dB.. so not just theory. Last edited by NoOne; 03-16-2018 at 07:28 PM.