[peterlaursen]

Now I understand in detail!

The stripslashes() function removes -character.

Isn't that simply a php-bug?

checked the changelogs at http://www.php.net/ ?

[peterlaursen]

Quote:

This is then translated to:

insert into `roles` values ('183', 'Mr Slate's Quarry', NULL, '1', '15', '43')

which is wrong.

because it should be

Quote:

insert into `roles` values ('183', 'Mr Slate's Quarry', NULL, '1', '15', '43')

Agreed ?

My belief is that it be a problem with repective php & mysql versions and configuration!

[peterlaursen]

Quote:

Is there any other way to do this with out using pc-anywhere?

You won't need to use any sort of software like this. MySQL can not only connect to clients running on “localhost” but to clients everywhere in the world.

SQLyog and its “child” the SJA (Sqlyog Job Agent) are (a) MySQL client(s) and will connect to MySQL servers all over the word if Local Network Configuration on the remote place and User Confguration with the remote MySQL-server allows for it.

Please note that users created on the remote MySQL server most be given access to connect from remote places. By default MySQL gives only access from “localhost” to users. You can use the SQL wildcard '%' to specify from which hosts users may connect. Simply “%” means from everywhere!

It probably would be practical if you configured the ROOT or some ADMIN user (with appropriate privileges) to be allowed to connect from your local machine. Then you can even configure users on the remote host from SQLyog on your local machine. If it located with an ISP you may however experience that they only allow for user configuration using their own “Control Panel” application.

[peterlaursen]

3 ways to do that:

1) Direct connction. Simply enter the ip of the remote server or an URL describing its location in Connection Manager “MySQL Host Adress” field. If server is behind a router or firewall they should of course be configured appropriately.

2) HTTP-tunneling. If there is a webserver (such as MS IIS, Apache etc) running un that remote server too, you can use HTTP/HTTPS tunnelling, if you install the php preprocessor as a module with the webserver. Php ver 4 i preferred for connecting with SQLyog. Php_mysql extension must be enabled in php-configuration. You must upload the HTTP-tunneling file (found in SQLyog installation dirctory) to a localtion on the server accessible for the webserver. You enter detail in Connection Manager's “Tunnel” tab

3) SSH-tunneling. You must then install an SSH-server program on the remote server. Accesible from http://www.openssh.org . If you have never used ssh before it can be a little complicated. But some help is in SQLyog help file, and if it is not enough feel free to write again!

[peterlaursen]

4.1 beta7 is here:

http://www.webyog.com/forums/index.php?sho…view=getnewpost

[peterlaursen]

and problem persists ??

[peterlaursen]

@rbma

beta7 is out

http://www.webyog.com/forums/index.php?sho…st=0&#entry6679

could you confirm that SQL_WHERE is not truncated any more on your system ?

[peterlaursen]

Quote:

Well it's the one that's in the SQLyog directory

well.. what i meant was that if it was an early version originating form an early SQLyog 4.0 Beta, that could maybe be the reason. If your are not perfectly sure I'd propose that you upload the file again.

[peterlaursen]

and one Q more:

what is the PHP version runing at your ISP ?

I myself have an issue with sync and php5 (its an issue with the character).

If that is it I have a setup of various MySQL's <> php5 <> apache running here. So if you'll let me have some sample data I can see if I can reproduce.

SJA-sync is written with php4 in mind and uses the php_mysql extension.

I know that it is on the TODO to support the php_mysqli extension too and to support the new “database abstraction layer” in php introduced with php5.1.

But other task/issues/features have been considered more important till now.

However as we can expect php5.1 final i about a moth's time, I think it should soon be ..

[peterlaursen]

Are you sure that your php tunnelling file at the ISP is latest version ?

[peterlaursen]

http://www.webyog.com/forums/index.php?showtopic=1543

A major change took place with 4.05 with the editable resultpane (that in particular is extremely useful with multitable queries). Unfortunately the sorting functionality with columnheaders in the resultpane was lost then.

You wil have to include an “order by” in your query instead.

[peterlaursen]

forget it …:-)

[peterlaursen]

I can't reproduce the problem with 4.1 beta6!

Look at picture – there are lot's of apostrophs.

If I make a copy of that table and remove the ” ' “s from all data in the copy and run sync they are correctly sync'ed back to to data with apostroph's.

this one

Quote:

`ProjectID`='15'

really surprises me. '15' is a string ??

and this one

Quote:

`Sectio'

even more! starts with backquote and ends with apostroph ??

Do you use columns_selection or sql_where ?

[peterlaursen]

the ' -character must be escaped too so a true statement with your data would go

Quote:

select 'Mr Slate's Quarry' like '%\'%'

But all that should now be transparently handlet by SJA-sync (since 4.06 or maybe 4.07 as far as I remember). I do sync with these data regularly and have not observed any error. But I have hundreds of data to test with and shall do it If only you answer this

Which version of SQLyog are you using?

Would you mind pasting in the definition for the table ?

[peterlaursen]

Quote:

Hopefully the Scheduled ODBC Import will be enhanced to accomodate this situation

give the boy a lollipop and he'll want a candy shop 😀

You have far more possiblities with SQLyog import tool than any other import tool!

BTW: can't you avouid those redundant rows by using “ON CASCADE DELETE” ?

If you need those rows for some reason you might also consider copying the DB on the SQLserver and to delete the unwnated rows there with the copy!

[Author]

Posts