MySQL Forums
Forum List  »  Install & Repo

mysqldump and triggers -> definer hostname
Posted by: Hans Meiser
Date: March 03, 2010 09:33AM

Hello,

mysql 5.1.40
i created some tables with triggers like described here:
http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html
Now i do a mysqldump.
in trigger section the definer is written as: DEFINER=`mydbuser`@`%`
if i try to import the whole dump into the db mysql is rejecting with "you need the SUPER privilege".
if i change DEFINER=`mydbuser`@`%` to DEFINER=`mydbuser`@`localhost` so i can import the dump without errors.
i have another mysql-machine with 5.1.43
if i dump same sql on this machine then definer is written as DEFINER=`mydbuser`@`localhost` (not % )and reimport starts without the need of editing or errors.
Is this a kind of setting in mysql which chooses hostname at dumping triggers or may be a issue of version 5.1.40? I could not find fitting information.

Thanks,
Hans

Options: ReplyQuote


Subject
Written By
Posted
mysqldump and triggers -> definer hostname
March 03, 2010 09:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.