[peterlaursen]

Hi .. we managed to 'squeeze' the fix for this issue into version 10.5 that was released a few minutes ago. Please refer:

http://blog.webyog.com/2012/12/11/visually-compare-mysql-data-and-sync-the-differences/

[peterlaursen]

If you are working across multiple connections (Is that what you are doing?) the CREATE TABLE .. SELECT .. statement will not work. It is the server that executes the statement and one server knows nothing about another server (unless you use the Federated/FederatedX storage engine: http://dev.mysql.com…age-engine.html .. and that would be an option.

[peterlaursen]

Well .. I suggest that you use Data Synchronization (from the 'powertools' menu and available in Enterprise and Ultimate editions of SQLyog). But I advise that you first practise it a little with two unimportant test databases on you local system.

Also read the relevant paragraph in the documentation (help .. help menu) as well as some FAQ's like:

http://faq.webyog.com/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html

http://faq.webyog.com/content/11/60/en/what-is-the-difference-between-mysql-server-replication-and-sqlyog-synchronization.html

http://faq.webyog.com/content/11/61/en/how-can-i-speed-up-the-sqlyog-synchronization-tool.html

If you are using the TRIAL currently there is a limitaion that only two tablses can be synced per job as described here:

http://faq.webyog.com/content/33/137/en/are-there-restrictions-in-the-sqlyog-trial-compared-to-the-registered-versions.html.

[peterlaursen]

Your post has been moved to SQLyog category

— and we have this request already here: http://code.google.com/p/sqlyog/issues/detail?id=324

[peterlaursen]

Your headline refers 'copy database' but your description refers table(s). Are you copying a database to another host or copying table(s) involving only one host?

If the latter is the case you can simply execute “CREATE TABLE databasename.new_table AS SELECT .. FROM databasename.old_table .. “. The SELECT can use any construct that MySQL allows in a SELECT statement (even a GROUP BY with an aggregate function) . But be aware that new_table will be created without indexes. But that would also be necessary if you should implement something similar in the GUI – simply because indexes in old_table may not make sense at all with the result set fetched by the SELECT.

[peterlaursen]

One additional comment: SJA executes the WHERE clause on the source only and not on the target. If we should deleted on target this would be without considering the WHRE clause. That is why we have disabled DELETE when a WHERE clause is used..

[peterlaursen]

Can you provide an Access database where this is reproducible? As small as possible as long as reproducible.

Also please tell: what is the datatype for the column (in both Access and MySQL)? It could be the data type mapping the ODBC drvier does that causes this.

[peterlaursen]

.. and verified.

[peterlaursen]

Please see attached image.

[attachment=1836:duplicates.jpg]

As you see I have created a table with two identical rows. When I change from 'a' to 'b' in one the warning pops up before anything is saved to the server..

To work with this we need a similar test case from you (a table dump and a description of what exactly you are changing). You are welcome to post it privately to [email protected].

[peterlaursen]

The SET statement works as expected.

But it requires SUPER privilege (http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super).

[peterlaursen]

Simply execute this SQL query:

“SHOW VARIABLES LIKE 'local_infile';”

— does it return ON or OFF?

MySQL documentation:

https://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_local_infile

And if documentation is credible “Dynamic Variable = Yes” means that a user with SUPER privilege can change the setting online (“SET @@global.local_infile = ON;”)

[peterlaursen]

If the option is disabled in server configuration and you don't have privilege to change configuration you cannot LOAD DATA LOCAL (obviously).

You can still do a manul import with the 'import external data' tool. In last step of the wizard just select to execute at once (and don't schedule).

[peterlaursen]

Please tell the SQLyog version you are using!

(and I think you know this FAQ: http://faq.webyog.com/content/8/99/en/does-sqlyog-gui-understand-the-meaning-of-special-mysql-keywords.html)

[peterlaursen]

Nope. Since recently we offer discounts when purchasing maintenance for multiple years. You will get 50% off when purchasing for 5 years.

We don't exclude (lesser) promotions in combination with important MySQL events we are a part of in the future etc. But no actual plans.

[peterlaursen]

This has been fixed in version 5.53 that we have just released. Refer:

http://blog.webyog.com/2012/11/22/monyog-mysql-monitor-5-53-has-been-released/

[Author]

Posts