图解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
AI Hentai Generator
Generate AI Hentai for free.
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
How to use MySQL backup and restore in PHP?
Jun 03, 2024 pm 12:19 PM
Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.
How to optimize MySQL query performance in PHP?
Jun 03, 2024 pm 08:11 PM
MySQL query performance can be optimized by building indexes that reduce lookup time from linear complexity to logarithmic complexity. Use PreparedStatements to prevent SQL injection and improve query performance. Limit query results and reduce the amount of data processed by the server. Optimize join queries, including using appropriate join types, creating indexes, and considering using subqueries. Analyze queries to identify bottlenecks; use caching to reduce database load; optimize PHP code to minimize overhead.
Xiaoyi upgraded to an intelligent agent! HarmonyOS NEXT Hongmeng native intelligence opens a new AI era
Jun 22, 2024 am 01:56 AM
On June 21, Huawei Developer Conference 2024 (HDC2024) gathered again in Songshan Lake, Dongguan. At this conference, the most eye-catching thing is that HarmonyOSNEXT officially launched Beta for developers and pioneer users, and comprehensively demonstrated the three "king-breaking" innovative features of HarmonyOSNEXT in all scenarios, native intelligence and native security. HarmonyOSNEXT native intelligence: Opening a new AI era After abandoning the Android framework, HarmonyOSNEXT has become a truly independent operating system independent of Android and iOS, which can be called an unprecedented rebirth. Among its many new features, native intelligence is undoubtedly the new feature that can best bring users intuitive feelings and experience upgrades.
How to insert data into a MySQL table using PHP?
Jun 02, 2024 pm 02:26 PM
How to insert data into MySQL table? Connect to the database: Use mysqli to establish a connection to the database. Prepare the SQL query: Write an INSERT statement to specify the columns and values to be inserted. Execute query: Use the query() method to execute the insertion query. If successful, a confirmation message will be output.
How to create a MySQL table using PHP?
Jun 04, 2024 pm 01:57 PM
Creating a MySQL table using PHP requires the following steps: Connect to the database. Create the database if it does not exist. Select a database. Create table. Execute the query. Close the connection.
How to use MySQL stored procedures in PHP?
Jun 02, 2024 pm 02:13 PM
To use MySQL stored procedures in PHP: Use PDO or the MySQLi extension to connect to a MySQL database. Prepare the statement to call the stored procedure. Execute the stored procedure. Process the result set (if the stored procedure returns results). Close the database connection.
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app
70B model generates 1,000 tokens in seconds, code rewriting surpasses GPT-4o, from the Cursor team, a code artifact invested by OpenAI
Jun 13, 2024 pm 03:47 PM
70B model, 1000 tokens can be generated in seconds, which translates into nearly 4000 characters! The researchers fine-tuned Llama3 and introduced an acceleration algorithm. Compared with the native version, the speed is 13 times faster! Not only is it fast, its performance on code rewriting tasks even surpasses GPT-4o. This achievement comes from anysphere, the team behind the popular AI programming artifact Cursor, and OpenAI also participated in the investment. You must know that on Groq, a well-known fast inference acceleration framework, the inference speed of 70BLlama3 is only more than 300 tokens per second. With the speed of Cursor, it can be said that it achieves near-instant complete code file editing. Some people call it a good guy, if you put Curs
