[Shadow]

I would say, it's rather the data sync wizard…

[Shadow]

Did you try to display the contents of that field as a result of a SELECT query?

[Shadow]

No function is supported by SQLyog because it does not have to support any function. It's MySql that executes a function. All that SQLyog can do is to use different color coding for reserved words, function names, etc., to help developers.

[Shadow]

This feature is already incorporated in SQLyog Max beta.

[Shadow]

Editing foreign key are on my wishlist, but I think Ritesh mentioned this feature as one of the enhancements in SQLyog MAX.

[Shadow]

Quote:

The bug would be solved in SQLyog 3.8

Great! We have just upgraded to 4.1.3 and getting these error messages fustrate me!

[Shadow]

Quote:

I can well believe MS was behind the confusion somewhere.

I don't think they were the only one, but not surprising at all 🙄

[Shadow]

Technicly you are right, it was Excel that introduced this sluggish terminology (Excel treats all text files that have some data separation as csv), SQLyog merely follows this routine. One should check the settings, however, before performing any operation. BTW, SQLyog notes your settings, so next time comma will be offered as field separator.

[Shadow]

Host name might be a problem. When you connect via command line, which host do you connect from? From localhost (where MySql runs) or from remote host (where SQLyog runs)? Check if xxx@intranet-100 user (or xxx@%) exists at all!

[Shadow]

Quote:

However, how can I keep different backup for everyday, I mean, schedule a job to do that?

Using data sync wizard alone is not sufficient, you'll need to write scripts to accomplish. For example, you could write a script that creates an empty db every day and modifies the job's xml file so that the newly created db is used as target and then executes sja.

Quote:

BTW, to use job manager, is there a way to see job status?

Yes, in Windows scheduler. 😉

[Shadow]

The error message is displayed (Could not read data for the table), but still it is capable of editing the properties. Annoying nevertheless, I admit.

[Shadow]

Or Windows Scheduler. Actually, SQLyog's db sync wizard uses the built in scheduler to time the execution of a specific job.

[Shadow]

No, do not remove ZoneAlarm, just configure it! If ZA detects a new program wanting to connect to the “Internet” (ZA says so, even if SQLyog wants to bind to localhost only), you'll be promted if access can be granted or no. You should check out the programs list as well in its control panel to see if SQLyog is included there or not.

[Shadow]

I thought SQLyog and MySqlAdministrator use the same way (libmysql.dll) to connect to a MySql instance. If a personal firewall prevents SQLyog from connecting, then it should do the same to MySqlAdmin, shouldn't it! Unless a rule has been specified for MySqlAdmin…

[Shadow]

According to the error message, there is no MySql running on localhost. Make sure that you specify the right host and that MySql is up and running on that host!

[Author]

Posts