Site transfers between servers lose/change account db username and password

OS type and version Almalinux 9.4
Webmin version 2.111
Virtualmin version 7.10.0
Related packages :man_shrugging:
(Note: both servers mentioned are the same versions)

I’m raising this formally having mentioned it previously on another post a few months back.

I’m again moving some sites between servers via the Manage/Transfer option in Virtualmin.

Some worked without issue and some had the database username and password changed and thus breaking the underlying WordPress site.

I only moved a few thus far, and it seems that the ones that failed this time had an underscore in the db user name (even though they had transferred successfully to this source server previously).

To make it worse this time, one of those failed sites, after changing the username and password in the wp-config, now has this error this morning from the overnight backup:

“Failed - Your WordPress database user doesn’t have sufficient privileges to read these stored routines. To be able to backup the routines, you must be the user named as the routine DEFINER(s), have the SHOW_ROUTINE privilege (for MySQL 8.0.20+ users), have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that includes the routines.)”

I was also unable to transfer one of the sites as the restore failed with “The user specified as a definer does not exist”.

Weird stuff… I have done hundreds of these moves in the past so not my first rodeo.

I need to keep going with the balance, so may update with more failures.

FYI, this transfer failed consistently now for any database user name that had an underscore. The name would be truncated at the underscore and the password changed.

Funnily enough all these domains were transferred to the server as is a few weeks ago, although I had a few fail with the same issue back then as well.