SOLVED The remote MySQL dump failed because of an error (WebSocket 1006).

[rhm.geerts]

Using the transfer tool to move everything from one server to another server.

On a couple (not all) of the databases, we get this error:
(XID hjt6rd) A non-fatal error occurred during rsync streaming: Partial transfer due to error
and a bit lower
The remote MySQL dump failed because of an error (WebSocket 1006).

Any clue on why this is happening? Best way to fix this?

 

[rhm.geerts]

They were both Magento shops. I tried dumping them by username, which gave an error that the account did not have "process" permissions.
So I dumped them as mysql root and restored them as user on the new server.

Problem fixed.

 

[cPRex]

I'm glad you were able to come up with a resolution for that :D

 

[rhm.geerts]

Yep, me2. But still.... it shouldn't happen, nothing odd with those databases. And since the transfertool uses the root user, I expected the database dumps would be done via root mysql user also.

 

[cPRex]

Actually, each individual account gets run as the user, specifically so we can see if there are odd permissions or files that would not work well after the transfer, so if the cPanel user didn't have access to that database for some reason it would not get transfered.

 

[rhm.geerts]

That is correct, only the cPanel user was tansferred.
However, the error notice appeared as if a dump was put into the users homedir, which afterwards could be restored manually.
However that was not the complete database, only a few hundreds kb which is corresponding with the error that the dump failed.

I think the admin creating the database user did not create him correctly then.
Thank you.
Any insight on the other transfer issues I posted? Like with the 2 domains which were not transferred due to an odd error and removing (not changing) old spf values which were all added (while they should not)?

 

[cPRex]

I didn't see any other errors included in the original post as I only see the MySQL things mentioned. I'm happy to look if you want to include those :D

 

[rhm.geerts]

I didn't mention it all in 1 post as they were different issues with transfer, so I thought for indexing/title purposes for future references it would be better to tackle them seperately.

Here they are:

SOLVED - Transfer tool does not abort!

I got an issue when the transfer tool session which I had to abort because it "hung" on 2 accounts, one of which for domain.com we had the files on the server (we need them) but at the registrar this domain pointed to other nameservers, because we put it on another server. Transfertool should...

forums.cpanel.net

can be put to solved, but still a question left.

Remove all old SPF ip's after transfer to other server

We moved to a new server using the transfer tool Now in the new bind files, every SPF record contains 2 ip's. Like this (ip's are masked to local ip's): "v=spf1 ip4:192.168.0.1 +a +mx +ip4:10.0.0.1 ~all" where 192.168.0.1 is the ip of the new server and 10.0.0.1 is the old server ip. With which...

forums.cpanel.net

transfer put in both old spf and new spf values instead of only new ip.

Transfer tool missed 2 domains without warning

We transferred all accounts from a server to another using the transfer tool. Luckily we always doublecheck and it looked like some accounts were missing. Indeed 2 accounts were not transferred and I did -not- see a warning about that as far as I remember. A warning should have appeared imho. I...

forums.cpanel.net

this is an odd one, also still open

 

[cPRex]

Ah - I just haven't got to those yet. I'm working through the "new" pile so those will get a reply at some point today.

 

[rhm.geerts]

No problem they are not a big hurry.
Thank you.