Plugin Contributor
bcrodua
(@bcrodua)
Hi,
Thanks for contacting us.
The log shows the following error: An error occurred while attempting to check the support of stored routines creation (You do not have the SUPER privilege and binary logging is enabled)
This error is preventing the restore from running.
To resolve it, you can run the following SQL command, replacing your_username with your database username and your_host with your database host (typically localhost):
GRANT SUPER ON . TO 'your_username'@'your_host';
If you’re on shared hosting, you may not have permission to grant the SUPER privilege yourself. In that case, please contact your hosting provider and ask them for the best way to proceed.
Kind regards,
Bryle
Thread Starter
stellr
(@stellr)
The DreamHost support folks say that this is a shared server and because of that they cannot grant SUPER. They ask if there is a method for UpdraftPlus to not do the check for stored routines as “your backup almost certainly contains no stored routines at all”
Here is their full response:
<span style="background-color: rgb(240, 240, 240); font-family: "Courier 10 Pitch", Courier, monospace; font-size: 0.8rem;">Short answer to your question: Can you fix this? No. The error you are</span>
<span style="background-color: rgba(30, 30, 30, 0.2); font-family: "Courier 10 Pitch", Courier, monospace; font-size: 0.8rem;">seeing is not coming from the restore itself failing. What UpdraftPlus</span>does before it begins a restore is run a quick compatibility check. It
tries to create a small test function in your database to find out
whether stored routines are supported on the server.
On our shared hosting MySQL servers, that check fails because it requires
a privilege called SUPER, which is a server-level permission we cannot
grant to individual customers. Your UpdraftPlus support team gave you
accurate information about what the fix would be technically, but on a
shared server that privilege simply is not something we can assign to any
user, regardless of the account.
You can read more about the limitations on a shared MYSQL server here:
https://help.dreamhost.com/hc/en-us/articles/115000263911-MySQL-limitations-due-to-shared-hosting
Here is what matters most though, and I want to make sure this part is
clear: because your production site at hopetowalk.org is also hosted on
our shared platform, your backup almost certainly contains no stored
routines at all. Shared MySQL does not support creating them, so there
would be nothing of that kind in the backup to restore in the first
place. The probe is checking for a capability the actual restore data
does not need.
With that in mind, I would suggest trying a couple of things. First,
attempt the restore anyway and watch whether UpdraftPlus treats that
error as a hard stop or simply logs it and continues. Some versions of
UpdraftPlus will warn about it and proceed without issue. Second, if it
does stop the restore, I would reach out to UpdraftPlus support and ask
them specifically how to disable or skip the stored routines
compatibility check when restoring to a shared hosting environment. This
is a well-known limitation across many shared hosting providers and they
should have a setting or a workaround for exactly this scenario.
Any hope to recover? Odd this used to work, but it’s been a few months since I’ve done the restore and there have been many updates, so I’m not sure when the problem began. Maybe with WordPress 7.1?
Plugin Contributor
bcrodua
(@bcrodua)
Hi,
Thanks for the update, and for sharing DreamHost’s response.
Unfortunately, there isn’t currently an option in UpdraftPlus to disable or skip the stored routines compatibility check during the restore process.
As a workaround, you can instead manually restore your site using Method 2 (File Upload), as described in our documentation: How to restore my UpdraftPlus backup manually – Method 2 (File Upload)
Kind regards,
Bryle
Thread Starter
stellr
(@stellr)
Thanks for the guidance. I am attempting to restore to a test site. When I use Method 1 it states that this “looks like a migration” and offers to repair the site name values. What will I need to do wrt these name entries using method 2? I thought I’d try to just install the db backup and ask it to replace the migration values. In that attempt the “Cleaning” failed. I suspect this step is the one fixing the url data, correct? How do I do that by hand?
