search
HomeBackend DevelopmentPHP Tutorialtake me home country roads Illustration of MYSQL installation and data upgrade Page 1/2

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

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 to find the ragnarok database directory
Copy it to other places!
[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 need to see how to completely delete Mysql from your system
When you uninstall the old MYSQL database service from your computer
First install the WINDOWS service Stop the MYSQL service
and then delete it in the Add and Delete program 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_MACHINESYSTEMControlSetServicesEventlogA The applicationMySQL directory is deleted
as shown in the figure below:
 图解MYSQL的安装和数据升级第1/2页
After clearing it,
also remember to Delete this file C:WINDOWSmy.ini
Then restart the computer
Go to your computer services and check if the MYSQL service is gone. Then 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 sourceDownload

http://down.21sun.net/ webtools/MyODBC-3.51.11-1-win.exe/>
MySQL Control Center ( mysqlcc-0.9.4-win32.zip ) -- Management tool Download

http://down.21sun.net/ webtools/mysqlcc-0.9.4-win32.zip/>
[Installation tutorial for Mysql Server 4.1.11]========================== ================================================== =====
1. Run the MYSQL Server 4.1 installation package

 图解MYSQL的安装和数据升级第1/2页2. Click (Change..) to select the installation path. It is recommended that you do not install on the C drive!

 图解MYSQL的安装和数据升级第1/2页3. I chose to install it in the D:Mysql directory, then click OK to proceed to the next step of installation

 图解MYSQL的安装和数据升级第1/2页4. After selecting the installation path, click Next> to proceed to the next step!

 图解MYSQL的安装和数据升级第1/2页5. Click Install to start the installation

 图解MYSQL的安装和数据升级第1/2页6. We see the installation progress!

 图解MYSQL的安装和数据升级第1/2页7. Select the Skip Sign-Up item and click Next> to continue the installation!

 图解MYSQL的安装和数据升级第1/2页8. Our installation has been completed here. After selecting Configure the MySQL Server now,
click Finish to enter the Mysql configuration work

 图解MYSQL的安装和数据升级第1/2页9 , Enter the Mysql configuration interface!

 图解MYSQL的安装和数据升级第1/2页10. Select Detailed Configuration. After selecting, click Next> to proceed to the next step!

 图解MYSQL的安装和数据升级第1/2页11. Select Server Machine and click Next> to continue!
 图解MYSQL的安装和数据升级第1/2页
12. Select Multifunctional Database and click Next to continue!
 图解MYSQL的安装和数据升级第1/2页
13. This step can be defaulted (allowing you to choose the storage location of the database file). It is recommended to default!
 图解MYSQL的安装和数据升级第1/2页
14. Select Online Transaction Processing (OLTP) and click Next>Continue!
 图解MYSQL的安装和数据升级第1/2页
15. As shown below, continue Next>
 图解MYSQL的安装和数据升级第1/2页
16. Select language support! The default is Standard Character Set
 图解MYSQL的安装和数据升级第1/2页
17. Remember to select the Include Bin Directory In Windows Path option and continue
 图解MYSQL的安装和数据升级第1/2页
18. As shown below, enter the password and continue Next>
 图解MYSQL的安装和数据升级第1/2页
19. Click Execute to start completing the configuration and start MYSQL Serve!
 图解MYSQL的安装和数据升级第1/2页
20. Click Finish to complete your Mysql installation!
 图解MYSQL的安装和数据升级第1/2页
[Restore backup of cAthena Mysql database]
======================================== =========================================
Put the ragnarok directory you just backed up, Copy it to your Mysql database directory to complete the upgrade of the Mysql version.

Current page 1/2 12Next page

The above introduces the take me home country roads diagram MYSQL installation and data upgrade on page 1/2, including the content of take me home country roads. I hope it will be helpful to friends who are interested in PHP tutorials.

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How do you create and use an interface in PHP?How do you create and use an interface in PHP?Apr 30, 2025 pm 03:40 PM

The article explains how to create, implement, and use interfaces in PHP, focusing on their benefits for code organization and maintainability.

What is the difference between crypt() and password_hash()?What is the difference between crypt() and password_hash()?Apr 30, 2025 pm 03:39 PM

The article discusses the differences between crypt() and password_hash() in PHP for password hashing, focusing on their implementation, security, and suitability for modern web applications.

How can you prevent Cross-Site Scripting (XSS) in PHP?How can you prevent Cross-Site Scripting (XSS) in PHP?Apr 30, 2025 pm 03:38 PM

Article discusses preventing Cross-Site Scripting (XSS) in PHP through input validation, output encoding, and using tools like OWASP ESAPI and HTML Purifier.

What is autoloading in PHP?What is autoloading in PHP?Apr 30, 2025 pm 03:37 PM

Autoloading in PHP automatically loads class files when needed, improving performance by reducing memory use and enhancing code organization. Best practices include using PSR-4 and organizing code effectively.

What are PHP streams?What are PHP streams?Apr 30, 2025 pm 03:36 PM

PHP streams unify handling of resources like files, network sockets, and compression formats via a consistent API, abstracting complexity and enhancing code flexibility and efficiency.

What is the maximum size of a file that can be uploaded using PHP ?What is the maximum size of a file that can be uploaded using PHP ?Apr 30, 2025 pm 03:35 PM

The article discusses managing file upload sizes in PHP, focusing on the default limit of 2MB and how to increase it by modifying php.ini settings.

What is Nullable types in PHP ?What is Nullable types in PHP ?Apr 30, 2025 pm 03:34 PM

The article discusses nullable types in PHP, introduced in PHP 7.1, allowing variables or parameters to be either a specified type or null. It highlights benefits like improved readability, type safety, and explicit intent, and explains how to declar

What is the difference between the unset() and unlink() functions ?What is the difference between the unset() and unlink() functions ?Apr 30, 2025 pm 03:33 PM

The article discusses the differences between unset() and unlink() functions in programming, focusing on their purposes and use cases. Unset() removes variables from memory, while unlink() deletes files from the filesystem. Both are crucial for effec

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software