[peterlaursen]

it I knew a workaround out of my head, I would have told of corse.

But I do not understand how this is related to HTTP-tunnel. I think the connection type (direct. SSH or HTTP) does not matter?

there have been lot of requests about improving DATA SYNC. Including several requests that we should implement a magician in SQLyog. Unfortunately MySQL AB provides no API for this ….

By saying so I did not mean to be 'nosy', but basically traditional SQL databases like MySQL are NOT designed as distributed databases!

An option you could consider is to connect to a (central) server using a connection from every tablet based on 3G Mobile Phone technology.

[peterlaursen]

We are considering various other 'conflict resolving rules' – including one based on a 'most recent TIMESTAMP on update CURRENT_TIMESTAMP'. We are not able to do it overnight! It is complicated actually!

[peterlaursen]

I am not sure I understand every detail (or rather : I am sure I do not ..)

the terms MASTER and SLAVE do not make sense with SQLyog synchronisation. Synchronisation is not replication! We use the terms SOURCE and TARGET – NOT MASTER and SLAVE.

The only 'conflict rule' currently supported by SQLyog/SJA is 'source overwrites target'.

[peterlaursen]

OK …

We have two more reports of this 'character substitution' taking place when dumping a Stored Procedure from a 5.0 server! It is not consistent (not the same characters that get removed and inserted). We have spent days trying to reproduce and understand! But it seems that it happens on specific hosts only. Whatever test case users provided for us (that was clearly reproducable on their servers) was not on our servers!

But there undoubtedly is an issue! So we will have to try again!

1) please tell the server platform – and very detailed please!

2) how do you connect (direct, SSH, HTTP)?

3) would you mind attach your my.cnf/my.ini ?

[peterlaursen]

This (in my.cnf)

set-variable=default-character-set=cp1251

init_connect='SET NAMES cp1251'

.. will not have effect with SQLyog because SQLyog does 'SET NAMES utf8'.

You can try yourself to execute (from SQLyog)

'SHOW VARIABLES LIKE '%character%'.

SQLyog 6 is designed to ALWAYS use utf8 on the client side!

I also think the FAQs explained in detail!

But SET NAMES (neither yours or ours) has no effect on binary types like BLOBs! If you alter table and change BLOBs to TEXT I think it will display. It surprises me that selecting ASCII/ANSI in the dropdown does not make things display correct. I will hav to study cyrillic charsets more in detail, I think!

Please dump, zip and attach a small table that illustrates the problem plus a few screendumps of how it displays on your system!

SQLyog 5.32 COMMUNITY can be downloaded from

http://www.webyog.com/downloads/SQLyog532.exe

[peterlaursen]

That information will be available too on our website when the beta is released. We are working on it right now actually.

[peterlaursen]

Actually we origninally planned to release 1.0 beta1 this week but decided to spend a few more days on some GUI improvements.

It is 99% certain that we release the beta next week and 1.0 FINAL (including lot of new features + documentation) in a few weeks after.

[peterlaursen]

also:

what does “SHOW CREATE TABLE …” for the table return?

[peterlaursen]

Also inform about the MySQL version, please!

[peterlaursen]

SQLyog displays what is stored in the database!

that applies to string )char/varchar/TEXT) data. For BLOBs you should try 'froce' ANSI client side encoding for those from the dropdown in the upper right corner of BLOB-viewer.

How does SQLyog BLOB-viewer detect the encoidng of the byte stream? And what is the LOCALE setting of your PC?

Please refer to the FAQs:

http://webyog.com/faq/34_149_en.html

http://webyog.com/faq/34_152_en.html

You are (very) welcome to attach a dumped and zipped (small) table/test case that illustrates your problems

.. plrsn was here too 🙂

[peterlaursen]

I think you will need to reforamt that file a little, using 'search and replace' in an editor, a 'macro' in some advanced editor or a script. If you need to do this at intervals you should find a way to 'automate' it!

You will need the same delimiter between data and another between lines/rows!

CSV/text import with SQLyog can be done 2 ways:

1)

Importing the file to an existing table (structure must be defined in advance):

http://webyog.com/faq/28_73_en.html

2)

Migrating with the Migration Tool and the text-ODBC driver. This will also create the table structure if you wish

[peterlaursen]

thanks!

… we will study this!

[peterlaursen]

As always we request that you test issues with the latest available stable SQLyog version!

[peterlaursen]

I think it is 'TRUNCATE DATABASE' that you are looking for?

[peterlaursen]

Hello!

With version 6.05 font setting is functional for RESULT tab in text mode.

http://www.webyog.com/forums//index.php?showtopic=3352

But we did not try to solve the alignment issue.

We would still like such 'test case' in Turkish!

[Author]

Posts