[DonQuichote]

No, it is a built-in function in PSPad. Every known file type is descibed by “highlighter settings” (see screenshot). If you give a path to a windows help file (.hlp or .chm), pspad will launch it if you press alt-F1. It will call it in such a way that the selected text is passed as a search string (or the word the cursor is in, if nothing is selected). It is called from the editor window.

So if you are writing an SQL command that you do not use often and are unsure about the syntax, you select the keyword and press alt-F1 to see the help topic on it.

[DonQuichote]

If you mean you log in as root on the remote system, that may be configured to be impossible. On some systems the root user is disabled, meaning that you can not directly log in as root (for instance Ubuntu: you should use sudo instead to become root temporarily). Also, root login through ssh can be disabled in the sshd config on your remote system.

But if you have root access, why don't you create or use a less dangerous user for the database handling?

[DonQuichote]

MZ are the first two characters of an .EXE file. Are you sure it is a database dump?

[DonQuichote]

peterlaursen wrote on Sep 11 2007, 10:34 AM:

Can you explain 'hardly visible' ?

I think it just means that MySQL comments are nowhere to be seen in the interface, except for when you really search for it in the object tab. I use comments on database objects often, and they are meant for colleague programmers and database maintainers (which includes myself after enough time has passed). These comments often hold maintenance hints (“uppercase only”, “Not a timestamp, update by hand”, …). So ideally these comments should reach my colleagues whenever they use the database with a database frontend.

peterlaursen wrote on Sep 11 2007, 10:34 AM:

Tooltip ('hovering') on Objects in Object Brower is a nice idea.

But I am not sure that I think COMMENTS is the most important information for such tooltip.

That is what PhpMyAdmin does, and I really like it. Off course, you don't “hover” for the fun of it, so the presence of a comment would probably have to be visible by an overlay icon or something like that. Alternatively, you could add a comment entry in the treeview, but that would probably take too much lines of space to have a nice overview of the structure. I could not think of anything else I would rather have in the tooltip.

[DonQuichote]

peterlaursen wrote on Aug 18 2007, 10:15 PM:

hmmm ..

first: we do not at all yet (though it is planned) support sorting from RESULT pane/tab. Do you mean DATA pane/tab?

Yes. I Select the table and click the Table Data tab.

Quote:

second: as `intIpLookUpId`is the 1st column according to the CREATE TABLE definition

this

… ORDER BY `intIpLookUpId`;

and this

… ORDER BY 1;

is exactly the same! So I believe this is NOT the issue! (note it is 1 not '1' !)

Thanks for the quick response.

I did not know that, and frankly it surprises me. I have used the order by clause with the random function often enough, so order by 1 would just be a special case of an expression. But you are probably right that it is the same.

Quote:

Please give a detailed example of this “but the sort order did not display correctly”

1) a DUMP of a small test table (small means SMALL – no more than 15-20 rows and 4-6 columns!)

2) tell EXACTLY what/how you are doing! Clicking on the column header, or … ?

3) screendump of how it sorted

4) description of what you expected

BTW: don't use a beta version when a more recent stable one is available!

OK. I did a further test and the results seem to be in the right order in the data pane after clicking the column header. But the data pane scrollbar behaves funny. I have to scroll very far down (I have to select “show all” to reproduce it) to see the primary key field drop back to small values again. This is after about 64000 records, so this could be a two-byte integer cast problem. After I release the mouse button, the scrollbar jumps back to the beginning, where those records really are (when still dragging it follows the mouse cursor like expected). Releasing the mouse button on a record before the “drop-back” point works like expected.

Again, I am using wine, so this could be a wine issue.

Alas, to make a screenshot I have to release the mouse button and this issue seems to need a large table. And I'll upgrade. I just searched the project issues and the forum for this issue and could not find it, so I assumed it still exists.

Best regards.

[DonQuichote]

Just a simple one, in combination with baretail. Note that baretails shows it as “ansi”, while the query is sent in utf-8. Oh, and with all these windows programs, you'd barely notice xubuntu underneath… 😉

[DonQuichote]

uyuni wrote on Jul 11 2007, 11:10 PM:

Is nobody interested in this feature?

It would allow me to do things I can't do now.

You could take a good look at the tunnel PHP file and implement it yourself. It should not be that difficult. At first glance, I would say that you would have to mofidy the ExecuteSingleQuery function. If your modified tunnel file then checks for an “sql commented pattern”, like “– SCRIPT “, you can easily run scripts on the server without having to modify SQLyog. Personally, I do not like to be able to run serverside scripts from a database backend. That would just be another possibility of attacking a web server.

[DonQuichote]

This example should provide enough info to get started:

[codebox]Public Sub TestMySQL()

Const CONNECTION_DETAILS = “DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;PORT=3306;DATABASE=mysql;UID=YourUserName;PWD=YourPassw

rd;OPTION=18475;”

Dim objConnection As ADODB.Connection

Set objConnection = New ADODB.Connection

objConnection.Open CONNECTION_DETAILS

With objConnection.Execute(“SHOW TABLES”)

While Not .EOF()

Debug.Print .Fields(0).Value

.MoveNext

Wend

.Close

End With

objConnection.Close

End Sub[/codebox]

Have fun.

[DonQuichote]

peterlaursen wrote on Jul 4 2007, 03:18 PM:

A user asked this question by creating a new entry in the FAQ:

“i have recently started using VB 2005 and i am using SQLyog to create the database. Can any one tell me what i need to do to connect VB 2005 to SQlyog database. All i have done so far is just created the DB and configured my ODBC driver from the control panel. when i try the connection in Vb it is asking for a .mdf file or something like that but i dont have one, any assistance will be appreciated”

This will not be approved as a FAQ entry as it is not related to the use of SQLyog!

But anyone knowing about VB and MySQL please answer this! HERE!!

and first reply from me: you do not connect to SQLyog database. Because there is no such thing! There is a MySQL database!

First, “VB” can be VB 6.0 or earlier or VB .NET. The difference is about as large as between c++ and java.

Second, VB cannot connect to a database at all. This is a bit nit-picking, but you have to use an external library to do so. This can be either DAO (old but still the best for filesystem databases), ADO (newer) or ADO .NET (for VB .NET and the most current and heavyweight library).

Naturally, they all use different methods of specifying a connection string. One thing to note is that for DAO, an ODBC connection string must start with “ODBC;”, while ADO connection strings will refuse to work if you do that.

You can give the name of a system DSN (which may be the “configured” word in the above description) or just a full ODBC connection string. See http://www.connectionstrings.com/ for examples of those.

Hope this is of any help.

[DonQuichote]

Please note: Some MySQL versions do not use the lower_case_table_names setting everywhere. I use MySQL 5.0.22 locally, and it uses lowercase table names in the SHOW TABLE output even though I have set it to store the table names in the correct case.

It seems that SQLyog uses the SHOW TABLE command, so this leads to problems on input on a Linux server later. The precise problem is that all names have the correct case, except in the FOREIGN KEY clauses. If I repair the foreign key clauses in the dump, the dump files work just fine for communication with a Linux server.

[DonQuichote]

The PHP code is not that difficult to understand. Just note that all variables start with a $ character and that there are two possible libraries used for the MySQL communication: mysql or mysqli. That explains all those switch statements.

So if your need is large enough, you can give it a try yourself. I do not think the webyog people would refuse a helping hand…

[DonQuichote]

peterlaursen wrote on Jun 8 2007, 09:48 AM:

There may be thousand ways to implement 'client side encoding'. We do not support this. SQLyog displays data as they are stored in the database.

How did the texts get in the database? If it is from an self-written application (a PHP page, for example), make sure it sends a “SET NAMES utf8” (or whatever other encoding you work with) command directly after connecting. If you do not do this, MySQL defaults to latin1, even if you set a different default in the config file of the MySQL server.

Hope this helps.

[DonQuichote]

peterlaursen wrote on May 10 2007, 10:33 AM:

But if you know more about those issues than I (and that would not be hard!)

you are welcome to propose improvements to the FAQ's on connection issues!

I am far from an expert also, but I encountered some thing about it in the MySQL documentation: http://dev.mysql.com/doc/refman/5.1/en/can…-to-server.html

I hope it makes sense.

[DonQuichote]

peterlaursen wrote on May 9 2007, 11:49 AM:

Yes we should always remember that a computer can have a non-typical host's configuration!

It's a Linux thing. “localhost” refers to a “named pipe”, whereas “127.0.0.1” will result in using a tcp connection. I should have realised this earlier.

[DonQuichote]

peterlaursen wrote on May 8 2007, 01:38 PM:

I cananot see anything wrong!

Could you arrange remote acces to that server. We only need access to a 'silly' databases.

Do not write details here but create a ticket with details

Even better: I just found out what the problem was. The remote database is on a linux server, where localhost is not the same as 127.0.0.1. So replacing the default “localhost” with “127.0.0.1” solved the problem.

[Author]

Posts