Illustration of MySQL installation and data upgrade 1th/2 page _php tips

If you are a new installation, you can skip this step.

Find your MySQL database directory under the Ragnarok Database directory, such as my MySQL installation in
D:\mysql This directory, go to the D:\mysql\data\ directory to find the Ragnarok database directory
Make a copy of it somewhere else!
[Upgrade your odbc-mysql ODBC Driver]
First open your control plate, find [Add Remove program] to remove the old MySQL ODBC driver
Then install Myodbc-3.51.11-1-win.exe
[remove old MySQL service from your computer]
If you've ever installed an old version, see how you can remove MySQL from your system completely
When you uninstall the old MySQL database service from your computer
First, stop the MySQL service in the Windows service.
and remove them in the Add-in Control Panel.
But you won't be able to completely remove the MySQL service.
Then you'll need to clear your MySQL service in the registration list.
There are several places: (there should be two, don't remember, everybody check it)
1, hkey_local_machine\system\controlset001\services\eventlog\application\mysql directory deletion
2, Hkey_local_machine\system\controlset002\services\eventlog\application\mysql directory deletion
3, Hkey_local_machine\system\currentcontrolset\services\eventlog\application\mysql directory deletion
As shown in the following illustration:
screen.width-460) this.width=screen.width-460; } "border=0>
After the cleanup,
And remember to delete the C:\WINDOWS\my.ini file.
And then restart the computer
And take a look at your computer service.
is not the MySQL service is gone, so you can install the new version of MySQL!
[download related software:]
MySQL 4.1.11-win32-for Windows (MySQL 4.1.11-win32.exe)--Database services
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
[Installation tutorial for Mysql Server 4.1.11]
===============================================================================
1, running the MySQL Server 4.1 installation package
screen.width-460) this.width=screen.width-460; } "border=0>
2, click (change ...) Select the installation path, we recommend that you do not install in the C disk!
screen.width-460) this.width=screen.width-460; } "border=0>
3, I chose to install to the D:\Mysql\ directory, and then click OK, into the next installation
screen.width-460) this.width=screen.width-460; } "border=0>
4, select the installation path after clicking Next> into the next operation!
screen.width-460) this.width=screen.width-460; } "border=0>
5, click Install to start installation
screen.width-460) this.width=screen.width-460; } "border=0>
6, we see the installation progress!
screen.width-460) this.width=screen.width-460; } "border=0>
7, choose Skip Sign-up Item, click Next> continue to install!
screen.width-460) this.width=screen.width-460; } "border=0>
8, here we install has been completed, selected configure the MySQL Server now after
Click Finish to enter the MySQL configuration work
screen.width-460) this.width=screen.width-460; } "border=0>
9, into the MySQL configuration interface!
screen.width-460) this.width=screen.width-460; } "border=0>
10, select detailed Configuration Select, click next> for next step!
screen.width-460) this.width=screen.width-460; } "border=0>
11, select the server Machine then click Next> to continue!
screen.width-460) this.width=screen.width-460; } "border=0>
12, select Multifunctional Database and click Next to continue!
screen.width-460) this.width=screen.width-460; } "border=0>
13, this step by default can (let you choose the location of the database file storage) to build the default!
screen.width-460) this.width=screen.width-460; } "border=0>
14, select online Transaction processing (OLTP) then click Next> to continue!
screen.width-460) this.width=screen.width-460; } "border=0>
15, the following figure, continue Next>
screen.width-460) this.width=screen.width-460; } "border=0>
16, the choice of language support! Default is Standard Character Set
screen.width-460) this.width=screen.width-460; } "border=0>
17. Remember to select Include Bin Directory in Windows Path option to continue
screen.width-460) this.width=screen.width-460; } "border=0>
18, the following figure, enter the password, continue next>
screen.width-460) this.width=screen.width-460; } "border=0>
19. Click Execute to complete the configuration and start the MySQL service!
screen.width-460) this.width=screen.width-460; } "border=0>
20, click Finish to complete your MySQL installation!
' m ') this.width= ' 700 '; } "border=0>
[Restore Cathena Mysql database backup]
===============================================================================
Copy the Ragnarok directory you just backed up to your MySQL database directory to complete the MySQL version upgrade

Current 1/2 page 12 Next read the full text