[peterlaursen]

“I changed it to “server default””

'server default' means that the server setting for max_allowed_packet is used.

What is the server 'max_allowed_packet' in your case?

(tool .. show .. variables will tell).

What happens if you set the BULK sixe yourself to – say – '200' ?

[peterlaursen]

“The job now runs as scheduled but the data on the target server is not being updated.”

Try

1) commandline: sja

2) 'execute now' from windows scheduler

what works and what does not?

Did you ever read this on DATA SYNC:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

please understand how the tool uses a PK.

Do your tables have a PK?

[peterlaursen]

I think that I will need to ask your to be patient till beginning of next week.

I do not know precisely what the 'copy to other ' does …

[peterlaursen]

syntax is

sja “jobfile.xml” –l”log.txt” –s”session.xml”

Refer to:

http://webyog.com/faq/27_114_en.html

'user' and 'password' are inside the jobfile for each connection.

schedule is not a parameter. You schedule using SQLyog ENTERPRISE GUI (on Windows), directly from the Windows Scheduler or (on Linux) as you would schedule any job from some CRONTAB interface.

[peterlaursen]

Now this is a VERY OLD Forums post.

With SQLyog 5.17 (and everyone I ever tried) I can copy a table to another DB on the same host.

Also with MySQL 3.23.58 and SSH tunnel.

Could there be some configuration issue with SSH or MySQL that prevents working actively on two databases on the same time?

Also: can you use the DATA SYNC 'powertool' ?

[peterlaursen]

Quote:

The mySql version is 3.23.49.

I do not know if there could be an issue here. With 3.23.58 and SSH tunnel it works fine here.

Please test the other features as well in between. I will need to ask developers WHAT SQLyog does in detail here (HISTORY does not record 'copy table')

I think the 'freeze' is simply because MySQL does not respond.

[peterlaursen]

tools … preferences … General TAB.

What is the setting for 'Max packet Size' on your system?

If it is = (zero) or very low that woluld explain!

http://webyog.com/faq/24_101_en.html

[peterlaursen]

BTW:

at ISP's it is not unusual that you will need to use their Control Panel application to edit users.

They sometimes do weird things with the mysql.user table (and sometimes just do not use it – the CP app operates its own user table!).

[peterlaursen]

Please answer: what is the SQLyog version that you are using?

Please let us see the returns of a

Code:

SHOW GRANTS for 'user'@'localhost'

for both users.

Quote:

I receive a 1045 error telling me access is denied for that user.

are you sure that the password is correct?

[peterlaursen]

@FireStorm9

Now if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!

[peterlaursen]

Please try start reading this:

http://webyog.com/faq/27_34_en.html

did it help?

[peterlaursen]

1) the 'bug'

Not reproducable! I get for instance this INSERT statement:

Code:

insert into `tablename1` (`id`,`v`) values (1,'a'),(2,'b'),(3,'c');

.. and that IS a BULK insert statement to my best understanding.

2) requests:

both are reasonable. I do not know how hard is is to copy to the editor.

[peterlaursen]

no, RC4 is not FINAL.

But as far as I remember there was only a very small fix between the releases.

you must use this link:

http://webyog.com/sqlyog/upgrade.html

and not the link from the Forums to get the FINAL.

The changelog in the FAQ was updated yesterday: http://webyog.com/faq/33_7_en.html

if you want it 100% detailed you must find the BETA annoucnements in the Forums.

In the FAQ and in program help file is in a 'concentrated' form

[peterlaursen]

I think you must ask your ISP to help with this.

Maybe they only need to restart Apache (or whatever the webserver is) to fix it.

Thy will probably tell you that they did not change anything! They usually do. It is easiest for them!

Try executing the same query from phpMyAdmin (I think you have it?) on the server!

I would like to see if you get the same error then.

BTW: you should consider upgrading SQLyog! It is a free upgrade to 5.17!

http://webyog.com/sqlyog/upgrade.html

[peterlaursen]

Please answer:

1) Did you update SQLyog in between? Or does this happen now with the same version that used to work? And what version?

2) How do you connect to MySQL? It look like a XML-related issue! Using HTTP-tunnel?

[Author]

Posts