Mysqldump export does not contain stored procedures

Mysqldump export does not contain stored procedures

Mysqldump-u database user name-p-n-t-d-R--triggers=false Database name > file name

This allows you to export stored procedures and functions separately

Then import it forward under MySQL settings

Set global log_bin_trust_function_creators=true;

Otherwise the error

ERROR 1418 (HY000) at line 31:this function have none of deterministic, NO SQL, or READS SQL DATA in its declaration and B Inary logging is enabled (your *might* want to use the less safe log_bin_trust_function_creators variable)

Then you can import

Mysqldump export does not contain stored procedures