[peterlaursen]

@Chris ..

Can you tell what program version does like this?

There have been quite a lot changes with SSH since 5.15, so program version is important!

Did you try the same with 5.2 beta5 ?

[peterlaursen]

As a registered user you can always download latest version from here:

http://webyog.com/en/download_latest_sqlyog.php

You will need your OrderId and e-amil address to download.

You can 'install over' what has been installed.

BTW: You got a PM!

[peterlaursen]

If I understand you correctly this is not possible.

http://webyog.com/faq/31_106_en.html.

explain:

Quote:

.. use my new registration without reinstalling Windows XP

why a 'new registration' if you had one before?

[peterlaursen]

yes …

If you have the necesary privileges. With cheap shared hosting it is not always the case. But with your own 'dedicated server' you probably have. You will need SHELL-access of some kind. FTP-access won't do. And you (some OS user that is under your control) must have EXECUTE privilege to the sja – and write access somewhere in the folder tree where SJA can write its session- and log-file.

Actually you will not need to 'install' anything. We only distribute the .tar.gz – no RPM or DEB packages as SJA has no dependencises. Just unpack the achive (.tar.gz) and copy the sja executable to the server. Log on from some remote shell and execute it (“./sja “) or configure crontab to execute this command.

Please read these FAQ's: http://webyog.com/faq/category25.html

and this article: http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

[peterlaursen]

Please read this FAQ:

http://webyog.com/faq/27_114_en.html

as a minimum you must specify the jobfile as a parameter – on Linux when running from current directory (and jobifle is there too) like

Code:

./sja jobfile.xml

[peterlaursen]

Situation is that this weekend is a significant Holiday Weekend in India (Mahatma Gandhi's birthday on Monday). All the boys from the office have taken a short vacation to join the Birthday Party and have ice-cream with the other kids. 😉

We did study this briefly this week and it does not look very difficult. However I cannot commit anything (and no specific time in particular) before Sabya (our server geek #1) gets back by mid next week.

I think it is likely to have it included with the first 'service release' following 5.2 (5.21 that will be).

[peterlaursen]

@Firestorm9

In the release notes we will for the future add a 'credits' paragraph.

Shall we credit this to 'Firestorm9' or you want another name there?

[peterlaursen]

you are right … the button could be smaller for instance.

I believe this is the same with all Windows Locale.

[peterlaursen]

To run SQLyog on Linux you will need to install Wine first. I do not think that is normal to have Wine on RHEL, but it you can install it you can install SQLyog too. You can use the SJA for Linux however. It runs natively on Linux.

[peterlaursen]

Syncing a very big productions database every 15th minute …

much depends on data structure, server resources and connection quality.

Please read this article:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

.. an understand how to use the and the options.

[peterlaursen]

One question only please! 🙂

Quote:

I am running mysql 3.23.39

I think you should realy consider upgrading MySQL on your local server! 3.23.39 is a very old boy! You can actually read here http://www.mysql.com/company/legal/mysql_l…ycle_policy.pdf that MySQL AB is very close to completely drop support for 3.23!

MySQL does not care much about compability between versions. Especially versions before 4.1 and after have issues with restore/backup. Charset management, TIMESTAMP implementation and more. SQLyog has no option for 'backwards compatible backup'. You will need to edit the .SQL file. Note however that the backup 'powertool' of ENTERPRISE version has an option to deselect UTF8-encoding.

Quote:

… has now up graded to 4.1.2

I doubt this! 4.1.2 is an early alpha. You mean 4.1.21?

[peterlaursen]

No you cannot.

This is a special Access feature and not a standard SQL feature.

In Access you can actually just use a non-existent column name and it is treated like a parameter that can be substituted.

SQLyog is a SQL-based database client. We can only support what is supported by the server!

Of course such parsing functionalities could be implemented in the tokenizer/editor (just as 'DELIMITER' is). I shall not exlude that we will some day, but it is not priority! With MySQL most people would use a FORMS feature of (D)HTML or a scirpting language for this.

[peterlaursen]

You are right .. we have no GUI filtering functionality in SQLyog as of now.

There are plan for such things. My best guess would be that it will be available by 2nd quarter 2007.

What you can do now is to use the favorites feature to store queries.

[peterlaursen]

We have now studied your code.

Quite a lot of small things that we missed is there.

We will definitely try to 'put that in' next week before RC1 release.

[peterlaursen]

OK .. we must then realixse that there is an issue.

this is report no. 3 of its kind.

However please still try beta5 when avail!

[Author]

Posts