Home Database Mysql Tutorial Detailed explanation of how to modify the data location of Mysql5.7 under Windows 7

Detailed explanation of how to modify the data location of Mysql5.7 under Windows 7

Feb 11, 2018 am 10:47 AM
windows7 Revise

Update: Now go to the MySQL official website and install the mysql installer to uniformly manage and configure the mysql software. Migrating data is also very convenient. Enter the mysql installer to reconfigure the mysql server, and the database storage location will be changed. It is more stable than the old-fashioned manual migration below (it is easy for the database to fail to start or close properly after manual migration). This article mainly introduces to you the method of modifying the loading path and data location of the my.ini file of Mysql5.7 under Windows 7. Friends in need can refer to it. I hope it can help you.

Because I want to transfer the company's online database to the local for testing, I have been tinkering for a long time to modify the data location of the local mysql. There are also many introductions to the online information. I will not go into details. I will write down the problems I encountered for reference. For everyone’s reference.

mysql version: 5.7
os: windows7

(Different mysql versions may have differences in the installation path data path and my.ini startup configuration file path Differences, no research required)

Change the data location of mysql, except what the information on the Internet says:

(1) Close the mysql service;

(2) Modify the datadir of my.ini (path "\" or "/", whether the entire path name requires double quotes, please try it yourself, whatever works, I don't need double quotes, forward and back slashes are fine);

(3) Then migrate the entire data folder (this data folder may be in different folders depending on the version and system, for example, it may be in c:\Program Files\MySQL or c:\ProgramData\ Under MySQL, it is recommended to use the software everything to find it yourself) to the modified directory; (4) Finally restart.

In addition to these 4 basic steps, you must also pay attention to which startup file my.ini is used by MySQL. This is subject to the information of mysql in the windows registry. The specific operation is: Start-Run-regedit-Enter, enter the windows registry, and then find [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySql] (Note that this is the registration path under win7 and mysql5.7, other versions may be different), just modify the path file after "--defaults-file=" in "ImagePath". This file is when mysql starts. The configuration file read is not necessarily placed in the mysql installation directory or the data directory, it must be the configuration file used.

Related recommendations:

Detailed example of how to create the my.ini file in the MySQL5.7.19 installation directory

MySQL 5.6 & 5.7 optimal configuration file template (my.ini)_MySQL

MySQL optimization configuration file my.ini (discuz forum)

The above is the detailed content of Detailed explanation of how to modify the data location of Mysql5.7 under Windows 7. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
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

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

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to change the personal name in the group on DingTalk_How to modify the personal name in the group on DingTalk How to change the personal name in the group on DingTalk_How to modify the personal name in the group on DingTalk Mar 29, 2024 pm 08:41 PM

1. First open DingTalk. 2. Open the group chat and click the three dots in the upper right corner. 3. Find my nickname in this group. 4. Click to enter to modify and save.

How to Change User Folder Name: Win11 Tutorial How to Change User Folder Name: Win11 Tutorial Jan 09, 2024 am 10:34 AM

Some games will be automatically installed into the user folder and require an English folder. However, many friends do not know how to modify the user folder name in win11. In fact, we only need to modify the user name. Modify the user folder name in win11: The first step is to press the "Win+R" key combination on the keyboard. In the second step, enter "gpedit.msc" and press Enter to open the Group Policy Editor. Step 3: Expand "Security Settings" under "Windows Settings" Step 4: Open "Security Options" in "Local Policies" Step 5: Double-click to open the "Account: Rename System Administrator Account" policy on the right. Step 6: Enter the name of the folder you want to modify below and click "OK" to save. Modify user folder

Can Douyin Blue V change its name? What are the steps to change the name of corporate Douyin Blue V account? Can Douyin Blue V change its name? What are the steps to change the name of corporate Douyin Blue V account? Mar 22, 2024 pm 12:51 PM

Douyin Blue V certification is the official certification of a company or brand on the Douyin platform, which helps enhance brand image and credibility. With the adjustment of corporate development strategy or the update of brand image, the company may want to change the name of Douyin Blue V certification. So, can Douyin Blue V change its name? The answer is yes. This article will introduce in detail the steps to modify the name of the enterprise Douyin Blue V account. 1. Can Douyin Blue V change its name? You can change the name of Douyin Blue V account. According to Douyin’s official regulations, corporate Blue V certified accounts can apply to change their account names after meeting certain conditions. Generally speaking, enterprises need to provide relevant supporting materials, such as business licenses, organization code certificates, etc., to prove the legality and necessity of changing the name. 2. What are the steps to modify the name of corporate Douyin Blue V account?

PyCharm background color adjustment tips: Master it quickly! PyCharm background color adjustment tips: Master it quickly! Feb 03, 2024 am 09:39 AM

To quickly master the skills of modifying the background color of PyCharm, you need specific code examples. In recent years, the Python language has become more and more popular in the field of program development, and PyCharm, as an integrated development environment (IDE), is loved and used by the majority of developers. In PyCharm, some developers often personalize the IDE interface, including changing the background color. This article will introduce the technique of modifying the background color of PyCharm and give specific code examples to help readers quickly master this skill.

Accelerate pip source and solve the problem of slow download speed Accelerate pip source and solve the problem of slow download speed Jan 17, 2024 am 10:18 AM

Quickly modify the pip source to solve the problem of slow download speed. Specific code examples are required. Introduction: During the development process of using Python, we often need to use pip to install various third-party libraries. However, due to network environment limitations or default source issues, pip download speeds are often very slow, which brings inconvenience to our development. Therefore, this article will introduce how to quickly modify the pip source to solve the problem of slow download speed, and provide specific code examples. 1. Problem Analysis When using pip to download third-party libraries, I

Win10 sleep time modification tips revealed Win10 sleep time modification tips revealed Mar 08, 2024 pm 06:39 PM

Win10 Sleep Time Modification Tips Revealed As one of the currently widely used operating systems, Windows 10 has a sleep function to help users save power and protect the screen when not using the computer. However, sometimes the default sleep time does not meet the needs of users, so it is particularly important to know how to modify the Win10 sleep time. This article will reveal the tips for modifying the sleep time of Win10, allowing you to easily customize the system’s sleep settings. 1. Modify Win10 sleep time through “Settings” First, the simplest fix

The copy of windows7 build 7601 is not genuine. The simplest solution is that the copy of build 7601 is not genuine. The copy of windows7 build 7601 is not genuine. The simplest solution is that the copy of build 7601 is not genuine. Mar 15, 2024 pm 09:49 PM

Recently, some friends reported that their computer prompts "The copy of Windows 7 internal version 7601 is not genuine." They all want to know if the copy of Windows 7 is not genuine 7601 and affects the use of it. The main reason for this is that the user's system has not been activated. Today I will give it to you. Let’s talk about the simplest solution to the problem that the copy of internal version 7601 is not genuine. Friends in need can come and take a look. The copy of windows7 internal version 7601 is not genuine. Method 1: 1. Press "win r" on the keyboard at the same time, then enter "CMD", and then press "Enter" to confirm. 2. Enter "SLMGR-REARM" in the pop-up window. Please note that there is a space in the middle. Don't miss it. 3. Then press Enter to confirm. A dialog box will pop up and click "Confirm".

How to modify the address location of published products on Xianyu How to modify the address location of published products on Xianyu Mar 28, 2024 pm 03:36 PM

When publishing products on the Xianyu platform, users can customize the geographical location information of the product according to the actual situation, so that potential buyers can more accurately grasp the specific location of the product. Once the product is successfully put on the shelves, there is no need to worry if the seller's location changes. The Xianyu platform provides a flexible and convenient modification function. So when we want to modify the address of a published product, how do we modify it? This tutorial guide will provide you with a detailed step-by-step guide. I hope it can help. Everyone! How to modify the release product address in Xianyu? 1. Open Xianyu, click on what I published, select the product, and click Edit. 2. Click the positioning icon and select the address you want to set.

See all articles