Unable to restore - Definers issue


All of a sudden when i try to initiate a restore on my backup MySQL Server, I get this error message: 10:38:03 AM : ERROR: Failed to restore “mydb” database. mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1227 (42000) at line 2: Access denied; you need (at least one of) the SUPER privilege(s) for this operation.

I tried creating another user with Global privilefes but I got the same result. Any idea what might be wrong?

Note that this was working fine for the past 20-25 days and i was restoring daily the database. Nothing has changed, but somehow the problem appeared!

Hi Leonidas,

We have added some improvements to the Alpha edition, could you please install it https://sqlbackupandftp.com/download/alpha and check if it works for you?

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.