[maxhugen]

I can’t see any way to reproduce this. It appears to be intermittent, but I haven’t been able to figure out why it sometimes happens. Curiously, Ctrl+Shift+R still works even when Ctrl+Shift+C doesn’t.

Ctrl+Shift+C seems to resume after a while (or the next day), but can’t determine why.

[maxhugen]

I’m getting the warning too.

[maxhugen]

MySQL does store comments for Stored Procs. I checked information_schema > ROUTINES, and the comments appear in the ROUTINE_DEFINITION column. They also appear using SHOW CREATE PROCEDURE .

 

I tried altering a Stored Proc using “#, “– ” and “/* … */”, they all saved OK.

 

However, I have tried again using Ctrl+Shift+C, and this time the section I commented was saved when I ran the ALTER Stored Proc, so I believe it was my error when I first tried it.

 

Topic closed, I think.

 

Thanks.

[maxhugen]

Yes, using ‘#’ in a Stored Proc is saved.

[maxhugen]

Hi Peter

 

Understand what you’re saying.

 

Gotta say though, whilst almost every IT pro I know, or have read online, sneers at the mention of MS Access, it’s still KING of RAD. It’s more than 20 years now since Access could parse SQL into it’s QBE!

 

Cheers, Max

[maxhugen]

When I’m syncing the schema, there are no other jobs/scripts running.

 

I haven’t seen this error occur if I sync just one other db, only if I do several syncs sequentially with the Sync Tool window left open, and it’s never the first sync.

 

The sequence would generally be something like:

 

1. (Dev) cams_kpn > (Dev) cams_stf

2. (Dev) cams_kpn > (server) cams_kpn

3. (Dev) cams_kpn > (server) cams_stf         < this is where the error occurs

 

I can’t “reproduce” the error either, as the majority of the time when I do this sequence, it’s AOK.

[maxhugen]

I have prepared a Schema dump for the database – I’m not permitted to supply the data as well.

 

There are 2 databases, for 2 clients, on separate servers. They are `cams_kpn` and `cams_stf`. The schemas are identical.

 

The targets are identical dbs on my own machine.

[maxhugen]

Unfortunately, I was not able to determine the cause of the issue.  🙁

[maxhugen]

Couldn’t get permission to provide read access to the db. It’s for a $billion hospital construction project, with a lot of confidential contractor info.

 

However, I was finally able to sync the table with the issue, and now the SQLyog Job Agent is running AOK again.

[maxhugen]

I’m checking with the client re access, will advise.

[maxhugen]

Not that I’m aware of. No-one was logged in, and I tried it a number of times.

[maxhugen]

No worries, thanks anyway Peter.

[maxhugen]

Hi Peter, the link is returning a 404 error.

 

Where is the wizard to create a batch job for Schema Synchronization?

[maxhugen]

Hi Kartik, thanks for the advice! Most appreciated.

 

Cheers, Max

[maxhugen]

All good now, thanks!

[Author]

Posts