[Kwaka]

peterlaursen wrote on Jan 23 2007, 05:38 AM:

“the latest version of SQL Yog” version number please. We have seen before that people refer to a 2 year old version as “the latest version” 😉

Please answer:

1) How do you connect to the databases? direct, HTTP, SSH?

2) Does it always happen exactly the same place?

3) How long do you wait? If you let it 'hang' for several minutes no message will appear?

I have no problems copying +100.000 rows here.

I think chances are that the server becomes irresponsive.

With cheap hosting and HTTP-tunnelling we have seen a lot of badly configured and 'over-burdoned' webservers. (It is most often a Apache and not a MySQL problem)

But please reply to the questions!

1. Via HTTP.

2. It started to happen at 1000 rows and but now manages to get to 2000.

3. I've left it for several hours with no difference.

If I abort the transfer it just hang the whole application as well.

I'm using the version that you have on your website as I've just downloaded the very latest version.

[Kwaka]

peterlaursen wrote on Jan 4 2005, 10:14 PM:

” I've added the max_allowed_packet in there and seeing if it makes a difference.!

did it ?

Changing the max_allowed_packet seems to have done the trick.

Many thanks for your help.

[Kwaka]

Ritesh wrote on Jan 5 2005, 03:28 AM:

For a big table, it is recommended that you import the data in the target server for the first time and then sync it.

But I can't seem to do that either.

[Kwaka]

Ritesh wrote on Jan 5 2005, 03:24 AM:

It looks like you are using HTTP Tunneling while syncing two MySQL DBs? Recently, we have fixed a system crashing bug that effects DB sync over HTTP Tunneling. You can download the bug-fix release i.e. SQLyog Enterprise v4.01 from:

http://www.webyog.com/sqlyog/SQLyog401Ent.exe

Just install 4.01 and run the sync again. I am sure it will work as expected.

Tried the update but its now broken the installation although it seems to still be working?

Any ideas?

[Kwaka]

I have a networked set-up with multiple pc's.

I know which PC has MySQL installed on! That's the one with the my.ini file. However it said it had been created MySQLAdmin I think which made me think twice about it.

Anyway I've tried adding the max_allowed_packet to the file and I'm not sure if I need to reboot or not for it to kick in. Assuming it doesn't then it doesn't make any difference as it still bombs out.

I'll schedule a reboot for later just in case it does and then recheck tomorrow.

[Kwaka]

Quote:

When you are sync'ing you must have a Mysql-server installed locally.

You do? I have been sync'ing quite happily using a laptop that doesn't have mysql installed on at all!

Quote:

I guess you should check the my.ini/my.cnf -filer for that server and the settings for

I can find a my.ini file. I've added the max_allowed_packet in there and seeing if it makes a difference.

Quote:

I beliveve most (all ?) sql servers install with a default value of “max_allowed_packet = 1M”

I haven't got SQL Server. I'm using a windows version of MySQL.

Thanks for the advice.

[Kwaka]

Quote:

2. Assuming I can't, I'm also having problems getting the data across in the first place. When I try to export data as SQL inserts a HTTP response window opens up with some stuff in it, but no error. I can see though that the network connection is still going flat out so is it still doing things? Exporting to csv also fails. Anything I can do about this?

Just to add to this.

If I click on the OK button of the HTTP response window I get the following message:

Error No 1: Error in tunnelling. Please send the HTTP response to [email protected]

I can't do that however as I've only got the message after I clicked OK unless its behind the HTTP response window?

[Author]

Posts