Upgrade MySQL to bitsCN.com in earlier versions.
I. upgrade from Version 3.23 to 4.10
4.10 new features: Support for transaction processing and stored procedures
Precautions for the upgrade process:
1: The upgrade uses the method of directly copying the installation file, which is simple and practical, but you must pay attention to the relevant configuration changes; 2: The database that directly copies the backup cannot be restored through the copy method, therefore, the mysqldump method must be used for backup. 3: The user management of mysql4.1 is different from that of mysql 3.23. max_questions, max_updates, and max_connections fields are added to the user table, which can be set differently for different mysql users, for backup/recovery, you can set max_questions and max_updates to a higher value. The specific setting value depends on the actual situation of the database.
Upgrade procedure:
1: stop the current MySQL service
#/Www/mysql/bin/mysqladmin shutdown
2. back up data files
# Cp