[peterlaursen]

it was more than just work … it was TEAMWORK! 😀

[peterlaursen]

I'd let someone else answer this question

Quote:

What do I have to do, to make the remote connexion to MySQL database using an ODBC, is it possible having OPENSSH well configured?

Anything I could say on that would be so unprecise that it won't be any use!

[peterlaursen]

YUP!

that other problem of mine is also fixed by your code-tweak! 😀

[peterlaursen]

I confirm that your code-fix also solves the problem on my local installation! 😀

Now I will check whether it also fixes that other issue that I had.

That would be nice! Actually until now I have believed that it was a php5-related problem only, but hope that this is it!

[peterlaursen]

@royvarley

it is always a pleasure supporting people who themselves can contribute to the solution! 😀

But I don't know if that is all there is to it. Actually I can tell you that I have been able to reproduce the problem on my local installation – NO MATTER magic_quotes settings. On my webhost I can't reproduce!!

But your idea of turning on php logging was perfect! I think they have all needed info now. And since you've found your solution there no no hurry. better RIGHT tthan FAST!

[peterlaursen]

could be a crazy idea ….

but what happens if you copy to a file and not to clipboard ?

[peterlaursen]

Quote:

MySQL Version = Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

SQLyog Version = 4.07

Using direct connections.

What is “MySQL Version = Ver 14.7 …” ?

I know what MySQL 4.1.8 is. That MySQL was “built-in” the Linux-distribution I guess ??

I understand that you purchased SQLyog recently, so I can't know how much you have been using it for other purposes. But are there any other problems experienced with the porgram ? If you click on a table in Object Browser and select the OBJECTS-tab will the table definition then display correctly ?

Are you trying to sync all 200 tables “in one round”. If yes, will it solve problems to have a smaller number of tables ?

[peterlaursen]

We need more info to get further!

But honestly I don't know where to start.

Probably some sample data are required. If you don't want to attach them here, I am sure that you can mail them confidently to Ritesh in the morning.

Could it be a user privilege problem? If you don't already try ROOT (or the user with most priviliges available) on both servers!

Quote:

This feature was the entire reason why we bought SQLyog Enterprise. When can we expect a fix for this feature?

My humble opinion: don't be so sure that SQLyog needs a fix here. It could be your configuration that needs a fix! <_<

[peterlaursen]

I can't reproduce it. This is an example from struct-sync across MySQL-versions 4.0 and 5.0 using HTTP-tunneling with 4.0

Code:

/* Drop in Second database */
drop table `jazcyk_test`.`Important information`;

/* Drop in Second database */
drop table `jazcyk_test`.`mp3_filer_copy`;

/* Alter table in Second database */
alter table `jazcyk_test`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL ;

/* Create table in Second database */
create table `jazcyk_test`.`whertogo` (
`Id` int(10) unsigned NULL   ,
`goname` varchar(60) NULL   ,
`towncity` varchar(50) NULL   ,
`type` varchar(50) NULL   ,
PRIMARY KEY (`Id`) ,
KEY `citieswhertogo` (`towncity`) ,
KEY `townix` (`towncity`)
)Type=InnoDB;

[peterlaursen]

I'll do some research on that.

In the meantime please answer:

1) MySQL server versions ?

2) SQLyog version ?

3) Conection types (direct/HTTP/SSH) ?

[peterlaursen]

Quote:

Has the ability to select one or more rows (to copy to the clipboard) also been dispensed with?

I just tried.  it seems that the function is no longer available from DATA-tab.  however it is from RESULT-tab.

You can execute

Quote:

“select * from tablename”

and do it from RESULT-pane.

[peterlaursen]

I have to go for an hour or two. But I could easily change my php-configuration and test with mq = “off” tonight.

I'll look into the thread later to see if there is a need for it.

[peterlaursen]

well, maybe the php tunneling file assumes another stripslashes php-configuration.

[peterlaursen]

your ar right as far as stripslashes goes:

http://www.php.net/manual/en/function.stripslashes.php

is the php directive magic_quotes set to “on” with the php configuration ?

from php docs:

magic_quotes_gpc boolean

Sets the magic_quotes state for GPC (Get/Post/Cookie) operations. When magic_quotes are on, all ' (single-quote), ” (double quote), (backslash) and NUL's are escaped with a backslash automatically.

magic_quotes_runtime boolean

If magic_quotes_runtime is enabled, most functions that return data from any sort of external source including databases and text files will have quotes escaped with a backslash.

[peterlaursen]

Quote:

I rather think that the should have been \ in the original xml.

OK – it seems that you know what you are doing 😀

I thought that stripslashes() should work on / and not .

But rather strange then that Ritesh didn't get an error with your data and I did not either with my data!

[Author]

Posts