Upgrade MySQL to version _ MySQL

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