Bug #42148 dump mysql schema widouth definer
Submitted: 16 Jan 2009 8:13 Modified: 16 Jan 2009 8:54
Reporter: Horga Marius Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[16 Jan 2009 8:13] Horga Marius
How cant backup mysql InnoDb Schema widouth ANY DEFINER  from mysql Admin or from mysqldump ?

How to repeat:
any backup file make by Mysql Administator have inside 
DEFINER. if must make restore on the new server where the old users are not define   the acces rights are compromise. In this moment I replace by my hand DEMIMITER rooo@localhost with space. ( but is not a very funny solution )
[16 Jan 2009 8:54] Valeriy Kravchuk
I think this is a duplicate of bug #24680.