[p7h3p]

Thanks again,

Very good document. You wrote it? Peter's Music library

Everything's working great and I learned a lot.

[p7h3p]

Sorry, last question

This obviously runs slower than my previous method.

I'm considering breaking down the batch into 3-4 smaller files. Would you recommend this, or?

Any Pros & Cons?

[p7h3p]

working great,

Thanks very much again

[p7h3p]

Thanks Peter,

You not only helped me out with my SQLyog troubles, but taught me a useful windows tool at the same time.

Thanks for the quotes tip too, I'll do that, but my only question is, why did you not quote Program Files, but did quote “SQLyog Enterprise”. Just an example that they both work?

[p7h3p]

Ok, sorry

I sort of answered my own question, this is my 1st time working with batch files, but I do know a bit of cmd line. a very little bit.

here's my current batch file, but I'm still having trouble

SQLyog is installed to it's default dir so my batch looks like:

cd C:Program FilesSQLyog Enterprise

sja.exe job_1.xml

sja.exe job_2.xml

…

That works for a second, opens SJA, and then gives me “Error opening session Job file”

What should I do from here, Should everything be in the same dir (SJA, batch file, and xml job files?). Can I just arbitrarily move SJA? or Copy?

[p7h3p]

Thanks for the batch file tip, I've tried it a few times, and I also searched, and viewed the FAQ before posting again, but I can't get it to work.

All I get is “SJA is not a recognized command” or something like that.

Do I have to give the full path to SJA?

Thanks

[Author]

Posts