Myswl Server Had Gone Away Error When Copying Database

[arlangdon]

I'm trying to copy a database from a nearby server to a distant database server. The nearby server is running MySQL 4.1.16 under Linux. The remote server is running MySQL 4.1.20 under Linux. I am running SQLyog 5.24 under Windows XP SP2.

The database I am copying is only around 8MB. Part way through the copying process, I get the error “the MySQL server has gone away”. The server is still running, and there are no errors logged in the error log (I did increase the logging level on the remote server).

I did try the copy using an older version (4.07), and it completed successfully, but the resulting copy was only around 4MB. I also copied the database using mysqldump and mysql, which seemed to work much better. However, this is not feasible for the production use, and I would like to be able to perform the copy with SQLyog.

Anyone got any thoughts on this?

[arlangdon]

I forgot to mention that the remote server is a virtual server running under Virtuozzo. The virtual server instance is rented from a major US based hosting company, and I have no access to the physical host, only the VM instance itself.

[peterlaursen]

virtualisation should not matter.  We use VMware and VirtualPC ourselves regulary.

Please answer

* How do you connect?  direct, HTTP, SSH?

* Is the error always occurring at the same point? (SELECT count(*) from ) ?

* Do you have any idea which of the servers that has 'gone away'?

* How do you 'copy'?  'copy database/table' from the (context) menu? If so are you able to dump and import?

[arlangdon]

peterlaursen wrote on Mar 7 2007, 03:57 PM:

virtualisation should not matter. We use VMware and VirtualPC ourselves regulary.

Please answer

* How do you connect? direct, HTTP, SSH?

* Is the error always occurring at the same point? (SELECT count(*) from ) ?

* Do you have any idea which of the servers that has 'gone away'?

* How do you 'copy'? 'copy database/table' from the (context) menu? If so are you able to dump and import?

Connecting directly to the database (no SSH or HTTP). I also tried over a manually configured SSH tunnel (using PuTTY as the SSH client). The error seems to occur at the same place each time (always comes up around 700 lines into copying the data of a particular table). As for which server, I can't say for sure, but the evidence points to the destination server being the issue, because similar copies to a different server from the same source have worked fine in the past.

The copy is done using right click -> copy database. Haven't tried dump and import, could try that, but wasn't sure which options I needed to select. That would be closer to the manual method I used in my earlier testing with mysqldump and mysql.

[arlangdon]

Just tried copying the database using dump and restore in SQLyog. Appears to have worked fine. However, that solution doesn't appear to be sufficient (someone else has to perform the operation down the track). 🙁

[peterlaursen]

I really do not know how to do progress with this.  I think there must be an issue on that server.

1) did you try explaining the problem to the SysAdmin/support (if there is such).  tell them that it used to work with other servers/hosts/ISP's

2) can we have temporary access to this server?  If so create a ticket with details.  We do not need access to your data.  Create a user and an empty database and give only access for this user to this database.

[arlangdon]

peterlaursen wrote on Mar 9 2007, 05:40 PM:

I really do not know how to do progress with this. I think there must be an issue on that server.

1) did you try explaining the problem to the SysAdmin/support (if there is such). tell them that it used to work with other servers/hosts/ISP's

2) can we have temporary access to this server? If so create a ticket with details. We do not need access to your data. Create a user and an empty database and give only access for this user to this database.

Well 1) The software is very similar, except this one is running MySQL 4.1.20 instead of 4.1.16. I tried to duplicate the software environment of the current servers as close as I could.

2) I can give you access to the server, although I will need to clear it with those that own other data there. I suspect there won't be a problem with that.

Looks like I can get you access. I'll write something up and get the developer to submit a ticket.

[Author]

Posts