[peterlaursen]

Please upgrade to version 5.2 beta5, and GRANT RELOAD privilege to user.

“I used GRANT ALL, that gave me access but I still cannot change permissions for users.” Did you speify with GRANT OPTION ?

[peterlaursen]

We don't support 'returns' form a SP yet.

Please refer to: http://www.webyog.com/faq/14_81_en.html

Hope to fix it soon!

[peterlaursen]

The reason is that checksums will have to be calculated for every 200.000 rows uing every columns if you do not use the and optimization parameters. You have noticed that first INSERTS, next UPDATES and finally DELETES are done. To check for UPDATES checksums are needed.

@Manoj: why will updates have to wait for checksum to be built? Does DELETES use the checksums?

[peterlaursen]

nope – not Freeware!

[peterlaursen]

Quote:

Also creating a simple table

Do you mean that you cannot create a table form SQLyog GUI?

about the import problem: Please copy a COMPLETE 'create statement for a table' from the file in here.

[peterlaursen]

Please read this FAQ:

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

If the settings in the import dialogue and the export dialogue is/was identical it should not happen.

Can you give us a small sample CSV and a screenshot of your import settings?

[peterlaursen]

Why not export as .SQL?

Note that if your dump condtains 'conditional comments' like /*! ..*/ yo will need to use 5.2 beta to import it with SQLyog.

[peterlaursen]

nope …

our tunneller can only be use with SQLyog and SJA. However we do plan to release a 'standalone tunnller application' taht can be used as a genereic proxy.

Time Horizon: a few months

[peterlaursen]

it will/should work with UPDATES too.

a md5()-checksum is is generated on the column(s) on both hosts. If they diifer the source-row will owerwrite the target row.

Could we see the jobfile? (fake details as you like).

You can create a ticket if you do not wnat to expose it in public.

[peterlaursen]

Quote:

Any chance that the directory the favourites are stored in could be specified by the user?

let us discuss!

[peterlaursen]

I meant RESOURCE_ID of course.

as ther is a Unique Index on RESORUCE_ID that column must be unique

[peterlaursen]

'latest” 🙁 Please specify the program version number!

This is LATEST: (a non-released RC-build)

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

and this is sismilar but throws more debug info:

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

.. please try!

[peterlaursen]

Quote:

'DEFAULT CHARSET=latin1'

is invalid in a table definition with MySQL 4.0.

I cannot explain why phpMyAdmin writes that. Its configuration files must be 'told' that this is MySQL 4.1 or higher. Can you create a table with this PhpMyAdmin at all?

solutions:

Open that SQL file in an editor and 'search and replace' 'DEFAULT CHARSET=latin1' with '' (empty string).

remove 'SET NAMES .. ' statements a similar way. Replace ENGINE (if it is there) with TYPE (have a copy of course!). We will get rid of all those syntax'es that do not work with 4.0. Create a backup with SQLyog of a small table a see what it should look like!

How big is this file?

[peterlaursen]

I think FREE/COMMUNITY editon does! I installed to a USB-stick (K:SQLyog) and I can navigate to K:SQLyogSQLyog.exe in Windows Explorer and start it on another PC. It is a little bit slower than when running from harddisk.

Do you request a 'autorun'?

With SQLyog ENTERPRISE the License is a per Client License. But I really do not remember if it prompts for registration details as a part of the installation proces or on first start! If someone purchases a 5-user license I wouldn't mind that they used it on 5 computers like this. If someone wants to use it on 80 computers .. well then contact Webyog Sales! The nice thing for a PC-supporter for instance is that he will bring his own sqlyog.ini with him around! And it would be no be deal to give an option to have 'favorites' under the installation folder either.

Was it ENTERPRISE you had in mind?

Nailing the license to some biometric is also a possibility! You can have a USB stick with a fingerprint reader today!

[peterlaursen]

Quote:

With SJA it only works if I remove the http authentication.

that surprises me a lot! never heard of it before!

We will absolutely look at this!

Could you post the exact configuration parameters from .htaccess

You can create a ticket if you like and 'fake' details as you like.

[Author]

Posts