win2008 R2服务器下修改MySQL 5.5数据库data目录的方法_MySQL
win2008 R2服务器下修改MySQL 5.5数据库data目录的方法_MySQL
说明：
操作系统：Windows Server 2008 R2
MySQL版本：5.5.25a
MySQL程序安装目录：D:\Program Files\MySQL\MySQL Server 5.5
MySQL数据库默认目录：C:\ProgramData\MySQL\MySQL Server 5.5\data\
需求：修改MySQL数据库目录为D:\Program Files\MySQL\MySQL Server 5.5\data
具体操作：
一、停止MySQL
开始-cmd
net stop mysql55
二、复制原来数据库目录到新目录
1、备份D:\Program Files\MySQL\MySQL Server 5.5\中的data目录为data-bak
2、复制C:\ProgramData\MySQL\MySQL Server 5.5\中的data目录到
D:\Program Files\MySQL\MySQL Server 5.5\目录下
系统运维 www.osyunwei.com 温馨提醒：qihang01原创内容版权所有,转载请注明出处及原文链接
三、修改MySQL配置文件
1、用记事本打开C:\ProgramData\MySQL\MySQL Server 5.5\data\目录下的my.ini
找到datadir="C:\ProgramData\MySQL\MySQL Server 5.5\data"
在前面加#注释掉
在下面添加一行
datadir="D:\Program Files\MySQL\MySQL Server 5.5\data"
修改完成后，保存退出。
2、复制C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\目录下的my.ini到
D:\Program Files\MySQL\MySQL Server 5.5\目录下
四、重新启动MySQL
1、开始-cmd
net start mysql55
2、进入MySQL控制台
开始-所有程序-MySQL-MySQL Server 5.5-MySQL 5.5 Command Line Client
提示输入MySQL root账号的密码，输入之后回车，进入MySQL控制台
show variables like '%datadir%'; #查询MySQL数据库存放目录，如下图所示
可以看到MySQL数据库存放目录已经修改为D:\Program Files\MySQL\MySQL Server 5.5\data
至此，Windows Server 2008 R2下修改MySQL 5.5数据库目录完成
以上就是win2008 R2服务器下修改MySQL 5.5数据库data目录的方法_MySQL的内容，更多相关内容请关注PHP中文网（www.php.cn）！
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
1376
52
What data is in the data folder?
May 05, 2023 pm 04:30 PM
The data folder contains system and program data, such as software settings and installation packages. Each folder in the Data folder represents a different type of data storage folder, regardless of whether the Data file refers to the file name Data or the extension. Named data, they are all data files customized by the system or program. Data is a backup file for data storage. Generally, it can be opened with meidaplayer, notepad or word.
What to do if mysql load data is garbled?
Feb 16, 2023 am 10:37 AM
The solution to the garbled mysql load data: 1. Find the SQL statement with garbled characters; 2. Modify the statement to "LOAD DATA LOCAL INFILE "employee.txt" INTO TABLE EMPLOYEE character set utf8;".
What are the differences between xdata and data
Dec 11, 2023 am 11:30 AM
The differences are: 1. xdata usually refers to independent variables, while data refers to the entire data set; 2. xdata is mainly used to establish data analysis models, while data is used for data analysis and statistics; 3. xdata is usually used for regression Analysis, variance analysis, predictive modeling, data can be analyzed using various statistical methods; 4. xdata usually requires data preprocessing, and data can contain complete original data.
More returns than sales: The Humane Ai Pin is becoming a commercial disaster
Aug 08, 2024 pm 01:14 PM
Shortly after the launch of the Humane Ai Pin, scathing reviews revealed that the AI gadget was anything but ready for the market, as most of the originally advertised features either didn't work properly or were simply missing, the battery life was
AI project failure rates top 80% — study cites poor problem recognition and a focus on latest tech trends among major problems
Aug 31, 2024 am 12:59 AM
Everyone and their aunt seem to be hopping aboard the AI train in search of inflated profit margins and marketing hype — just look at AMD's recent Ryzen rebrand as a prime example of this AI hype. A recent study conducted by RAND has found that this
MySQL writes crazy error logs
Feb 18, 2024 pm 05:00 PM
A core business database, the version is MySQL8.34 Community Server Edition. Since its launch, the error log of this database server has increased very rapidly (as shown in the figure below), and can increase to more than 10 G in capacity every 24 hours. Because there was a fault alarm and normal access to the business had not been affected, the relevant personnel were not allowed to restart the MySQL service. In view of this situation, I had to set up an automatic scheduled task to clean these logs at a fixed time every night. For specific operations, execute "crontab -e" on the system command line and add the following text line: 0001***echo>/data/mysql8/data/mysql_db/mysql.log Save and exit edit mode
Can't data in vue component be a function?
Dec 19, 2022 pm 05:22 PM
No, data in the vue component must be a function. Components in Vue are used for reuse. In order to prevent data reuse, they are defined as functions. The data data in the vue component should be isolated from each other and not affect each other. Every time the component is reused, the data data should be copied once. Later, when the data data in the component is changed in a reused place, other data will be copied. If the data data of reused local components is not affected, you need to return an object as the status of the component through the data function.
Hackers can now reconstruct screen content from HDMI\'s electromagnetic radiation
Jul 30, 2024 am 10:01 AM
A concerning vulnerability has been revealed in modern computer systems, as per a new study. Federico Larroca at the University of the Republic in Montevideo, Uruguay, and his colleagues have developed an AI model that can reconstruct digital signals
