Shulou(Shulou.com)05/31 Report--

This article shows you what the problems encountered in upgrading mysql5.1.37 to 5.5.3 are, concise and easy to understand, which will definitely brighten your eyes. I hope you can gain something through the detailed introduction of this article.

Import previously backed up data after the upgrade

1. Error importing data Times, Cannot load from. Proc. The table is probably corrupted, this is the result of the upgraded version.

Solution: mysql_upgrade-u root-p

two。 Fully export the parameters of a library (including triggers, stored procedures, etc.)

Mysqldump-skip-lock-tables-single-transaction-opt-extended-insert=false-triggers-R

3. Create function Times error, 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 it.

The above is what the problem is when mysql5.1.37 upgrades to 5.5.3. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.