The remote MySQL dump failed because of an error (WebSocket 1006).
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?
-
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. 0 -
I'm glad you were able to come up with a resolution for that :D 0 -
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. 0 -
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. 0 -
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)? 0 -
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 0 -
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: transfer put in both old spf and new spf values instead of only new ip. 0 -
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. 0 -
No problem they are not a big hurry. Thank you. 0
Please sign in to leave a comment.
Comments
9 comments