openLCA archived user forum

Sorry Michael I will write you. Cheers

Hi Michael,

The remote database function does not create a new databases on the MySQL server but just stores the connection data to such databases. Thus, you first have to create the MySQL database outside of openLCA with the following database script: https://github.com/GreenDelta/olca-modu ... _mysql.sql. Just uncomment the ‘create database …’ statements and replace the database name 'openlca' with the name you want to use for your database and execute this script in a query browser.

Hope this helps,
Michael

Hi Michael S,

Thanks for the help. To be sure, you are referring to Line 9 when you say change the database name? And what is meant by "uncomment the create database statement?" I don't see any quotation marks or special characters surrounding that information in Line 9, but maybe you meant something else?

Best,

Michael T

Hi Michael T,
uncoment means: remove the comment character so that the line is used in the script and not considered as a comment any more. For more details can you please consider a service contract? Thank you very much.
Best wishes,
Andreas

Hi Andreas,

No problem, we will be in contact about the service contract.

Best,

Michael