Trying to use the DB Synchro Wizard

This topic is empty.

Viewing 8 reply threads

Author

Posts
- October 20, 2003 at 9:54 pm #8208
  
  ianblackford
  Member
  
  Hi,
  
  I'm evaluating the latest realease and my major need is to be able to schedule a DB synchronise between two databases.
  
  What I have done is this, I have MySQL installed on my PC and I have created a db and a duplicate db in it. I have then enabled the table and all the fields in the permisions tab with a username and password, but when I run the wizzard and save the resulting schedule it doesn't do it. I get something momentarily flash on the screen at the alloted time but no snchro.
  
  Anybody got any ideas what I am doing wrong?
  
  TIA
  
  Ian
- October 21, 2003 at 3:40 am #15119
  
  Ritesh
  Member
  
  Pls. send us the contents of the sja.log file created in the SQLyog installation folder.
- October 21, 2003 at 4:36 am #15120
  
  Ritesh
  Member
  
  Quote:
  
  save the resulting schedule
  
  BTW, are you just saving the schedule in a XML file or running the scheduler?
  
  You have to select “RUN IMMEDIATELY…” in the wizard.
- October 21, 2003 at 7:24 am #15121
  
  ianblackford
  Member
  
  Ritesh wrote on Oct 21 2003, 03:40 AM:
  
  Pls. send us the contents of the sja.log file created in the SQLyog installation folder.
  
  Will do!
- October 21, 2003 at 7:32 am #15122
  
  ianblackford
  Member
  
  Ritesh wrote on Oct 21 2003, 04:36 AM:
  
  Quote:
  
  save the resulting schedule
  
  BTW, are you just saving the schedule in a XML file or running the scheduler?
  
  You have to select “RUN IMMEDIATELY…” in the wizard.
  
  I'm using the option to 'Save and Schedule it' This creates the XML file and takes me to the Scheduler to specify the time I want it to run.
  
  Why should I select run Immediately?
- October 21, 2003 at 8:27 am #15123
  
  Ritesh
  Member
  
  I thought you were just saving the XML file. What you are doing is correct. Absolutely no issues with that!!!!
- November 17, 2003 at 11:32 pm #15124
  
  qstoodley
  Member
  
  I too had this problem initially. When I went to the command prompt and ran it manually it wasn't finding the XML file. The problem was that I had spaces in the file and directory names.
  
  Putting double quotes around the full path of the XML file (the same way it is done for the EXE file” should fix your problem.
  
  Regards,
  
  Quent.
  
  Concorde Computers
- November 20, 2003 at 5:42 am #15125
  
  jayson_13
  Member
  
  HI,
  
  I am using the sync tools also. But the schdeled task did not start as expected. Below is the configuration of my scheduled task.
  
  Run : “C:Program FilesSQLyogsja.exe” C:bk.xml
  
  Start in : “C:Program FilesSQLyog”
  
  the xml file is located in c drive . C:bk.xml
  
  i even try to put like this Run : “C:Program FilesSQLyogsja.exe” “C:bk.xml” but still it did not start.
  
  the sja file didn't tell me everything.
  
  I am running on Win XP + MySQL 4.0.13 + sqlyog 3.62
- November 20, 2003 at 9:25 am #15126
  
  Ritesh
  Member
  
  Are you able to schedule any other software using the Task Scheduler? Just try running it from the command line once.
  
  Make sure that you are giving correct details in the task scheduler.
Author

Posts