[CalEvans]

create table myTable

(

myTableID bigint(22) auto_increment not null,

myInformation text,

) Type=InnoDB;

[CalEvans]

go to the history tab, cut and paste into a message the exact create table that SQLyog is trying to execute.

=C=

[CalEvans]

Can't do it.

You need to build a foreign key in the second table that is the primary key of the first. THEN you can build the relation and add the cascading delete.

=C=

[CalEvans]

select *

from tableOne left join tableTwo on tableOne.ssn_is_not_a_primary_key = tableTwo.ssn_is_not_a_primary_key

where some_condition_here.

=C=

[CalEvans]

IANTC,

I do not believe that SQLyog connects to MySQL the same way you are doing it. SQLyog uses the C API whereas ASP will use the ADO. (Which is ODBC in a pretty wrapper) The C API does not have (to the best of my knowledge) anything akin to the connection string. You might want to post to the mysql mailing list. There are people there who use ODBC to connect (I've seen messages about this) and they could probably give you more help.

Have you checked the log file of mysql? Watch it as you are trying to connect. Are you getting that far? If it is logging then it should be logging the error as well.

=C=

[CalEvans]

Screenshot from SecureShell

[CalEvans]

1st question

Can you connect to the server using ssh? (Do you get the shell prompt?) If you can't get that far then nothing else will work.

It sounds to me like the difference is you don't need to put anything in the IP address slot of either the remote or the local.

Also, remove the one you setup in remote. I'm not sure what that area is for but I NEVER use it. (and I have about 20 port forards setup for different things.)

HTH,

=C=

[CalEvans]

It looks (and works a lot like the old iSQL tool that M$ QA grew out of. Hopefully, SQLyog will not become the bloated pig the QA has now become. I'm hoping it will stay focused on lean and mean. (Something M$ has YET to discover)

BTWThe issue of copyrighting a L&F was setteled a long time ago with Lotus and M$. (M$ “innovated” by ripping off the L&F AND the keyboard interface of Lotus 1-2-3. Lotus sued and the judged rules that you could not copyright a L&F.)

=C=

[CalEvans]

To the best of my knowledge, SQLyog will ignore my.cnf if present. Simply because that file does not belong to it. Even if it tried to use it, SQLyog could do nothing with the datadir setting as this is a server level setting and cannot be changed while the server is running.

It is my understanding that unless you are using InnoDB tables, you should be able to stop the server, move the data dir to anywhere on the computer, repoint the datadir setting in your server control file (whatever it is called in Windows) and start the server.

what does winmysqladmin say your data dir is? Unless that has changed, you haven't changed the data dir.

More help can be found at MySQL's Website

HTH,

=C=

[CalEvans]

mysqldump will do this.

=C=

[CalEvans]

Craig,

Quote:

The default should be to just copy the double data as is.

It does do this. The import feature loads the data you tell it to into the container you give it. If the container cannot hold the data then it has to do something with the extra. In this case it rounds it. This is normal, it is to be expected and it's MySQL doing this part of it anyhow.

It is the responsibility of the developer to make sure that the container is the right size. 52,0 is an arbitrary default chosen by the SQLyog team. There is no setting that they could use that would ensure that it works perfectly every time. The problem here is that the default does not work for you in this particular case.

For this to work the way you want, SQLyog would have to pre-scan your entire input file to make sure that all fields IN ALL ROWS will fit within their allotted space without truncation or rounding. While this might be a cool tool to have it is not the domain of SQLyog. (and I pray to God that it never becomes the default behavior because it could add days to some of my imports!)

Sorry, this is probably not the answer you were looking for.

humbly,

=C=

[CalEvans]

Hmmmmm….never seen this happen with InnoDB.

Re-load from a backup, recreate the experiment, watch your MySQL log file. Did the begin get into the logfile? Does your errorfile show anything?

BTW, it is default behavior for rollback and commit to return 0 rows affected. That's really for select, update, delete although all DML commands return the number of rows affected.

HTH,

=C=

[CalEvans]

Wonderfully written and syntactically correct! 🙂

=C=

[CalEvans]

This is a mysql bug or issue. (I'm not sure it's a bug. It may be designed that way)

Show process list gives back a table of all chars (or varchars) SQLyo is actually handeling them correctly.

=C=

[CalEvans]

If you have ssh access to the server then you can tunnel mysql (port 3306) over a ssh connection. It looks to the server like you are connecting locally.

1: setup the port forwarding in your favorite ssh client. I use http://www.vandyke.com's SecureShell

2: connect your ssh client to your server.

3: If your tunneling is working correctly then fire up SQLyog and tell it to connect to the server localhost. put in your username and password for your server, click the connect button.

It works for me every time. I have 1 server that I keep closed off to the public but using this technique I am able to use this wonderful tool with it.

HTH,

=C=

[Author]

Posts