synchronization question

[chuck]

Ok,

I've been hosting a site using coldfusion and mysql / sqlyog for about three years now. Everything works perfect and I couldent be happer. Recently we found the need for out client to be able to work off-line (because of connectivity and speed issues) and synchronize when they have the chance to dial up. So what I did was put together a laptop running a coldfusion server, mysql, sqlyog, apache and all of the sites web files. By doing this we are able to work on the site, input all the info. we need to while being offline. My questions is how do I enable the user to synchronize without ever opening sqlyog or going through the trouble of running a service? I would perfer to have the user click a link on the “off-line” site that says “synchronize” (maybe run a batch file) and have it run the job agent but I'm unsure of how to do this. Any info. would be much appricated.

Thanks in advance,

-Chuck

[Ritesh]

http://www.webyog.com/forums/index.php?act…=ST&f=10&t=1329

Hope this helps.

[chuck]

I'm running sqlyog Enterprise. I have already made the XML files using the sja wizard. Where does the sja reside so that I can run it without having to open sqlyog and can this be run from the click of a link?

[Ritesh]

sja.exe resides in the installation folder of SQLyog Enterprise.

I dont know about ColdFusion but from PHP you can use:

Code:

system (“sja.exe schema.xml”)

More information on system function can be found at: http://in.php.net/system

[peterlaursen]

that's simple ….

sja.exe is a stand-alone application (though it can be started from within Sqlyog). So just write a simple .bat file calling sja.exe with the XML-file for the syncronisation job as a parameter, and create at icon on the deskotp ponting to that .. .bat file. sja.exe is in your sqlyog installation directory.

From the Sqlyog helpfile:

“SJA can also be used as a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog. If you use SQLyog to create your job files, you don't need to have any knowledge about XML or the Job Definition schema.” I would add the that you can let the wizard in sqlyog build the job file and save it instead of executing it.

The syntax is simply 'sja.exe Y/N job.xml'

Y og N means Yes or No to “abort on error”. But 1st parameter can be omitted.

[peterlaursen]

I just want to add that is acceptable that I'm one minute later than Ritesh, since I wrote so many more words …

[Ritesh]

Quote:

The syntax is simply 'sja.exe Y/N job.xml'

We dont have Y/N as parameter. Option to specify Yes or No to “abort on error” needs to be provided in the XML schema itself.

[Ritesh]

peterlaursen wrote on May 10 2005, 01:41 PM:

I just want to add that is acceptable that I'm one minute later than Ritesh, since I wrote so many more words …

😀 😀

[chuck]

Thanks. Works perfect!

[peterlaursen]

OK ritesh.

However 'sja.exe Y job.xml' and 'sja.exe Y job.xml' both execute perfectly her with 4.0 RC (never could afford bying a newer!)

When the helpfile says “.. that accepts a Job Definition file encoded in XML as one of the parameters.” – what are then the parameterSSSSSSSSSS ??? 😛

Or has it just changed since then ?

[peterlaursen]

correction

however 'sja.exe Y job.xml' and 'sja.exe Y job.xml' both execute perfectly …

>>>

owever 'sja.exe Y job.xml' and 'sja.exe N job.xml' both execute perfectly

[Author]

Posts