Upgrade MySQL

作者:


最后更新于 | 最初发布于 | 分类:


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

Download the latest Windows distribution of MySQL from https://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分钟。
难度:中。





关于作者
搜索
归档

Online Tools

Code Convertor