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
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