[PerFredlund]

Long queries = queries that long (stringwise) when typed out completely.

Heavy queries = queries that take a long time to perform, either because you are selecting/inserting/updating between many tables at the same time or you are operating on very large tables (on fields that are not indexed) etc etc …

Per

[PerFredlund]

If it does not work for blob, it's not really a big deal. Not enough to leave it out completely anyway. Does the ordering simply not work with blob fields ot does it cause some other error/ crash. In either case you should up with some “as good as it gets” solution. Show some information when trying to order by a blob field. Otherwise do the job 😎

Per

PS! Do this at least for the paid enterprise edition …

[PerFredlund]

peterlaursen wrote on Mar 25 2009, 12:50 PM:

We have a releated request recorded here:

http://code.google.com/p/sqlyog/issues/detail?id=350

But to display data from more that one table you will need to execute a JOIN query and display will be in RESULT tab.

Ok, this is probably the best way using sqlyog.

One could achieve much the same thing with a WHERE clause. Trivial example:

SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column3=table2.column3.

Actually, SELECT DISTINCT would be handy here …

This works fine even without defining primary and foreign key(s)

The many JOIN versions can be very confusing. LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN …

There is always more than one way to skin a cat!!

Per

[PerFredlund]

peterlaursen wrote on Feb 24 2009, 11:03 PM:

Please tell the program version and please verify the issue with 8.02 (just released) if you use an older version!

But to this 'I used to have a huge 300+ MB err file' I ask if you are reffering to the sqlog.err file? In what program do you open the error file? Some editor? Are you sure that he memory issue is not with that program? Does 'Task manager' tell that this memory is used by the SQLyog process? Please detail!

If the file has grown that big simply delete or rename it. A new one will be started next time program needs to log an error.

Shouldn't this be doable in the options ?? (max error log size setting ) Everytime a loggable error occurs, check the log size. Create a new file if current file is already too big … File-open-overwite instead of file-open-append.

-Per

[PerFredlund]

peterlaursen wrote on Feb 5 2009, 11:24 PM:

This is not as simple as you may think! Also the term *encryption* is often misused! Let me explain:

1) First of all the password-as-it is will have to be sent to the server(s) – MySQL and possibly SSHD and webserver (with HTPS). For that reason we cannot store a hash or checksum (MD5 or CRC for instance). Simply because it cannot be reverse engineered and we will not be able to authenticate.

Why not? You just encrypt the supplied password and compare with the encrypted stored password. If they are equal then you allow the login.

What you meant to say Peter is probably about uniquesness. Two different passwords should not encrypt to the same encrypted password. Then simple hash or similar would not be sufficient 🙄

Per

[PerFredlund]

Hi. Would a php script do you any good?? You can also write a stored procedure for this, if your mySql version supports is. Why would you ignore tuples that occur in both tables?? Shouldn't ONE of them be included?

And yes a proper PK would efficiently eliminate dulicate entry in the resulting merged table anyhows …

Per

[PerFredlund]

Hi 🙂

I know this can be done with a stored sprocedure, SP (supported in later mysql versions).

(I have needed similar myself in the past, and i'm NOT going to teach you SP's technicalities.)

First make a query selecting all your tables. Then traverse all the tables (cursor) and query all the tables for what you need 🙂

Per

[PerFredlund]

Hi 🙂

Late reply, i just installed the latest 7.14 communiy edition. My Mysql work is a bit on and off, as database development is not my sole task at work. So far this version seems a bit more stable, but quite a bit more extensive testing remains 🙄

Per

[PerFredlund]

peterlaursen wrote on Nov 24 2008, 02:03 PM:

I do not think the settings of your host matters here!

Are you using COMMUNITY or ENTERPRISE version? If ENTERPRISE please first try turning off autocomplete in preferences!

Hi 🙂

I am using the community edition. I do not understand how autocompletetion would interfere with simple gui operations. I am not writing any sql commands when these crashes are occuring. Hmmm …

(If the enterprise edition would (easily) solve all my backup problems i'd gladly purchase a copy …)

PKF

[PerFredlund]

Hi 🙂

I am extremely dissatisfied with the webhost. We will move the site as soon as we get the time. The new host has backup/restore as part of the control panel. It's better to leave a sinking ship than going down with it 😉

Thanx for all help so far 🙂

PKF

** Btw the new host also supports SSH connections 🙂

[PerFredlund]

peterlaursen wrote on Nov 10 2008, 03:58 PM:

Shift+click was supposed to work but I agree that it does not.

Example: you have tables t1,t2,t3,t4,t5,t6,t7,t8,t9,t10 and want to select t1,t2,t3,t6,t7,t8 and t9, then you click t1, shift+click t3, click t6. So far so good, but after shift+click on t9, t1-t3 gets deselected what it definitely should not.

This is a bug!

Hmm. Is there no ready class with the correct implementation??

PKF

[PerFredlund]

How do i do this? I'm only going to dump as a sql file, im not going to copy to other instance of mySql. As i told in the ticket i am also awaiting the webhost to try to “fix” the problem tables. I guess this could wait till after they are done. But i'd like ti know nevertheless. I'm a typical GUI guy, so with commandline i'm a bit lost. Can i do this in community edition or would i have to do this with enterprise edition?

Per

[PerFredlund]

Hi 🙂

I do not have a local mysql server setup. If it helps i will set it up and attempt to copy everything from the host's mysql there. Then try copy, synchrinisation and what not!!

My host does not allow to use the sybc tool as i would need 2 connections. It only allows 1 remote connection. Duh!!!

Per

[PerFredlund]

Hi 🙂

Is anyone following my support ticket (Ticket #6177)

I cannot for the hell of it make backup and restore work. Grrr ….

Per

[PerFredlund]

Hi 🙂

I now added the office ip so that you can test it out. However i cannot find any link to your support, so i cannot creaate a ticket …

Further i now always get a server shutdown message when i log in sqlYog. Refreshing the object browser then always fixes the issue. Very bizzarre.

-Per

[Author]

Posts