[Mike_123]

peterlaursen wrote on Nov 26 2006, 11:23 PM:

There is a refresh option in the 'edit' menu.

The corresponding icon is the 'recycle' icon.

To refresh the list of databases first select the most upper level (the connection) and refresh.

To refresh the list of tables in a database first select the the database and refresh.

I found it (F9) thanks. It might have been more obvious if F5 was used to refresh instead of F9.

Suggestion: It would be nice to link to MySQL's documentation for SQL syntax from the toolbar (or help menu). Quite often I need to refer to SQL manual and a link would speed things up.

I'm really getting to like SQLyog. I've used another MySQL mgr for years but SQLyog is starting to grow on me. 😉

Mike

[Mike_123]

peterlaursen wrote on Nov 19 2006, 11:54 PM:

I am sorry, but I do not understand the problem. What had you expected to see? If you select a table in the Object Browser (the left column of the program) and click the DATA tab it will show you data. If you check the 'select all' box, all data will be loaded and shown.

Peter,

It appears he has run “Run MySQL Backup Command” and has backed up a set of tables to another directory. He needs to know if all rows were backed up. For example, is there a way to verify the row counts of the tables between the original database and the backup?

Mike

[Mike_123]

peterlaursen wrote on Nov 23 2006, 12:34 AM:

You need to write the two (or more) queries in the same query window like

Code:

show databases;
show variables;

or

Code:

show databases; show variables;

and presse 'execute all' (double green arrow or Shift+f5) and each. Now each query will open a tab.

We have plans to add a feature to 'lock'/'unlock' a result tab but it will take some months.

The queries are executed at different times, so I wouldn't want to execute them together. Let's say for example I want to find all invoices over $1000. I run that query in one window (Window #1). I now want to look at the invoice details for each of those invoices so I open up another query window (Window #2) and manually do a Select on each InvoiceNum to get the details. And I do this repetively for each Invoice that was displayed in window #1. Well, if both queries share the same Results window, then I lose the results of the first query. I don't really want to rerun query#1 each time I run Query#2.

So all I'm saying is each Results window should be tied to each query window. It would also be nice if we could detach them from the tab so we can look at the Results of 2 or more windows at the same time. The only way around this right now is to run 2 or more copies of Sqlyog and that seems like overkill.

Mike

[Mike_123]

peterlaursen wrote on Nov 20 2006, 11:45 PM:

@Mike .. Plase only ONE thread in the Forums per issue. It is easier to discuss if everything is the same place.

1) Of course SQLyog supports the “;” delimiter symbol. Also multiple statements delimited by “;” are supported. Please explain more in detail what porblems you experience!?

2) Your problem with user-variables (@….) most likely is that you are using a HTTP-connection. This is not a SQLyog issue but a limitation with the PHP mysql_connect() method. Refer to:

http://webyog.com/faq/21_103_en.html

You can try to replace mysql_connect() with mysql_pconnect() as described in this FAQ:

http://webyog.com/faq/21_103_en.html.

Maybe it works – maybe not. It depends on the server configuration. Not only PHP but also Webserver must be configured to allow for in. In PHP the php.ini must have the line “persistent = on”

Also note that SQLyog reconnect autmatically if connection is lost. User-variables are connection-specific so after reconnect the user-variables of previous connection are gone.

Yes, sorry about that but when I first posted the message I got an HTML error and thought the message failed to post properly so I reposted before I lost the text. Then when I saw 2 threads I had no way of deleting the 2nd one.

—-

Ok, I solved it. The problem was between the keyboard and the chair. 🙂 When executing multiple SQL statements in SQLyog I should have been pressing “Execute All Queries” Shift-F5 and not “Execute Query” F5. I would have liked to have seen the Execute All Queries keystroke set to one function key, like F9 because a lot of my queries have multiple SQL statements in them and reaching for Shift-F5 is going to be a pain.

Mike

[Mike_123]

larsen wrote on Nov 17 2006, 02:20 AM:

Well, I think you got me wrong. I don´t want to change sql.

At the moment it is only possible to export whole tables as CSV data. But I just want to export records of a certain kind.

I agree. CSV export is something easy to add if you have the source code and can be done in a single procedure. You have access to the table definition so you know which fields require quoting.

Mike

[Author]

Posts