No error message, it just says that the sync had started. What sucks about this
issue, is that I ran into it with a previous version of SQLyog Job Agent (sja)
but was able to troubleshoot it faster because the program would dump an error
message. I have been messing with the issue very sporadically over the last few
weeks and had not come to a conclusion. Some luck Googling this afternoon let me
to the same answer I had before, sja is looking for the MySQL socket in a
different place than where Ubuntu thinks it belongs. Long story short, sja is
now working again, and ShowsTonight.com’s database can be in sync more often. An
honorable mention should go to Maatkit: a toolkit of utilities and tools for
MySQL as I tried to indirectly fix my sja issue by
migrating to using Maatkit. Unfortunately, I found the comparisons to take an
awful long time, and didn’t feel it would suit my needs compared to sja. Good
thing I got it working I suppose. It’s a pretty quick fix, one command:
sudo ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock
For reference, I am working with Ubuntu 8.04 and SQLyog 7.02
