Mysqldump How do I export data that does not contain stored procedures?

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

This allows you to export stored procedures and functions separately

Then import the forward MySQL settings under

The code is as follows	Copy Code
Set global log_bin_trust_function_creators=true;

Otherwise the error

The code is as follows	Copy Code
ERROR 1418 (HY000) at line 31:this function has none of the 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)

You can import it again