Home >Backend Development >PHP Tutorial >Illustrated MYSQL installation and data upgrade page 1/2_PHP tutorial
Illustrated MYSQL installation and data upgrade page 1/2_PHP tutorial
- WBOYOriginal
- 2016-07-21 16:00:31828browse
如果你是全新安装，就可以跳过这一步啦
Find the ragnarok database directory under your Mysql database directory. For example, my Mysql is installed in the directory
D:mysql. Then go to the D:mysqldata directory and find the ragnarok database directory
Make a copy of it somewhere else!
[Upgrade your ODBC - MySQL ODBC driver]
First open your control panel, find [Add and Remove Programs] and delete the old MySQL ODBC driver
Then install MyODBC- 3.51.11-1-win.exe
[Delete the old version of MYSQL service in your computer]
If you have installed the old version before, then you should take a look at how to completely remove it from your system Delete Mysql within
When you uninstall the old MYSQL database service from your computer
First stop the MYSQL service in the WINDOWS service
Then delete it through Add and Delete Programs in the control panel
But you cannot completely delete the MYSQL service
Then you need to clear your MYSQL service in the registry
There are several places: (There should be two items, I don’t remember, please check)
1. HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesEventlogApplicationMySQL directory deletion
2. HKEY_LOCAL_MACHINESYSTEMControlSet002ServicesEventlogApplicationMySQL directory deletion
3. HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesEventlogApplicationMySQL directory deletion
As shown in the figure below: 
After cleaning,
remember to delete the file C: WINDOWSmy.ini
and then restart the computer
and then check in your computer services
Is the MYSQL service gone? Now you can install the new version of MYSQL!
[Related software download:]
Mysql 4.1.11-win32 - For Windows ( Mysql 4.1.11 -win32.exe ) -- Database service
Download
http://down.21sun.net/webtools/mysql-4.1.11-win32.zip/>
Connector/ODBC - MySQL ODBC driver (MyODBC-3.51.11-1-win.exe) -- Data source
Download
http://down.21sun. net/webtools/MyODBC-3.51.11-1-win.exe/>
MySQL Control Center ( mysqlcc-0.9.4-win32.zip ) -- Management Tools
Download
http://down.21sun.net/webtools/mysqlcc-0.9.4-win32.zip/>
[Mysql Server 4.1.11 Installation tutorial]
========================================== =======================================
1. Run the MYSQL Server 4.1 installation package 
2. Click (Change..) to select the installation path. It is recommended not to install on the C drive! 
3. I chose to install it in the D:Mysql directory, then click OK to proceed to the next step of installation
4. After selecting the installation path, click Next> to proceed to the next step!
5. Click Install to start the installation
6. We see the installation progress!
7. Select the Skip Sign-Up item and click Next> to continue the installation!
8. Our installation has been completed here. After selecting Configure the MySQL Server now
click Finish to enter the Mysql configuration work
9. Enter the Mysql configuration interface!
10. Select Detailed Configuration. After selecting, click Next> to proceed to the next step!
11. Select Server Machine and click Next>Continue!
12. Select Multifunctional Database and click Next to continue!
13. This step can be defaulted (allowing you to choose the storage location of the database file). It is recommended to default!
14. Select Online Transaction Processing (OLTP) and click Next>Continue!
15. As shown below, continue to Next>
16. Select language support!默认为Standard Character Set
17、记得要选上Include Bin Directory In Windows Path 选项，继续
18、如下图，输入密码，继续Next>
19、点击Execute 开始完成配置并启动MYSQL服务！
20、点击Finish 完成你的Mysql的全部安装！
[恢复 cAthena Mysql 数据库的备份]
===============================================================================
把你刚才备份的 ragnarok 目录，拷贝到你的Mysql数据库目录下面，即完成对Mysql版本的升级