图解MYSQL的安装和数据升级第1/2页
如果你是全新安装，就可以跳过这一步啦
找到你的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版本的升级
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1666
14
1425
52
1327
25
1273
29
1253
24
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
MySQL and phpMyAdmin: Core Features and Functions
Apr 22, 2025 am 12:12 AM
MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.
MySQL vs. Other Programming Languages: A Comparison
Apr 19, 2025 am 12:22 AM
Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
Solve database connection problem: a practical case of using minii/db library
Apr 18, 2025 am 07:09 AM
I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.
Laravel framework installation method
Apr 18, 2025 pm 12:54 PM
Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.
Solve MySQL mode problem: The experience of using the TheliaMySQLModesChecker module
Apr 18, 2025 am 08:42 AM
When developing an e-commerce website using Thelia, I encountered a tricky problem: MySQL mode is not set properly, causing some features to not function properly. After some exploration, I found a module called TheliaMySQLModesChecker, which is able to automatically fix the MySQL pattern required by Thelia, completely solving my troubles.
MySQL: Structured Data and Relational Databases
Apr 18, 2025 am 12:22 AM
MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.
MySQL: Essential Skills for Beginners to Master
Apr 18, 2025 am 12:24 AM
MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.
