[peterlaursen]

Try reading the SQLyog help file!

It is pretty good on tunnelling.

There also are some FAQ entries avaiable, especially these ones:

http://www.webyog.com/faq/21_19_en.html

http://www.webyog.com/faq/22_44_en.html

http://www.webyog.com/faq/16_66_en.html

What kind of tunnelling do you want to use?

What did you try ?

[peterlaursen]

All this (and solution to more localization issues too) is planned for version 5.1.

http://www.webyog.com/faq/5_20_en.html

Actually you could search a little bit here and find a post only a few weeks old telling that! It will be possible to specify charset and collation on a column base. there will simply be added a column to the CREATE TABLE and ALTER TABLE GUI's from where to specify that.

Ritesh may be able to be more precise, but I think the first 5.1 beta will be out in a few weeks.

[peterlaursen]

Thanks … I got the point. It is svchost.exe that is displayed because it is a scheduled job. I did not realize that.

I can make a job run minimized starting like this:

http://www.webyog.com/faq/27_74_en.html

When you have created the shortcut you can right-click it and from the 'shortcut' tab choose 'run as minimized' (what it is exactly in English I don't know – but something similar!) It works fine here.

But I have not succeeded in trying to run a scheduled job minimized. I don't know if it can be done when scheduling a command-line tool like SJA at all. An attempt to schedule a shortcut fails here.

[peterlaursen]

Quote:

Maybe Yahoo! will upgrade soon, but I doubt it.

I doubt too. Most ISP's seem to think that the basic functionality of 3.23 or 4.0 is what customers need. And for use with scripting languages such as PHP and personal webpages they are probably right!

[peterlaursen]

oh that's fine …

but which one is you ? 😀

[peterlaursen]

yeah … I like the dolphins too 😛

[peterlaursen]

confirmed!

Another solution could be to issue a 'use ..' in the background when table for editing is selected from drop-down.

[peterlaursen]

Well .. this is a matter of priority basically.

Since I completely stopped using MS-Office it is not my priority <_< . I would rather request OpenDocument (XML) -compliance then! But still I don't think it will solve everything. Data in the SQLyog RESULT and DATA panes are without TYPE I believe. So the data will need to be re-read from MySQL. SQLyog is only able to send strings from RESULT and DATA panes as of now.

[peterlaursen]

Quote:

but I'm fairly certain that I did not have the problem using SQLyog 4.1. I upgraded to 4.2 then 5.0 and had the problem starting with them.

Sounds strange in my ears! With the most latest SQLyog builds SQLyog will refuse to even try. Before that we had those errors.

Maybe it would have worked with some datatypes. But I doubt it!

There has been no changes on the server side? You could not have been using 5.0.15 for very long! and 3.x and 4.0 will sync OK (actually 4.1 will too if there are no TIMESTAMPS and similar variable types).

[peterlaursen]

There are more ways. ther always are with Linux!

I use SUSE 10 but I dont think it makes big difference.

I suppose the standard command interpreter on RH is the 'bash' program as well? Then it should be quite straight.

Do you just want to start start the batch from console or schedule it? But in any case

First simply build the batch file with the two lines needed from a texeditor (Kwrite, Kate etc.). Save it. Any name will do. Linux has no conventions in that respect. I just tested with a file named “Tekstfil”

Now be sure to have privileges needed – especially execute privilige to the file(s) and write privilege to the directory where the SJA must write. Configure that from GNOME or KDE or execute 'CHMOD' command(s) from shell.

Now open a command shell in the directory where the batch file is and type ./Tekstfil or what ever you named it.

To schedule it you must use the CRON program. Type 'man cron' and 'man crontab' from shell to display man pages. But probably RH8 has a graphical Interface for managing cron as well and a user guide that is more reader-friendly than the man pages.

[peterlaursen]

To my personal surprise it does not seem to be there!

I thought it was there … but one of the TODO's that never got finished I guess!

putting this in the XML-file

QUOTE

…mail-parameters here

before the tag has no effect.

You can execute a and a from a batchfile

And BTW: You are using SJA 4.0. It is an old version! Current is 4.2.

Is it Windows or Linux version you are using ?

[peterlaursen]

Quote:

s we use periods to format date (today is 29.11.2005 or just 29.11). Americans may have less problems with it (11/29/05).

I think all Excel localization cause equally much trouble is this respect! The code of the program is the same. It is only display that differs.

I have experienced quite often that the playing time of a .mp3 – say 3:09 – was converted to a date like thisyear-sept-3rd or thisyear-march-9th (I don't remember right now).

Basically I think the problem is three:

1) SQLyog does not keep track of TYPE of data displayed in DATA or RESULT pane. It is all treated as strings when in the grid views.

2) Windows clipboard does not either – or how does it?

3) Even if data types were 'kept track of' some way you would still have problems with incompatible data types between MySQL and Excel. The FLOAT type is a very good example of this (using FLOAT internally takes some very specialized mathematics and it is represented internally very differently compared to a REAL or DOUBLE). I don't think Excel supports it natively. Actually I think that this

Quote:

Excel then puts “38600.00” instead of “5.09”!

is a FLOAT conversion (or rather lack of same!) issue. ODBC and JDBC handles type conversions to some degree – clipboard does not!

But as far as 1) goes I think that should be fixed. Actually I believe it will have to be to solve old issues with column defaults such as NULL, CURRENT_TIMESTAMP, SESSION_USER etc. Actually here http://www.webyog.com/faq/5_20_en.html I wrote

Quote:

When saving data from the grid view of the DATA or RESULT -panes the grid shall be parsed for NULL, type, functions and (predefined) variables such as (to mention the most important one) CURRENT_TIMESTAMP.

and no one contradicted that yet! If a more 'smart' way of handling Excel could be done alongside it is of course OK with me too.

But to me the database issues (overwriting of defaults) are far more important to me than any M$ issue.

[peterlaursen]

What are the versions of the MySQL servers involved.

And what is the SQLyog version ?

You can read this:

http://www.webyog.com/faq/10_68_en.html

I remember getting the 'NULL mismatch' error occurs when trying to sync my local 5.0 with MySQL 4.0 at my webhost with (I think) SQLyog versions before 4.1. But the most recent SQLyog versions should display an error instead.

If the MySQL versions are 'two much different' for the sync tool, you may be able to use ODBC. Read at the bottom here http://www.databasejournal.com/features/my…cle.php/3550146 (chapter 'MySQL and MySQL').

[peterlaursen]

@hunyi

I jusst mailed you a copy.

[peterlaursen]

Quote:

The worst thing are numbers (floats) being interpreted as dates:

This is a known problem with MS-Excel. It is supposed to 'help' users. ANYTHINNG that Excel can interpret as a DATE-type will be.

The leading zero's being truncated is of course because the numerical '7' and '007' are identical. However the strings '7' and '007' are not.

I have experienced both often when opening some text-type file from Excel. Here however you have an option the bypass the automatic functions and specify the type for each column. But I don't think you have that option when using the clipboard.

I think the solution here is to install MS-Query. It is an optional part of the MS-Office suite (it does not get installed with a standard install so you probably don't have it – yet! – but you only need to restart the MS Office installation program and specify it). With MS-Query and MyODBC you won't need any clipboard or textfile as an intermediate between MySQL and Excel. You transfer directly from any ODBC-compliant database such as MySQL to Excel.

And BTW: you won't need SQLyog either 😛

You could also try OpenOffice2-Calc. It is far superior to MS-Excel im my opinion!

[Author]

Posts