forums › forums › SQLyog › Using SQLyog › Jobs Don't Remember Connection And Database
- This topic is empty.
-
AuthorPosts
-
-
April 30, 2011 at 2:38 am #12320Purple EdgeParticipant
I create a new job and save it.
When I go to edit the saved job I have to re-enter the connection and database to use – is it meant to be this way, it creates doubts for me that the schedule will actually know what it is meant to be backing up?
-
April 30, 2011 at 8:11 am #32207peterlaursenParticipant
Also please tell the program (SQLyog) version.
-
May 1, 2011 at 6:49 am #32208Purple EdgeParticipant
Ultimate v9.02
-
May 1, 2011 at 7:41 am #32209peterlaursenParticipant
OK .. we will check this tomorrow.
-
May 2, 2011 at 7:44 am #32210peterlaursenParticipant
We cannot repeat this problem. Are you opening the same kind of job as you saved? Iif you save a backup job and open the jobfile for a data sync job for instance I am not sure what will happen.
Please let us have a look at the jobfile. You may fake passwords in the file. And if you don't want to post it in public you can create a support ticket by sending a mail to [email protected].
-
May 4, 2011 at 1:25 am #32211Purple EdgeParticipant
Thanks, I looked in the backup XML file and everything looks OK, all the specific data is there. The backup ran OK on its schedule so that is fine.
If you look at the attached image, you will see that the connection is not showing, this might be because it is an SSH connection? This is what confused me, if I choose a connection it then blanks the database at the bottom of the form.
I just don't know if it is safe to leave the connection name as unspecified when editing a job, or whether I need to re-specify the connection, and then re-specify the database?
-
May 4, 2011 at 7:44 am #32212peterlaursenParticipant
OK .. now I understand. The 'connection name' is not used by SJA – only the SQLyog GUI executable uses it. Connection names are stored in SQLyog.ini and not in jobfiles.
-
-
AuthorPosts
- You must be logged in to reply to this topic.