Upgrade To 5.1

[shawn_h]

Hello everyone,

When upgrading from version to version (in my case to the latest version 5.1), I've the problem of leaving the jobs that I had defined and scheduled in the previous version where they were before.

Is there an automated way of bringing these jobs (and there is more than 50 of them) or importing these jobs to the new version without breaking anything?

Thanks.

[Ritesh]

Great to meet you at the MySQL UC.

I dont think you will need to transfer any of the job. The jobs are scheduled using Windows Task Scheduler and the next version should get it. Is it not happening in your case?

[peterlaursen]

If you installed to the same folder I don't think either it willl be necessary to do anything.

If you installed to another folder you can open each job in Task Scheduler and edit properties (change the path)

[shawn_h]

Thanks Ritesh. It was great to talk to you guys as well for me. Too bad Peter couldn't make it. He's helped me along the way.

I haven't installed the new version just yet; however, if as you guys are saying, I install to the same folder, the new version will take over all the jobs and schedules from the old version. Am I correct in assuming this?

Thanks,

Shawn H.

[peterlaursen]

Yes .. you are correct!

If you open 'Scheduled Tasks', right-click one and choose 'properties' it could look somewhat like

“C:ProgrammerSQLyog Enterprisesja.exe” “C:ProgrammerSQLyog Enterpriseblabla.xml” -l”C:ProgrammerSQLyog Enterprisesja.log” -s”C:ProgrammerSQLyog Enterprisesjasession.xml”

This is simply the command-line that the Windows Scheduler executes. There is no change in that with 5.1.x

However .. in this special situation (with the reported 5.11 crashing bug) I would start making a copy of the SQLyog installation folder (if you do not have a back-up allready). Also I would use 5.12 beta 3 and not 5.11.

[shawn_h]

Interesting! Thanks for the tip on the beta version; I'll try this link http://www.webyog.com/betas/SQLyog512Ent.exe to download it. Is this beta 3 though?

[Ritesh]

Nope.

It has become BETA 4 from yesterday.

[shawn_h]

Great! So then, I'll just use beta 4 instead!

[shawn_h]

question: i had a bunch of bat files that run several jobs each. i copied these bat files together with their respective jobs files (xml files) to the new jobs folder (under the new beta version i'd just installed) but none of these are showing up in my job manager!!!!

is that by design or should any job that is in that folder (jobs folder) show up automatically???

thanks.

[peterlaursen]

Hi ..

I understand that you installed the BETA to another folder than where 5.02 was installed?

Then the path to all files in the Windows Task Scheduler is wrong.

Did you copy the sqlyog. ini file too?

But I actually do not know precisely from where the *Job Manager* reads its data.

[shawn_h]

that's correct. I installed the new version over my 4.x version where I had so many jobs scheduled within bat files.

i didn't manually copy the ini file. i assume that it used the one from 4.x install. but i could be wrong. ritesh, feel free to jump in any time.

[peterlaursen]

Quote:

i didn't manually copy the ini file. i assume that it used the one from 4.x install

Your assumption is (or at least should be) correct!

Now I don't understand the problem exactly!? Did you have scheduled jobs using files in the 4.1 installation folder (or a subfolder to it)? And those job do no run anymore or have disappeared from SQLyog 'Job Manager' or …? If yes, are the files still there? Are the jobs still to be seen in 'Task Manager'?

… I can hide away if you want …

[shawn_h]

No, you don't have to hide away! 😀

here's what my situation was (as I believe it's now in good order). I had started with version 4.x and then installed 5.x separately to another folder. not only that, but i had a couple of other versions installed all on separate folders. only in two of these install, i had jobs running nightly. one of them was a version 4.x install (my original installation) where i had a bunch of .bat files running jobs one after the other in a specific order. the other installation was a version 5.x where i had another bunch of files but not in .bat files but just regularly scheduled jobs. these later jobs, showed up immediately when i installed the new version (beta) over my old version 5.x folder (as you've noted and i'd mentioned earlier); however, when i copied over the version 4.x jobs (the ones that are called by windows .bat files), they didn't show up in the job manager, neither the .bat files nor the actual xml jobs files showed up.

so i decided to leave it alone for now and just change the paths of my individual jobs within the .bat files. so for example, i had something like this:

“D:Program FilesSQLyog Enterprise 5.01sja.exe” “D:Program FilesSQLyog Enterprise 5.01Job Filesmy_job.xml”

changed to a more generic format/path:

“D:Program FilesSQLyog Enterprisesja.exe” “D:Program FilesSQLyog EnterpriseJob Filesmy_job.xml”

the windows scheduler, calls the .bat files (as you'd thought me to do several months ago) and the .bat files have reference to the (now newly installed and beta) sja executable.

hope this clarifies my incomplete explanations from before.

[Author]

Posts