图解MYSQL的安装和数据升级第1/2页-php手册-PHP中文网

安装、修复、更新或打包一个基于 Python 和 PyMySQL 实现的 Windows `mysql` 命令。适用于用户希望在 PowerShell/CMD 中输入 `mysql` 时重定向到 Python 实现、需要交互式输入 MySQL 连接信息、需要同步到当前用户本地 bin 目录，或需要将该能力封装成可公开复用的 Codex skill。

下载

如果你是全新安装，就可以跳过这一步啦

找到你的Mysql的数据库目录下的 ragnarok 数据库目录，例如我的Mysql安装在
D:\mysql 这个目录下，就到 D:\mysql\data\ 目录下找到 ragnarok 数据库目录
把它拷贝一份到其它地方！
[升级你的ODBC - MySQL ODBC driver ]
首先打开你的控制面版，找到 [添加删除程序] 把旧的MySQL ODBC driver 删除
然后安装MyODBC-3.51.11-1-win.exe
[删除你电脑里的旧版MYSQL服务]
如果你以前安装过旧版的，那就要看看如何完整从你的系统内删除Mysql
在你从电脑里卸载旧的MYSQL数据库服务时
首先先在WINDOWS服务里停掉MYSQL的服务
再到控制面板里的增加删除程序内进行删除
但是你并不能完整的把MYSQL服务删除
那么就要在注册表里清除你的MYSQL服务
有几个地方：(应该有两项，不记得啦，大家查查吧)
1、HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 目录删除
2、HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL 目录删除
3、HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL 目录删除
如下图所示：
screen.width-461) window.open('http://www.791600.com/bbs/UploadFile/2005-4/200541395340459.gif'); }" src="http://www.791600.com/bbs/UploadFile/2005-4/200541395340459.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
清除完以后，
还要记得把 C:\WINDOWS\my.ini 这个文件删除哦
然后重新启动计算机
再到你计算机服务里看一下
是不是MYSQL服务已经不见啦,好了可以进行安装新版的MYSQL啦！
[相关软件下载：]
Mysql 4.1.11-win32 - For Windows ( Mysql 4.1.11-win32.exe ) -- 数据库服务
下载
http://down.21sun.net/webtools/mysql-4.1.11-win32.zip/>
Connector/ODBC - MySQL ODBC driver ( MyODBC-3.51.11-1-win.exe ) -- 数据源
下载
http://down.21sun.net/webtools/MyODBC-3.51.11-1-win.exe/>
MySQL Control Center ( mysqlcc-0.9.4-win32.zip ) -- 管理工具
下载
http://down.21sun.net/webtools/mysqlcc-0.9.4-win32.zip/>
[Mysql Server 4.1.11的安装教程]
===============================================================================
1、运行MYSQL Server 4.1 安装包
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130821871.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130821871.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
2、点击(Change..)选择安装路径，建议大家不要装在C盘！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130825177.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130825177.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
3、我选择了安装到D:\Mysql\目录下,然后点击OK，进入下一步安装
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130828622.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130828622.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
4、选择完安装路径以后点击Next>进入下一步操作！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130832385.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130832385.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
5、点击Install进行开始安装
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130835131.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130835131.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
6、我们看到安装进度！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130840751.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130840751.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
7、选择Skip Sign-Up 项，点击Next>继续安装!
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130846704.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130846704.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
8、到这里我们安装已经完成，选上Configure the MySQL Server now后
点击 Finish 进入Mysql的配置工作
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/2005413085553.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/2005413085553.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
9、进入Mysql的配置界面！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130858908.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130858908.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
10、选择Detailed Configuration 选择后，点击Next>进行下一步!
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/200541309113.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/200541309113.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
11、选择Server Machine 然后点击Next>继续！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/2005413096642.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/2005413096642.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
12、选择Multifunctional Database 然后点击Next 继续!
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130910575.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130910575.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
13、这一步默认即可（让你选择数据库文件的存放地点）建意默认！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130915778.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130915778.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
14、选上Online Transaction Processing(OLTP)然后点击Next>继续!
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130917654.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130917654.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
15、如下图，继续Next>
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130920743.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130920743.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
16、选择语言的支持！默认为Standard Character Set
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130924549.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130924549.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
17、记得要选上Include Bin Directory In Windows Path 选项，继续
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130927611.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130927611.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
18、如下图，输入密码，继续Next>
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130930143.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130930143.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
19、点击Execute 开始完成配置并启动MYSQL服务！
screen.width-461) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130932478.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130932478.gif" onload="function anonymous() { if(this.width>screen.width-460)this.width=screen.width-460; }" border=0>
20、点击Finish 完成你的Mysql的全部安装！
=700) window.open('http://www.21sun.net/bbs/UploadFile/2005-4/20054130937304.gif'); }" src="http://www.21sun.net/bbs/UploadFile/2005-4/20054130937304.gif" onload="function anonymous() { if(this.width>'700')this.width='700'; }" border=0>
[恢复 cAthena Mysql 数据库的备份]
===============================================================================
把你刚才备份的 ragnarok 目录，拷贝到你的Mysql数据库目录下面，即完成对Mysql版本的升级