[peterlaursen]

this is INDED planned for 5.2.

You will find a similar recent discussion if you search the Forums.

If is not possible to display '# of rows' or 'percentages', because that is not how the tool works. But messages like 'comparing PK's','retrieving cheksums', 'marking x rows for update' and the like is possible …

[peterlaursen]

Now ..

It seems that I have a mail from a developer. There is an issue. I do not usnderstand details. It is fixed in the 5.2 beta 4 tree, I was told

[peterlaursen]

1)

To see all character set-realatet information execute

Code:

USE some_database;
SHOW variables LIKE '%character%';

2)

Both SQLyog export and mysqldump (recnet versions of both) encode the saved file as UFT8 as default no matter how it is stored. I do not think you need to do anything!

3)

As far a SQLyog data sync goes it is not possible to sync data in latin1 and utf8. Numbers and ASCII-characters will sync but any row with national, special characters will fail, as they are encoded using 1 byte in latin1 and 2 bytes in utf8. It is not possible for us to convert before executeing concat_ws(). We do SET NAMES but it only affects the client and the client-server communication.

I think we should CHECK for it however!

This “It is only the export/synchronization that causes the characters to be converted to something that isn't understood.” .. could be wrong! I think your script may do one error when it saves the the 'reverse error' when reading.

roadmaps for exploring into this:

1)

Try creating a very small table with the problem. And copy the .MYD, MYI and .frm files in here (zip into one!). VERY SMALL I wrote. 3 columns – 2 rows for instance. Dont forget any special characters that you use!

2)

With SQLyog 5.2 beta3 (5.19 wont work here!) back up using 'scheduled backup powertool' with UTF8 option unchecked and inspect data in a HEX-editor. HEX-editor will show every character/byte-value as it is stored.

[peterlaursen]

You do not have to guess – look in HISTORY tab!

this is generated when connected to 4.0 (beta3)

Code:

create table `test`.`TableName1` ( `id` bigint NOT NULL AUTO_INCREMENT UNIQUE `t1` varchar (50) `t2` varchar (50) PRIMARY KEY ( `id`))

this works (and is also genereated when connected to 5.x)

Code:

create table `test`.`TableName1` ( `id` bigint NOT NULL AUTO_INCREMENT UNIQUE, `t1` varchar (50), `t2` varchar (50), PRIMARY KEY ( `id`))

[peterlaursen]

One thread per question only please!

Does this answer you question?

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

EVERY database client does so, with identical rows!

If not then explain your self more in detail.

[peterlaursen]

@grantps

Please check version 5.2 beta3! 😀

http://webyog.com/faq/29_135_en.html

[peterlaursen]

Please understand that SQLyog is a (MySQL) database client. It is the MySQL server that stores data – not SQLyog. SQLyog only sends instruction (SQL) to the server. Where MySQL stores its data depends but basically:

1) on Windows it is normally in the data folder under the MySQL (not SQLyog!) installation folder

2) on Linux common places are /var/lib/mysql and /temp/mysql

3) but you can specify a /datadir in MySQL configuration

4) with mySQL 5.1 and partitioned tables you can use the 'DATA DIRECTORY' clause to specify a storage position for each partition.

Now are you connecting to MySQL on your local machine or a remote server? Data are stored where the server is running!

How MySQL stores its data depends on the Storage Engine (table type). With the 'traditional' MyISAM tables there is a .MYD (data) a .MYI (indexes) and a .frm (definitions) file for each table. With InnoDB tables all the data of all databases and tables are normally stored in a single file (however in MySQL configuration you CAN specify that each table should be stored in its own file – also with InnoD:cool:. With MySQL 5.1.x we have a lot of new Storage Engine. They each use their type of storage.

A DATABASE SERVER like MySQL is not at all comparable with an Office-type database like Access, Dbase or Paradox. Do not think of data as 'files' but as 'server entities' instead!

And

Quote:

How can I copy this data to an external drive (USB or floppy)?

You EXPORT data (right-click a table from SQLyog). Normally to a SQL-file. DATA ar then imbedded into INSERT SQL-statements, like

Code:

INSERT INTO yourtable (column_1,column_2 … column_n) values (…………………………….);

there may also be CREATE statements and other statements in such files.

To import your data (to the same or another server) you EXECUTE the SQL-file. From SQLyog menu: tools …

You can also export to .CSV and .XML formats.

[peterlaursen]

“another possibilty would be, autofetching rows, when scroll down to the end”

that would be the ideal solution. I 'data window' proces/thread as a layer between the GUI and the data base. That is a complete architecture change and will take much more time to prepare.

If you did not notice the 'check all' now (beta3) disables when you are switching tables. But still you may INTENTIONALLY 'show all' and experience that it takes much longer time than you expected. There is no way to stop the loading as of now.

[peterlaursen]

and with a stop button …

[peterlaursen]

Implementation idea!

[peterlaursen]

I still experience this! Especially when HTTP-tunnelling to remote servers.

Anybody else that does?

[peterlaursen]

thank you uyuni.

Well now after the release of beta3 I think we should take the time to understand this!

[peterlaursen]

I do not think that we can recommend any particular ISP. Things can change fast. A single person among their technical staff or at their support can make the difference.

However users are welcome to share their experiences of course.

[peterlaursen]

OK .. now what happens if you choose 'latin5' from the connections manager? If the default charset on your server is latin1 (very common everywhere around the world!) you must choose 'latin5' yourself.

Also is Turkish set as the default language for non-unicode programs? And is it a Turkish Windows or an English?

Please try to understand this:

http://www.webyog.com/faq/34_102_en.html

Actually the current charset setting system of SQLyog was first tested succesfully with Turkish!

what does

Code:

SHOW variables like '%character%';

return on you system when connected?

[peterlaursen]

did you go to tools..preferences..editor and selected a turkish script with the font(s) for the editor and the and the DATA tab? There is a dropdown where to choose!

[Author]

Posts