0%
How can I resolve DEFINER errors when importing a SQL dump to my database ?
Search

Check your database export

First, you'll have to understand that on Cloud databases, a user is already created with actions only on the database.This users can't change parameters and you can't have DEFINERs in your import file.

Here is the error you could get: 

Definer error: example: /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER customer_update AFTER UPDATE ON `customer` FOR EACH ROW
0%
0%