Issue with SQLyog Job Agent on Ubuntu

Josh Sherman
1 min read
Linux SQL Debian / Ubuntu

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

Join the Conversation

Good stuff? Want more?

Weekly emails about technology, development, and sometimes sauerkraut.

100% Fresh, Grade A Content, Never Spam.

About Josh

Husband. Father. Pug dad. Musician. Founder of Holiday API, Head of Engineering and Emoji Specialist at Mailshake, and author of the best damn Lorem Ipsum Library for PHP.

Currently Reading

Parasie Eve

Previous Reads

Buy Me a Coffee Become a Sponsor

Related Articles