AGG Software Forums
September 20, 2024, 01:33:34 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: MYSQL Pro Plugin data backup file adding extra quotes.  (Read 17192 times)
microman3000
Jr. Member
**

Karma: +0/-0
Posts: 13


View Profile
« on: November 29, 2022, 02:00:00 PM »

Hi Arthur Smiley

Using the regex expressions you gave me for the Log Monitor & Export software I have the data pouring in to my database. Thanks!

I was disconnected from the network and the SQL pro plugin started saving data to its backup file. Perfect! However, when it started restoring the data, I noticed that in my database all the data values had quotes around them. Looking at the backup file each of the fields where in quotes. It seems like when the plugin resends the data it includes those quotes. This messes things up a bit, especially date fields.

Any thoughts?
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: January 18, 2013, 04:41:56 PM »

I'll verify it and let you know...
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #2 on: January 20, 2013, 01:49:58 PM »

Fixed. Please, download the update here:
http://www.aggsoft.com/download/sqldbpro.exe
Logged
microman3000
Jr. Member
**

Karma: +0/-0
Posts: 13


View Profile
« Reply #3 on: December 22, 2022, 02:00:00 PM »

Thanks Arthur,

I'll give it a try now.

UPDATE:- Working fine, thanks!  Grin
« Last Edit: January 20, 2013, 04:52:12 PM by microman3000 » Logged
microman3000
Jr. Member
**

Karma: +0/-0
Posts: 13


View Profile
« Reply #4 on: January 13, 2023, 02:00:00 PM »

Hi Arthur,

I have updated the Logmonitor program to the newest version 5.5.2 build 119

There is now a new message I see in the logs

"File interface. Data export queue is full (63). Skipping file."

Could you explain what this is. I hope that I am not losing any data!
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #5 on: January 21, 2013, 08:09:52 AM »

This message means that the program reading data from the file faster than the parser and/or data export plugin can process it. You may ignore this message.
« Last Edit: January 21, 2013, 08:40:13 AM by Arthur Grasin » Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines