select concat('pr_', p.db,'.',p.name ) filename ,concat('delimi','ter $$use `',p.db,'`$$drop procedure if exists `',p.name, '`$$create definer=','`',left(definer, -1+locate('@',definer)),'`@`',right(definer,length(definer)-locate('@',definer)),'`',' procedure `',p.name ,'`(',p.param_list,')',p.body_utf8,'$$delimi','ter ;' ) as sql_create from mysql.proc as p where p.db like '%'and type like 'proc%'order by p.db,p.name ;