Mysqldump export does not contain stored procedures, mysqldump stored procedures

Mysqldump export does not contain stored procedures, mysqldump stored procedures

Mysqldump export does not contain stored procedures

 

 

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

In this way, the stored procedure and function are exported separately.

 

Before importing the data, go to mysql settings.

Set global log_bin_trust_function_creators = TRUE;

 

Otherwise, an error is reported.

ERROR 1418 (HY000) at line 31: This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the less safe log_bin_trust_function_creators variable)

 

Import it again.