Problems encountered during mysql5.1.37 upgrade to 5.5.3

After the upgrade, import the previously backed up data
1. An error is reported when importing data. Cannot load from mysql. proc. The table is probably updated upted, which is caused by an upgraded version.
Solution: mysql_upgrade-u root-p
2. Completely export the parameters of a database (including triggers and stored procedures)
Mysqldump -- skip-lock-tables -- single-transaction -- opt -- extended-insert = false -- triggers-R
3. an ERROR occurred while creating the function. ERROR 1418 (HY000): 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)
Solution: set global log_bin_trust_function_creators = TRUE;
And then create.