[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

[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

[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!

[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]

peterlaursen wrote on Jul 9 2009, 05:01 PM:

It simply looks like the query returns an empty resultset! We cannot comment more as we do not have the data.

I do not understand 'preinstalling Windows' .. do you mean 'reinstalling Windows'? The only think I can think of is lattercase problems with databasenames and tablenames. Maybe the 'lower_case_table_names' variable has changed?

(read http://dev.mysql.com/doc/refman/5.0/en/ide…nsitivity.html).

I think you will need to 'break down' the query: first try one join, next another and next both.

Hi! And thanks a lot for the reply!

Yes it is about 'reinstalling Windows'. But I rewrote the query with 3 JOINS,the way you told me, and it worked, I got the rezult from my 3 tables!

I'm going to write you again if there arised any problems in similar case!

Regards,

Ina

[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!

[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!

[Author]

Posts