[peterlaursen]

i am sorry but there is no way with SJA sync!

[peterlaursen]

In 'the first shot' we cannot reporduce this.  Every query displays when finished and other queries are running.

I wonder if your system is getting close to full memory use?

[peterlaursen]

You do not understand what the specification is for.

Please refer to:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

SQLyog/SJA data sync will always sync complete rows.  The  specification is used to specify which columns are used for generating checksums.  For instance if you have a unique column (more than the PK) you can specify that column alone and achieve a major performace improvement.  Also avoiding BLOB columns for the checksum generation can speed up things a lot!

[peterlaursen]

@vygi

is this a new issue with version 6.0, or did you only get across that recently?

[peterlaursen]

addition:

the SQL generated is like:

“create table `peter`.`child_copy` ( KEY `child`( `child`))type=InnoDB”

.. no lenght specification in the create statement!  the values '767' is probably the default for my server version!

[peterlaursen]

Confirmed that there is one or more issue with length of indexes specified on string type columns.

I created an Index of length = 3 on a table and dublicated that table.

In the dublicated table it became length = 767.

SQLyog version 6.0 final.

[peterlaursen]

please verify version 6.0!

[peterlaursen]

We have no such plans.  We never encountered this request before.

I don't think it will be very hard to implement however, so if it really is a common need/request we can discuss.

[peterlaursen]

Please tell:

1) It it Vietnamese?

2) MySQL version?

3) If you ever tried version 5.x could you read it correctly with this one?

4) What program would you normally use to view the data?

5) Please connect to the database and execute “SHOW VARIABLES LIKE '%character%';” and paste the result here

6) Please create a small table with such characters, export(dump) it using utf8 encoding (the SQLyog 'export' does), zip and attach here.

“because they are encoded somehow”.  “SHOW VARIABLES LIKE '%character%';” will tell how it is encoded in the database.

[peterlaursen]

we got your files and are analyzing!

but there is absolutely no change on the client side between when it worked ok and now?

[peterlaursen]

“the error seems to be that contact has been lost with SQLyogTunnel.php”

This looks more like an issue with the server than with sQLyog/SJA.  But a crash should not occur!  Please tell the program version.  If the program version is not recent please try a recent version and if porblem persists please attach dump files.

[peterlaursen]

sorry .. I meant COLUMNS, not ROWS.

I will try this with PSpad!

[peterlaursen]

let me explain further:

When SJA reads the databases it cannot know wheter a row was inserted on on host or deleted at the other.  SJA does not know the 'history of operations'.  It only has data itslef.  It even cananot acces server logs (would demand acces to the file system and the API does snot provide that).  It does not read your mind either!

But still it would be possible I think to add options like 'never delete' and 'never insert' for either of the hosts.  So we will keep that in mind for future enhancements!

[peterlaursen]

I know PSpad well myself.

Yes, 'copy row(s) to clipboard' is a nice idea.  I cannot tell how difficult it would be to implement that.  We will discuss.

[peterlaursen]

there is no way for SJA to handle this at the moment.

[Author]

Posts