[Shadow]

Protocol mismatch means that the MySql server's and clients versions differ significantly. I believe you want to connect to a 4.1.1a or new version of MySql. You need to use SQLyog v3.71 to connect without any problem, older versions of SQLyog are not compatible with 4.1.1a. The only exception is the special edition of SQLyog dedicated to 4.1.1a.

[Shadow]

Are you going to test MAX?

[Shadow]

It's been repeatedly told that SQLyog data manipulating features (including sja) work if and only if there is a primary key defined in the table(s) that is(are) affected by a feature!

[Shadow]

Wait a second, Ritesh! A quote from the help file:

Quote:

Additionally, you can configure SJA to detect changes only for specific columns. This makes it an ideal tool to sync data even if there is limited bandwidth. Since SQLyog uses checksums to detect changes unselecting BLOB data may significantly speed up the process as these columns will not be used to generate checksums.

In my interpretation sja uses the values of the selected columns to generate checksums not vica versa! Actually, it works for me the above descibed way…

Mackenzie: there may be other options you didn't set in the right way. Could you post sample data in this forum that don't work for you?

[Shadow]

🙄

[Shadow]

Yes, you are misinterpreting this feature. SQLyog uses checksums to detect chages done to a record. If you select specific columns, then SQLyog will use only those columns to generate checksums, therefore if any other column gets changed, the change won't be detected by SQLyog.

[Shadow]

It's such a nuisance that sync must work! This warning has been included in the app because there might be problems with syncing a v3.x to a v4.x db (or vice versa).

[Shadow]

Quote:

Why can't I likewise, get the whole thing? If I have access to a part, doesn't that mean I can get the whole lot?

Because the whole app was designed solely to allow the retrival of specific information. The design of the app is incorrect if it lets you query data regarding other students. Correct me if I'm wrong, but exam results and educational advancement is personal data! At least, I don't really want anyone else to access those data… Isay, it's a huge flaw in the program design and the operators should be notified of the possible consequences.

Quote:

Another thing, How can I know what type of database the remote server has?

If the app is correctly designed (which is not), then it's difficult – unless it boasts the fact that it is powered by such and such db or portal engine. In case of a portal engine, you have to find out which dbs may be used with the engine.

Otherwise you may try to feed incorrect data to the app and see if the error is handled correctly. Let's say, the seating number is a true number such as 123. Submit 'abc' instead ('abc' cannot be converted to a number). If the app does not have proper error handling then you may receive an error message complaining about a data type mismatch. Such error messages usually contain the type of the db.

Quote:

Regarding the progs and ways of getting to the database, is that “hacking the database”?

Exactly.

I suggest you to contact the operators because if the service is abolutely public and there is no restriction on accessing all data, then they may grant you full access to the db or hand over a snapshot of the db. Of course, you may have to come up with a convincing cause for such a request…

[Shadow]

Yes and no. You may use notification services to reguraly get status reports via e-mail, but that's not all! You may schedule virually any queries and have NS deliver the results to you.

[Shadow]

SQLyog can be used to sync a remote database to a local one, provided the db is a MySql. So far, so good. The problem is your purpose: I belive you want to fetch all students' exam data from a given school trough Internet. I don't think it is possible.

Even if the db is MySql, the operators must have implemented security measures to prevent unauthorized access to their db from Internet. Unless you are one of the operators (I susprct that this is not the case), you must not have direct access to this db. I would say that even the operators should not have…

The contents of this db is surely accessed through a web app that runs locally on their server (to your question No. 2). Of course, you may ask the operators to grant you direct access needed by SQLyog, but I don't think you'll get it.

Sure, you may find ways and tools in the Internet that may help you to access this db despite all restrictions, but not in this forum.

[Shadow]

Does SQLyog freeze or does the sync complete without any apparent error?

[Shadow]

I'm not sure if the backup option works on remote servers as it copies the .frm, .myd, .myi files and you may not have the necessary rights to access them directly.

I would suggest you to use the 2nd and 3rd methods combined. The initial sync should be performed via script and the succeeding incremental syncs via SQLyog's built-in sync tool.

You may need to upgrade SQLyog as v3.11 uses old (v3.2x) client library and the servers may be of newer versions. You could perhaps try out v3.71 and see if it works!

[Shadow]

The first one will be included in SQLyog MAX.

[Shadow]

If you define a column as autoincrement, then you don't need to assign a value to this field in INSERT statements or just assign NULL. If you explicitly set an autoincrement field to a value other than NULL (or 0) then the field will be set to that value and the whole point of autoincrement columns is lost.

[Shadow]

To be honest, I have very little experience with Linux/Unix, but as far as I'm concerned MySql has a control center that is capable of managing its servers. You can download this app from MySql's website. Furthermore, there are numerous third party products listed on MySql's site that are related to MySql (SQLyog is among them, too). You should check them out as well.

SQLyog MAX is maturing, if you are willing to take part in beta testing it on Linux, send a PM to Ritesh. He will be more than happy to have an additional tester.

[Author]

Posts