| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Almalinux 9.4 |
| Webmin version | 2.111 |
| Virtualmin version | 7.10.0 |
| Related packages |  |
| (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.