Citect V 5.21 and MySQL 0.9.4 beta.

rahilansari

Member
Join Date
Jul 2008
Location
INDIA
Posts
103
Hi all,

I have a Citect SCADA V 5.21 and MySQL 0.9.4 beta installed on my Server (Windows Server 2003). All process events are logging in a data base file with an extension events.MYD. Everything was working fine but since last 2 weeks events are not looging into that file and I can only see the events occur before 2 weeks. I am not expert on MySQL and don't know how to fix this. I have restarted the system, compiled the Citect projects and run but still same condition. Can anyone guide me if we assume the problem is from MySQL then how should I fix this.

Any type of support is highly appreciable.
Thanks
Rahil
 
Hi, Thanks for your reply.

The system logged the events of 1 year then reset. However if the size is too large what should I do to fix it? Do I need to copy the events.MYD file and delete from that directory and system will regenerate it again? or do I need to follow some specific procedure or use some tools? please advise.
 
Hi, Thanks for the reply. while doing this do I need to Shutdown the runtime of my Citect SCADA? By above method am I deleting the complete file or just contents of the file?
 
Hi Sigmadelta,

As per your suggestion I tried but couldn't find an option to open command line in MySQL to write that command. However I am able to find MySQL query. I have gone through manuals and internet documents but not sure. Can you please guide me in a little more depth. Also I want to inform you that I have events.MYD file from my old ghost backup so if I copy and replace directly from the directory then will it work fine because its size is around 1 GB. Please advise.
 
If that's the case then you could do this, but you should stop Citect Runtime.

1) Stop Citect Runtime
2) Copy your current events.myd to a backup location
3) In a query window do this:

USE mstw_db
DELETE from events


4) Start Citect Runtime

Then you should have an empty events.myd to work with. The file size might remain the same, but it should be able to write data again since it should overwrite information instead of adding new information.

Alternatively, you could to this for Step 3:
3) copy your backup events.myd from your ghost backup, and run this in the query window, to start with a file size of 1GB instead of 4GB:

USE mstw_db
DELETE from events


What is the file format of your hard disk? FAT32 or NTFS? In FAT32, the maximum file size is 4GB. This could be your problem. NTFS file system does not have this limitation.
 
Last edited:
Ok, I will copy the current events.MYD file from directory then write this command. So basically my understandin is my events.MYD file will reset to zero bytes and start logging the events again from that point of time. If yes then it is okay for me because I have the backup file with me to see my old events in future I required.
 
Hi sigmadelta,

I am trying to execute delete query but it fails with an error. do I need to change something in preferences? please advise
 

Similar Topics

Hello Everyone I working in power plant and we using citect 7.20 , how we can connect citect to mysql to show some system info on website or...
Replies
1
Views
1,469
Hello All ! I am new with Citect. I saved Log Messages in Excel File where I set a directory in Devices. I want to save this records to MYSQL...
Replies
0
Views
2,358
Hello, I have a running project on Citect v5.42 and simatic net v6.4 I have created a new spare PC and loaded all software like Citect, station...
Replies
0
Views
57
Hello everyone, In a factory where we installed Citect 7.20 the computer began to show the first signs of end of life. They never considered...
Replies
0
Views
57
I have a running backup of Citect and plc and I want to make a spare PC station so I have installed the win XP and somatic net v6.0 and import the...
Replies
3
Views
107
Back
Top Bottom