Description:
Currently I am running MySQL 5.1.41 with InnoDB plugin 1.0.6. I want to upgrade it to latest MySQL 5.5.8.
[root@dev80 mysql]# pwd
/usr/local/mysql
[root@dev80 mysql]# dir
total 208
drwxr-xr-x 13 mysql mysql 4096 Dec 15 10:50 ./
drwxr-xr-x 14 root root 4096 Jan 7 14:07 ../
drwxr-xr-x 2 mysql mysql 4096 Jan 6 10:06 bin/
-rw-r--r-- 1 mysql mysql 17987 Dec 3 09:58 COPYING
drwxr-xr-x 5 mysql mysql 4096 Jan 7 14:09 data/
drwxr-xr-x 2 mysql mysql 4096 Dec 15 10:50 docs/
drwxr-xr-x 3 mysql mysql 4096 Dec 15 10:50 include/
-rw-r--r-- 1 mysql mysql 12386 Dec 15 11:31 INSTALL-BINARY
drwxr-xr-x 3 mysql mysql 4096 Dec 15 10:50 lib/
drwxr-xr-x 4 mysql mysql 4096 Dec 15 10:50 man/
drwxr-xr-x 10 mysql mysql 4096 Dec 15 10:50 mysql-test/
-rw-r--r-- 1 mysql mysql 113534 Dec 3 09:58 README
drwxr-xr-x 2 mysql mysql 4096 Dec 15 10:50 scripts/
drwxr-xr-x 27 mysql mysql 4096 Dec 15 10:50 share/
drwxr-xr-x 4 mysql mysql 4096 Dec 15 10:50 sql-bench/
drwxr-xr-x 2 mysql mysql 4096 Dec 15 10:50 support-files/
I copied my 5.1.41 mysql database to 5.5.8 installation location:
/usr/local/mysql/data/mysql
and run following:
[root@dev80 mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
110107 14:04:01 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).
ERROR: 1136 Column count doesn't match value count at row 1
110107 14:04:01 [ERROR] Aborting
110107 14:04:01 [Note] ./bin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
./data for more information.
You can try to start the mysqld daemon with:
shell> ./bin/mysqld --skip-grant &
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the ./bin/mysqlbug script!
Even I fixed comment from char(64) to text, but I still got:
[root@dev80 mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
110107 14:09:00 [ERROR] Aborting
...
How to repeat:
just run:
# scripts/mysql_install_db --user=mysql