[Ritesh]

Thanks for the report…

[Ritesh]

Hmmmm….

I have forwarded the anomaly report to my development team. It will be fixed in the next release 🙂

[Ritesh]

Quote:

An sqloyg error message appears telling “couldn't read data for the table” but after clicking “OK” it actually does read and alterations to the table structure can be done!

Are you still getting the error?

[Ritesh]

Hello

We have released SQLyog 3.64 RC3 that has this bug fixed. You can download it at http://www.webyog.com/sqlyog/SQLyog364.exe

[Ritesh]

You dont have permission to connect from a REMOTE host to your MySQL server.

In MySQL, you can provide privileges depending upon user connecting from specific hosts.

The following query will allow only the user to access from “localhost” ( this is probably your case )

GRANT ALL PRIVILEGES ON *.* TO user@localhost

IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

You have to issue a GRANT stmt like

GRANT ALL PRIVILEGES ON *.* TO a@%

IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

[Ritesh]

The error means that the MySQL server has not been started 🙂

[Ritesh]

Sure 😀

Its great to see you back in the FORUMS !!!!

[Ritesh]

Can you send me the SQL script of both the tables? It will be very helpful in fixing the bug.

Thanks for your feature request, I have forwarded it to my development team.

[Ritesh]

This is a known feature anomaly in SQLyog. We will be coming out with 3.64 RC3 soon that will have this feature updated.

[Ritesh]

“MySQL HOST ADDRESS” tells SQLyog the computer in which the MySQL server is running. If you have MySQL installed in your local machine then the host address is “localhost”

For more information you can contact your MySQL Admin.

[Ritesh]

It will be very helpful if you can attach the table structure(s)?

[Ritesh]

We have released SQLyog 3.64 RC2 that has lot of compatibility issues regarding MySQL 4.1.1 fixed. I will suggest that you upgrade from RC1 to RC2.

You can download it from http://www.webyog.com/sqlyog/SQLyog364.exe

[Ritesh]

Check out http://www.webyog.com/forums/index.php?act…=10&t=681&st=0&

[Ritesh]

You can configure SJA to detect changes only for specific columns. However, the structure of source and target tables should be identical.

[Ritesh]

Which version of MySQL are you using?

Information about your Linux OS will also be helpful.

[Author]

Posts