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

Operating System & Version
Centos 7.9
cPanel & WHM Version
94.0.4

rhm.geerts

Well-Known Member
Jul 29, 2008
147
15
68
Maastricht
cPanel Access Level
Root Administrator
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

Well-Known Member
Jul 29, 2008
147
15
68
Maastricht
cPanel Access Level
Root Administrator
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.
 

rhm.geerts

Well-Known Member
Jul 29, 2008
147
15
68
Maastricht
cPanel Access Level
Root Administrator
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

Jurassic Moderator
Staff member
Oct 19, 2014
7,439
1,004
313
cPanel Access Level
Root Administrator
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

Well-Known Member
Jul 29, 2008
147
15
68
Maastricht
cPanel Access Level
Root Administrator
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)?
 

rhm.geerts

Well-Known Member
Jul 29, 2008
147
15
68
Maastricht
cPanel Access Level
Root Administrator
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:
can be put to solved, but still a question left.

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

this is an odd one, also still open