[peterlaursen]

I am not quite sure that I understand.

SQLyog has nothing to do with the php scripting language. It does not use php itself and does not “understand” the php language

But if you want to insert a php variable name as a string like $varaible in a char/varchar/text/blob-field, then just enter that!

From DATA and RESULT pane you shall neither use escaping or surround strings with quotes – SQLyog does that automatically. SQLyog is a GUI.

From the SQL-pane escapeng must be there and strings should be surrounded by quotes of course, because in SQL-pane what's is entered must be valid SQL.

[peterlaursen]

But you have the same problem with the account of mine!

That's strange!

Try checking authentication anyway and enter jsut somthing .. the server won't use it anyway!

[peterlaursen]

OK.

Obviously SJA does not even try to connect!

Did you try to tell the SJA that SMTP need authentication?

I can do that successfully (and actually enter garbage for UID and PW!) even with accounts that don't need authentication!

I don't know much about protocols and all that, but it seems that SJA won't do the job before it has authentication details. It must “mis-interpret” the information that the server sends or the server has an error/non standard issue in the information.

[peterlaursen]

we go back to the Forums after PM'ing.

Is it an error msg like the one below you get?

Try to enter the same mail-adress in all three fields.

Just the mailadress that you noramlly use!

[peterlaursen]

Quote:

I have entered my ISP's SMTP server (as entered in outlook) witch does not require authertication and it will not connect.

That should not difficult. let's see if it is something specific for your mailserver

Well wait 2 min and I'll PM you one of my never-used old accounts. Try this!

I'll inform you if I get a mail. Hurry up! It is high bedtime here!

[peterlaursen]

OK …

Maybe I was a little bit too fast. I have no SHH-host available outside my own network, so there could be an issue that I can't reproduce. Buit if there is it must be an issue with the SSH-tunneling-daemon running on your lokal port locking hostname “localhost”.

But I have now tried with a dyndns-setup to my own SSH-server and still can't reproduce.

Could we se ALL tabs in the connection manager for the two connections ?

(you may 'paint' ip's etc.)

[peterlaursen]

Like this:

start SQLyog

right-click a table in Object Browser

export .. export as CSV

now press “change” – button

enter the semicolon as field-delimiter.

See pic attatched. These settings work fine with Excel here

But still I prefer to use MS-Query when transferring data from MySQl to Excel.

BTW: it is no SQL-issue!

[peterlaursen]

Do you remember to uncheck the “Use tunnelling” on the tunnelling tab ?

Have you saved your connections with the “connections manager” ?

I can't reproduce your problem!

[peterlaursen]

and @CalEvans

u must start a BLOG. If you don't, you will be mobbed when you are not here 😀

(sorry that wrote “mopped” in the first palce. But you will be that too 😀 )

[peterlaursen]

@CalEvans

u r 2 slow!

Problem is that if you use for instance komma as field delimiter Excel will create all data in one column. With Excel you should use semicolon!

and that was the question! 😀

[peterlaursen]

1) Transfer MySQL data to Excel:

(sorry that I wrote Access in the first palce – that was wrong!)

there are a lot of different settings for the export. You should set the field delimiter to “;” (semicolon). This will be understood by excel

However I prefer not to use SQLyog here. Install MS-Query (an optional component of the MS Office Suite) and the ODBC-driver for MySQL. Then you can generate a query to MySQL from inside Excel using either the MS-Query-GUI or SQL (the sort of SQL that MS-office uses)

2) Filtering.

You must learnn a little bit of SQL! filtering is done with the WHERE-clause

This query:

SELECT column1,column2, etc. FROM people WHERE age = x; (or 'x' if variable-type is some string type)

will open a filtered list in RESULT -pane

A graphical tool for filtering and sorting (like in Access) is planned for a future version. I don't know exactly when:

[peterlaursen]

Not a fully functional functional two-way sync. it is an “ODBC import to MySQL” or “Migration to MySQL” tool basically.

However there are so many options in the ODBC-tool that you might be able to use it anyway. Depends on your data. Have a look at it. 😀

If it is a localhost <> webhost sync or something like that it would be much simpler to have MySQL installed both places. SQLyog Enterprise can two-way-sync two MySQL databases.

[peterlaursen]

Quote:

Can I make a feature request (assuming it's possible to implement):- Can I use a wild card in the database name? My webhost prefixes every database name with the account name, so it would be very handy to specify “accname_*” for the database and have just these databases listed. I can imagine this being useful in other situations too.

I think it is a pretty good idea – except for that I'd prefer SQL wildcards (% and _) instead of windows wildcards. Also then a “literal wildcard” should be escaped as according to MySQL escaping standard. domaninuser_database must then be entered as 'domainuser_database' and domainuser_backsash should be entered as 'domainuser_backs\ash' or even maybe 'domainuser_backs\\ash' (there is double escaping in a LIKE-clause). Just in case that the wildcard is used as a litteral.

I thought you had chosen only some databases form the connection dialogue!

BTW I have several versions of MySQL servers here. One is 4.0.25 and it is not a problem with the server as such!

[peterlaursen]

And if server uses ANSI the ' and ” and ` have other meanings then if it does not.

[peterlaursen]

a sql file is a series of statements only. You can cut it into pieces! Just add the statement “use `db_name`;” at the top of of each piece, if insert-statements don't use full syntax like `db_name`.`tablename`.`columname` but only `tablename`.`columname`.

Beware that “backquotes” are not apostroph's!

[Author]

Posts