[Alistair Moffatt]

Your reply is valid where you are talking about live databases, but what about test environments.

The scripting ability would be really useful in test environments, as it would allow the easy creation of test databases without the need to dump out the complete database every time.

For example, I could have a database with base level data and then a series of scripts to bring the database up to different known states.

Does this make sense?

Alistair

[Alistair Moffatt]

Peter

Any reason why script generation could not be added as a feature?

Alistair

[Alistair Moffatt]

adarsh wrote on May 9 2007, 12:45 PM:

Hello,

Thanks for reporting.

We have fixed the issue for you and you can download the not release version from the following link:

http://www.webyog.com/downloads/betas/not_…531EntTrial.exe

Try this and let us know the details.

Thanks

Adarsh

The fix seems to work just fine.

Thanks for taking the time to track this down and to fix it at such short notice.

Alistair

[Alistair Moffatt]

peterlaursen wrote on May 4 2007, 09:13 PM:

we need more info!

1) Can you tell if this happens with the first row of data or later?  this is important because it will give a hint if this is dataspecific or not.

2) SQLyog version and MySQL version.  

3) can you attach the jobfile, please.  A dump with a few rows on each host to reprouce with would be nice too!

1) First row of data as far as I can tell. If I examine the target table after the sync, no data appears to have been transferred.

2) SQLyog v5.30 and MySQL 4.1.22-community-nt

3) job file and a cut-down version of the source and target tables (as dumps) attached.

Thanks for your help.

Alistair

[Author]

Posts