[peterlaursen]

Please verify the fix for this issue with this build:

ENTERPRISE link:

http://www.webyog.com/downloads/betas/not_…QLyog614Ent.exe

COMMUNITY link:

http://www.webyog.com/downloads/betas/not_…d/SQLyog614.exe

[peterlaursen]

I am told that I was mistaken as regards Linux 'tables' and 'TABLES' ..

But LETTERCASE mismatch may occur on Windows.

[peterlaursen]

Now fixed! We will release *something* shortly!

[peterlaursen]

1) one byte is required for the ” – ” sign

2) I practically always make an autoincrement PK a BIGINT UNSIGNED .. but probably 'overkilll' in most situations!

[peterlaursen]

it is a limitation with MySQL itself that only one TIMESTAMP column can use CURRENT_TIMESTAMP in definition.

[peterlaursen]

ok .. you are creating a FK – sorry I did not realize this!

the *Table Mismatch* errror can occur if LETTERCASE do not match.

Currently SD does not support both 'Table' and 'table' when connected to a Linux server.

We also find an issue whne uppercases are used on a Windows seerver (and that is definitely a bug!).

What is the server platform?

What is the 'lower_case_table_names' setting for this server ?

[peterlaursen]

“I try to drag and drop a column to or from the new table to an old table”

Moving columns from one table to another is not supported with the Schema Designer.

We had a similar request and it is added here allready: http://code.google.com/p/sqlyog/issues/detail?id=451

.. but absolutely not without problems to implement.

What about indexes defined on that column? or Foreign Keys referencing it?

What if tables have different default charsets and the charset/collation is not explicitly defined for the column?

Also would you expect data to be copied with that operation?

This would really take some operations on the background!

[peterlaursen]

I am afraid I do not understand the problem.

I did this:

* copied the .mdb to my PC

* created a DSN pointing to it with the Access ODBC driver

* imported the MySQL dump into an empty database

* started the Migration tool with those details

Behind the 'advanced' button for every table I did as attached image shows

[attachment=785:setting_.jpg]

Now checking in the 'map' button everythings seems to get mapped fully automatically.

Please explain more in details what is the problem?

[peterlaursen]

With those server adn SQLyog version everything should be handled sully automatic.

An important point is that you shall not SET NAMES or SET CHARACTER _SET_ yourself. The program does what is required!

Please refer to:

http://www.webyog.com/faq/content/34/148/e…y-language.html

Please confirm that you don't!

But I actually think that a very special issue with Portuguese was fixed between 6.11 and 6.12. Please try 6.13 or 6.14 RC!

BTW: also that server should be upgraded! Server bugs are NOT out of question here! What are the data types where you experience this? char/varchar/text/blob? or more of them? I think I recall an issue with TEXTs and early MySQL 5.0 servers!

[peterlaursen]

You allready told in another post!

please reply to questions here or there!

[peterlaursen]

“Im confused about Access hosts” So am I!

Please study relevant FAQs:

1) http://www.webyog.com/faq/content/23/18/en…on-denied-.html

.. are you sure that direct connection to the server is allowed? if not and if you cannot allow remote access for this user you need to use tunnelling!

2) This

http://www.webyog.com/faq/content/16/66/en…-at-an-isp.html

.. is frequently a problem with shared hosting. But not for you. You get an AUTHENTICATION ERROR (from the MySQL server) – not a CONNECTION error (from the client)

[peterlaursen]

“I add a new table it refuses to let me make relationships with/to it claiming a “Table Mis-match. Please refresh the canvas” “

I have not encountered that! But we can check with the code of course what exactly condition raises exatly this error mesage!

1) Can you describe in detail how to reproduce it?

2) Does save SCHEMA .. program restart .. open SCHEMA remove this message? Does close and reopen connection?

[peterlaursen]

no issue!

Our analysis told that only COMMUNITY version was affected. I just wanted to be sure!

[peterlaursen]

1) Is it possible to change a table name using the schema design interface?

>> Currently not. You will have to do from Object Browser or by executing 'RENAME TABLE'. Refreshing Schema Designer will remove the table as the name has changed. You will need to add again.

2) Setting default charset and engine for tables is behind the 'advanced' button of CREATE TABLE dialogue

3) It is other considerations that decide which one should be PK and which should be indexed otherwise. Those that you use for Foreign Keys, JOINs, ORDER BY and GROUP BY should be indexed somehow if not tables are very small. Tuning indexes with 'big and busy' databases is a study in itself!

[peterlaursen]

Actually this screenshot

Please tell

1)

what is the program version you are using?

If the dropdwon is not there it is either 6.0 or a very old version!

2)

And what is you native language and the language of your Windows installation?

3)

After connection to a database please execute

Quote:

SHOW VARIABLES LIKE '%character%';

and paste the result here

4)

Finally tell the server version

Quote:

SELECT VERSION();

.. will tell you that

related FAQs:

http://webyog.com/faq/content/34/148/en/do…y-language.html

http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html

[Author]

Posts