Export to Database Module

[fhserver]

hi,

Can you tell me, the correct way to configure the database.

“Configure connection” Is this configuration referring to the database of rapid scada? If so, what are the default credentials?

Config server Mysql

Query Sql

Tables DB

I can not copy the data, to the external DB Mysql.

[Mikhail]

Hi,

Connection settings on the 1st image are not related to database. Don’t mind about them.

You should find ModDBExport.log and ModDBExport.txt in C:\SCADA\ScadaServer\Log and check the error details.

[fhserver]

Apparently I have problems with the MYSQL database.

Thank you very much for the help !!

I’ll tell you as soon as I solve it

[Mikhail]

May be you should change cnlmun to cnlnum in the INSERT request.

[fhserver]

Thank you ! , layer 8 error (between the chair and the keyboard).

xº

Log.

[Mikhail]

Is the “duplicate entry” error critical in your situation or can be ignored?

[fhserver]

Disable PK, I have not had any more problems

<br />

Log.

<br />

• This reply was modified 1 year, 9 months ago by fhserver.

[Mikhail]

This is a bad practice, because records still duplicated, but without error.
Somewhere in this forum or https://forum.rapidscada.ru/, a solution how to skip inserting duplicated records.

[fhserver]

Apparently this was solved

SQL

https://i.ibb.co/6ypdsjG/sql.png

Table

https://i.ibb.co/YdqGZ9V/key.png

Log

https://i.ibb.co/bJRnYzY/log.png

• This reply was modified 1 year, 9 months ago by fhserver.
• This reply was modified 1 year, 9 months ago by Mikhail.

[Mikhail]

On my PC images are not available. Could you check them?

[Author]

Posts