Sync Sql Yog 5.051 With Windows Server 2007

[angel_scream]

I had install SQL yog version 5.051 that is working under My SQL on Windows Server 2007.The data is not synchronizing.What should i do-may be install other version of SQL yog that is more compatible and wich is it, or make any additional adjusments on the current ?Please let somebody who is using this versiion help me!Thanks in advance!

😕

[peterlaursen]

This is a little confusing! There is no SQLyog version 5.051. But there is a MySQL server version 5.0.51! (I also do not know 'Windows Server 2007'. It must be 2003 or 2008? .. but this is not really important as SQLyog runs on all WIndows from Windows 2000!)

The general answer is that you should always use the most recent SQLyog version! However if one of the MySQL servers you sync to or from is a 3.x or 4.0 server wou will need to use SQLyog 6.56. Form 7.0 Data Sync does not support those old and non-supported server versions

Please provide

1) exact and correct information about MySQL server versions (both and ) and the SQLyog version.

2) detail this 'but it is not syncing'. What exactly happens? If is always better to tell *what happens* than *what does not happen* ('please help .. my car won't start' is also useless – but if you tell that the gasoline gauge shows '0' it is much easier 🙂 )

[angel_scream]

peterlaursen wrote on Jun 26 2009, 02:00 PM:

This is a little confusing! There is no SQLyog version 5.051. But there is a MySQL server version 5.0.51! (I also do not know 'Windows Server 2007'. It must be 2003 or 2008? .. but this is not really important as SQLyog runs on all WIndows from Windows 2000!)

The general answer is that you should always use the most recent SQLyog version! However if one of the MySQL servers you sync to or from is a 3.x or 4.0 server wou will need to use SQLyog 6.56. Form 7.0 Data Sync does not support those old and non-supported server versions

Please provide

1) exact and correct information about MySQL server versions (both and ) and the SQLyog version.

2) detail this 'but it is not syncing'. What exactly happens? If is always better to tell *what happens* than *what does not happen* ('please help .. my car won't start' is also useless – but if you tell that the gasoline gauge shows '0' it is much easier 🙂 )

Dear Mr.Laursen,

Thank you for your prompt answer and sorry about my lack of understanding!

The installed version of SQLyog is really old – 5.22 and MySQL server version is 5.0.27 and it has to run on Windows 2002 SP3 with office 2007 enterprises. The poblem is that I try to export my databaze like a query with all of tables make in txt.notepad fail and when I execute the query there are tables, but the data in them fail to read!

I guess it comes from the encoding? But I tryed to replace utf8 with cp1251 in the content of the query,but the data is no readable again /all of varchar and int.values/. Is it possible to no properly installed SQLyog or MySQL server or just this versions doesn't corresponding well with office 2007?

I am not a software specialist, but I hope this time I gave you more correct information about what exactly happens to me?!!!

Could you please, explain me why should I always have to use the most recent SQLyog version?And which is the most appropriate in my case? Can I install the newest version 8.1 of SQLyog, proposed in your website?

I'll be gratefull writing me again! Thanks in advance and regards!

[peterlaursen]

We will try to find out!

Now I understand that you are not using the Data Sync feature. Your are exporting tables, right? That is how I understand “The problem is that I try to export my databaze like a query with all of tables make in txt.notepad fail and when I execute the query there are tables, but the data in them fail to read!”

When exporting there is an option only to export 'structure only' or 'structure and data'. Ensure that you have checked 'structure and data'.

Can you attach some screenshot of what you are doing and an exmaple of such file? It will only have to be a small one. But we need to be sure we understand!

It is always most appropriate to use the latest version with a very few exceptions like:

* to run SQLyog on Win 9x/ME you will need 5.x

* to run data sync involving a 3.x or 4.0 server you will need 6.x

* to work with non-unicode data stored on 3.x or 4.0 servers on a client machine running a LOCALE setting not matching the language of datayou will need 5.x (This seems to be a particular issue in Hong Kong where users will mostly use an English client system and still work Chinese data. But NOTE: only if data are stored with a non-unicode charset in a server before 4.1 it is an issue).

(all those exceptions are related to old software (Windows and MySQL) that are now out of support).

[angel_scream]

peterlaursen wrote on Jul 3 2009, 09:33 AM:

We will try to find out!

Now I understand that you are not using the Data Sync feature. Your are exporting tables, right? That is how I understand “The problem is that I try to export my databaze like a query with all of tables make in txt.notepad fail and when I execute the query there are tables, but the data in them fail to read!”

When exporting there is an option only to export 'structure only' or 'structure and data'. Ensure that you have checked 'structure and data'.

Can you attach some screenshot of what you are doing and an exmaple of such file? It will only have to be a small one. But we need to be sure we understand!

It is always most appropriate to use the latest version with a very few exceptions like:

* to run SQLyog on Win 9x/ME you will need 5.x

* to run data sync involving a 3.x or 4.0 server you will need 6.x

* to work with non-unicode data stored on 3.x or 4.0 servers on a client machine running a LOCALE setting not matching the language of datayou will need 5.x (This seems to be a particular issue in Hong Kong where users will mostly use an English client system and still work Chinese data. But NOTE: only if data are stored with a non-unicode charset in a server before 4.1 it is an issue).

(all those exceptions are related to old software (Windows and MySQL) that are now out of support).

Thanks for the reply again! Yes, I am exporting tables – both 'structure” and 'data' from txt.notepad file and the fields that have to read like names or titles and are with datatype 'varchar' failed to read/they are reading like question marks/. But some of the fields,who are actually dates in my datebase and are with datatype 'varchar' are also reading like question marks, but not all of these fields in the tables! Other fields,who are with datatype 'int' are readable – I don't have any problem with them!I can attach you the file ,which I call a query and which I am exporting from, if you insist and you should probably test it, but I am afraid of a spelling – I meant a language, the data are descripted you know??? Sory about the way I express myself, but I am still beginner in datebase developping! Is it so necessary to send you this file? Can you explain me what to do otherwise?

Thanks a lot and excuse me once again! Wait writing me soon!

[navyashree.r]

Hi,

We tried your case with VARCHAR datatype. Dates are exporting successfully without converting into question marks. “SQLyog is now fully UNICODE-compliant”. This is from SQLyog 6.0 version.

Could you please attach the dump so that we can try at our end?

Regards,

Navya

[angel_scream]

navyashree.r wrote on Jul 14 2009, 06:26 AM:

Hi,

We tried your case with VARCHAR datatype. Dates are exporting successfully without converting into question marks. “SQLyog is now fully UNICODE-compliant”. This is from SQLyog 6.0 version.

Could you please attach the dump so that we can try at our end?

Regards,

Navya

Hi,

Ok, I am attaching you the dump I am exporting from.So do I have to consider that the problem comes from the old version of SQL yog 5.22 and that I have to install the newer one?Is it the newer than 6.0 enterprise,or it has to be precisely SQL yog 6.0? Could you please specify?

Waiting for your reply soon!Thanks in advance!

Ina

[angel_scream]

angel_scream wrote on Jul 21 2009, 02:22 PM:

Hi,

Ok, I am attaching you the dump I am exporting from.So do I have to consider that the problem comes from the old version of SQL yog 5.22 and that I have to install the newer one?Is it the newer than 6.0 enterprise,or it has to be precisely SQL yog 6.0? Could you please specify?

Waiting for your reply soon!Thanks in advance!

Ina

Here is the fail: Sory, but because of it couldn't atached in txt.notepad format I made it in doc.format!

[peterlaursen]

You do not have a Primary Key in the table (and no indexes at all, what is very bad). SQLyog will raise a warning when syncing such table. It is is not possible to UPDATE with such table, SQLyog will always INSERT. Was that the problem?

[peterlaursen]

I am sorry! I only saw the first page. My mistake. Let us try with this if we can get close to the problem.

[angel_scream]

peterlaursen wrote on Jul 21 2009, 02:15 PM:

I am sorry! I only saw the first page. My mistake. Let us try with this if we can get close to the problem.

Dear mr.Laursen,

Did you cheked and tested my dump on your software?Is it something wrong?I have a primary key ('ind')

Please conferm me what version of SQLyog I should use in my case to close the problem – make all the data readable?Is it SQLyog 6.0 or up!!!

I am waiting for your reply!

Many thanks and my compliments!

Ina

[navyashree.r]

We tried with your data. Its working fine at our end.

We tried with 'Backup Database As SQL dump' and powertool 'Schedule Backup' to export data from our latest SQLyog 8.12. We even ran a testcase in SQLyog 5.22 it is also displaying 'DATES' column correctly which we are not supporting.

So could you please try TRIAL from our Downloads page,

http://www.webyog.com/en/downloads.php

Regards,

Navya

[peterlaursen]

I find a problem with one particluar table. In your file it looks like:

CREATE TABLE `sela` (

`ind` int(11) NOT NULL auto_increment,

`Selo` varchar(255) default NULL,

`Okr` varchar(255) default NULL,

PRIMARY KEY (`ind`)

) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

/*Data for the table `sela` */

insert into `sela`(`ind`,`Selo`,`Okr`) values (1,'Капитановци','Р’РёРґРёРЅ'),(2,'Др. Йосифово','Монтана'),(3,'Р вЂ?ъЕовица','Монтана'),(4,'Кнежа','Плевен'),(5,'Новачене','Плевен'),(6,'Николаево','Плевен'),(7,'Р вЂ?РѕСЂРёРС?Р В°','Ловеч');

I guess it should not look like that? Please read:

http://www.webyog.com/faq/content/34/152/e…-in-sqlyog.html

.. it looks very much like what is stored in the database is not what you see in your application.

But WORD may may do weird things. Please attach a zipped .text file.

However you are using MySQL 5.0.27. This server version supports SET NAMES. So best is to use SQLyog from 6.0 and up (and I already told that you should alwasy use the last stable version unless there is a very special reason not to).

[peterlaursen]

For that particular table SQLyog displays data like the file reads.

What should it look like? Just tell what this

Quote:

Капитановци

should look like, and we will probably be able to figure out what is happening. But also tell how and with what program those data were written to the database.

[angel_scream]

peterlaursen wrote on Jul 23 2009, 01:13 PM:

For that particular table SQLyog displays data like the file reads.

What should it look like? Just tell what this

should look like, and we will probably be able to figure out what is happening. But also tell how and with what program those data were written to the database.

Hi,

Please take my excuses about the way I figured my dump sending to you! Actually I don't planning to include this table in my database and we don't have to discuss it anymore!

So, I'm going to try your trial 8.12 SQLyog from the download page and also will try to make a “backup database as sql dump” in order to exort the data with powertool “Shedule Backup” from your latest SQLyog version, as you did it, and then I will write you again if there arised any problems!!!

Thanks and regards,

Ina

[Author]

Posts