[peterlaursen]

What are the MySQL server versions and the SQLyog version ?

Anything being updated since it last worked? MySQL server at Server/ISP maybe?

(you can execute 'select version()' to get server versions)

I think that I can remember that 'NULL definition mismatch' occured with earlier SQLyog versions when trying to sync incompatible MySQL versions.

Did I get you right that BOTH syncs were server >> local? And it succeeds first time but not second time? And the DB was empty both times ?

And you have checked that the NULL definitions are identical in the 'create statement for the table' ?

I guess that the column that causes trouble is both first column and Primary Key?

Also please paste in a simple 'create statement' with this problem to reproduce the problem.

[peterlaursen]

There is a brandnew MySQL Administrator (1.1.6) being uploaded to FTP-mirrors right now. It does the same – mismatches engine type with PARTITION keyword.

[peterlaursen]

See attached …

I think the 'first','previous','next' and 'last' buttons should not only be in BLOB-viewer itself but also in DATA and RESULT-panes. Also Alt+arrow_down for last and Alt+arrow_up for first would be nice (or Ctrl instead of Alt – what is most standard?).

If there is one ore more BLOB-viewer instances open they should load with appropriate data when focus moves to another row using arrow keys or buttons.

It is no problem I think, because Ritesh told me yesterday that GUI-work is not difficult at all 😛 😀

[peterlaursen]

Quote:

Then I click within a field and select some text. Now, if I highlight my query again with the mouse and hit F5, SQLYog crashes.

Confirmed and verified with SQLyog 5.01

I can't tell exactly what goes wrong here, but some kind of buffer-issue I think, when selection has been done in RESULTS-pane as well as SQL-pane.

[peterlaursen]

Timberline ???

I know nothing about it! Found this on Google

http://www.google.com/search?client=opera&…=utf-8&oe=utf-8

Could you please specify exactly what software you are using. Including which ODBC-driver? Do you know if there is a demo available?

Also please read: http://www.webyog.com/faq/14_77_en.html

Can you connect and transfer data with reasonable speed with other applications such as MS-Access or OpenOffice Base ?

[peterlaursen]

Now this rewritten article is out on Webyog website:

http://www.webyog.com/articles/Using_SQLyo…L_Databases.pdf

It gives an example how you can really effectivize things using the option.

I have been thinking a little more about this. To be able to work further into this e need

* the Jobfile

* the 'create statement for the table'. Copy it from OBJECTS pane in SQLyog

* some sample data. All columns but not all rows.

To generate sample data for instance build a new table like

Code:

CREATE TABLE new_table SELECT * from old_table LIMIT 1000;

Now export new_table.

If you don't want to attach it here you can zip it all and mail it to [email protected].

It might be some bug with concatenation/checksums, so that rows that are identical don't get identical checksums. Then SQLyog tries to INSERT a row. However the MySQL Server does not accept an INSERT using a PK-value that is already in use.

Do you happen to know whether the problematic row(s) are changed on the source when this happens? It surprises me somewhat that it is an INSERT and not an UPDATE error that occurs. It looks like even the PK is not identified correctly.

But we need sample data and the jobfile to reproduce it. And nothing can be fixed that can't be reproduced.

[peterlaursen]

You must use the “Enterprise Trial” and not the “Free” SQLyog.

The “Free” version does like this. It should display something like “tunnelling not supported” or something like it I think!

[peterlaursen]

this surely should not happen! If looks somewhat like a problem with old versions and special characters like or ' . But should not happen with SQLyog5.

this:

Quote:

If I delete the offending rows in the target it will happily synchronize.

looks like the key to the problem for me. Also synch'ing with LONGBLOBs is a little unusual. Could it be a concatenation/checksums problem with LONGBLOBs? How big are those LONGBLOBs ?

do you use the option some way?

If the TITLE field is unique you can use this field ONLY with the the option. Then only this column is used for checksums calculation. And it will speed up things a lot too. But this is a workaround only – not a bugfix … if there is a bug!

Could you paste in the jobfile?

Are the data confidential? Some sample data are needed to work with this problem.

[peterlaursen]

And I can add that I just 20 minutes ago installed SQLyog 5.01 on WINE/SuSE 10 and it works just fine too. 😀

[peterlaursen]

Quote:

The version you provide for linux is not a graphical tool is it?

No the SJA for Linux is only the 'engine' for sync, backup, and notification.

A command line tool only.

Read about SJA for Linux and Windows here:

http://www.webyog.com/faq/15_47_en.html

However both SQLyog (Free, Pro and Enterprise) and SJA for Windows runs fine with WINE on LINUX:

http://www.webyog.com/faq/5_71_en.html

[peterlaursen]

@Newbie23

It also would be nice to know whether the MySQL serveris a local server or a server at an ISP – and if the latter is the case – whether tunnelling is used. If for instance you use HTTP-tunnelling, it could be a php-issue.

Actually all that we ask for here http://www.webyog.com/faq/6_26_en.htmlwould be helpful if we shall be able to reproduce the problem.

[peterlaursen]

Yes it could very much look like a time-out thing. Or at least some configuration issue.

Just one question: why do you use CSV-files with the Migration Tool. Can't you conncet to the ODBC-database directly? You use the TEXT-ODBC-driver then?

This

Quote:

Individual tables and data seem to come in just fine, but when I try to have several of the tables imported in one session, SQLyog just stops processing records without completing the importation

would not occur then, since then one table is finished before the next is started.

If you need to use CSV-files you can import from CSV without using the Migration Toolkit. Tried that?

What is the original database for the data ?

And the MySQL version ?

[peterlaursen]

I can reproduce this with MySQL 5.0 and 5.1 . See attached. Here user 'tttt' has insert privilege only to database 'test2'.

The icon is a table icon. But not placed in a database tree!! It stands alone!

And it does not not seem to be a graphical display error only , because when trying to

Code:

alter table test2.item add column peter bigint;

mysql returns

Quote:

ALTER command denied to user 'tttt'@'localhost' for table 'item'

Trying on table test

Code:

alter table test.item add column peter bigint;

returns

Quote:

Table 'test.item' doesn't exist

.

However opening another connection as root does not find any test2.item or just item DB. 5. Also the database test2 does not show up at all when a similar setup is crated with MySQL version 4.0 or 4.1 (unless it is InnoDB!)

It is a harmless phenomenon, I believe, but never the less some kind of small bug with SQLyog in relation to MySQL 5.x – or a small bug just only visible in MySQL 5.

Pics:

Left: phenomenon displayed in MySQL 5.

Mid: MySQL 4 – nothing is dispalyed as user has no select privilege at all.

Right: MySQL 3.23 displays this err mess when trying to open table tree.

The different behaviour(s) of 3.23 and 4.0 is a know issue with the respective MySQL version and tables with no SELECT-privilege..

However wasn't MySQL 5 expected to behave like 4.x ?

[peterlaursen]

Quote:

I suggest a toggle in the results pane …

I think this is a good idea!

[peterlaursen]

@vygi, you are/were right.

Hard to remember all details as MySQL (and SQLyog too) becomes more complex!

I wrote up this FAQ: http://www.webyog.com/faq/10_84_en.html

[Author]

Posts