Upgrade MySQL

| No Comments | No TrackBacks

原先使用的是MySQL 4.0.24,现在的最新版本是MySQL 4.1.13。
察看了官方网站的Upgrading MySQL on Windows

Download the latest Windows distribution of MySQL from http://dev.mysql.com.

Before upgrading MySQL, you must stop the server.

If the server is installed as a service, stop the service with the following command from the command prompt:

C:\> NET STOP MySQL


If you are not running the MySQL server as a service, use the following command to stop the server:

C:\> C:\mysql\bin\mysqladmin -u root shutdown

When upgrading to MySQL 4.1.5 or higher from a previous version, or when upgrading from a version of MySQL installed from a Zip archive to a version of MySQL installed with the MySQL Installation Wizard, you must manually remove the previous installation and MySQL service (if the server is installed as a service).

To remove the MySQL service, use the following command:

C:\> C:\mysql\bin\mysqld --remove


If you do not remove the existing service, the MySQL Installation Wizard may fail to properly install the new MySQL service. (我就是这一步没有做,造成安装失败)后来运行了以下命令,删除了该服务
c:>sc delete mysql

所以我是先卸载MySQL 4.0.24,再安装的MySQL 4.1.13,安装时的默认字符集选用“latin1”,虽然在BLOG中的字符集设为utf8,但是原先MySQL 安装时Server就是用的“latin1”,如果现在改为“utf8”,会造成数据库中的中文变成乱码。
原先root用户的密码是空,现在安装后就有密码了,所以要修改mt目录下,mt-db-pass.cgi文件中的密码。

现在运行MovableType,一切ok。

下载安装时间:一小时。
测试时间:15分钟。
难度:中。


作者: David Yin
原载: FreeThinking
版权所有。转载时必须以链接形式注明作者和及本声明。

No TrackBacks

TrackBack URL: http://www.yinfor.com/mtcgi/mt-t-0912.cgi/672

Leave a comment

About this Entry

This page contains a single entry by David Yin published on 2005年7月24日 13:08.

PHP upgrade was the previous entry in this blog.

Upgrade PHPBB 2.0.17 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Archives

Online Tools

Code Convertor
GeoURL
Listed on BlogShares