Upgrade MySQL from 5.1.26-rc to 5.5.15

Today, I upgraded MySQL from 5.1.26-rc to 5.5.15. The source code packages downloaded from the official website are compiled. MySQL5.5.15 is provided by my colleagues because

Today, I upgraded MySQL from 5.1.26-rc to 5.5.15. The source code packages downloaded from the official website are compiled. MySQL 5.5.15 is provided by my colleagues because

I upgraded MySQL from 5.1.26-rc to 5.5.15. The source code packages downloaded from the official website are compiled. MySQL 5.5.15 is provided by my colleagues.
Because the existing database uses the innodb engine, mysqldump is used to export the backup, and then the backup is imported for upgrade.
Steps for upgrading:
1. Back up existing databases
2. rename the existing MySQL Program (to prevent the upgrade from failure and recovery)
3. Back up the existing permission database separately
4. Replace existing MySQL programs
5. Start MySQL 5.5.15 and import the backup.
Note: pay special attention to mysql Log prompts

When MySQL 5.5.15 is started after the upgrade, many error messages are prompted, which can be modified according to the error prompt to quickly solve the problem.

A. I have installed and upgraded MySQL 5.5.15. The compiling directory is/usr/local/mysql, but the directory of our online database program is/usr/local/mysql5, I upgraded the program online and deployed the program according to the online service. Therefore, the following error is prompted during the startup process:
120717 11:19:41 mysqld_safe The file/usr/local/mysql/bin/mysqld
Does not exist or is not executable. Please cd to the mysql installation
Directory and restart this script from there as follows:
./Bin/mysqld_safe &
See for more information

Solution: Change the program directory to/usr/local/mysql.

B. The [mysqld] Option section in the configuration file has the following options: log-slow-queries. This option belongs to the old version and is modified according to the mysql log File GY_ZGC_97.err error prompt:
120717 11:21:32 mysqld_safe Starting mysqld daemon with databases from/home/mysql/data
120717 11:21:32 [Warning] The syntax '-- log-slow-queries' is deprecated and will be removed in a future release. please use '-- slow-query-log'/' -- slow-query-log-file' instead.
120717 11:21:32 InnoDB: The InnoDB memory heap is disabled
120717 11:21:32 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120717 11:21:32 InnoDB: Compressed tables use zlib 1.2.3
120717 11:21:33 InnoDB: Initializing buffer pool, size = 1000.0 M
120717 11:21:33 InnoDB: Completed initialization of buffer pool

Solution: replace log-slow-queries in the configuration file with slow-query-log.