mysql修改datadir的后续工作_MySQL
Jun 01, 2016 pm 01:37 PMbitsCN.com
mysql修改datadir的后续工作
我们都知道,在mysql文件夹下面有my.ini文件,修改里面的datadir就可以改变数据库以及表的存放位置,默认在windows下,存放在C:/ProgramData/MySQL/MySQL Server 5.5/Data/,比如我们将datadir修改为I:/data,可能会遇到以下几种情况:
1、重新打开mysql administrator或者相应的command line,我们发现数据的存储位置依然是原来的目录,出现这样的原因是没有停止mysql服务,my.ini没有在启动时重新被读取,我们可以通过命令行停止,或者在控制面板——管理——服务里面停止mysql服务,然后再开启;
2、重新开启mysql服务时,出现了1067的错误,此时我们可以查看datadir所在的新目录下的错误日志文件,可能的原因是,没有将datadir原目录下的performance_schema和mysql两个文件夹复制到新目录下! 将它们复制过来即可。
bitsCN.com
Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

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

Lossless Scaling on Steam Deck OLED runs games at up to 2x FPS

What should I do if I can't delete a Windows system dll file? Tips for completely deleting stubborn dll files

How to update the latest version of Bybit Exchange? Will there be any impact if it is not updated?

deepseek web version entrance deepseek official website entrance

How to fix mysql_native_password not loaded errors on MySQL 8.4

Pi Node Teaching: What is a Pi Node? How to install and set up Pi Node?

Snapdragon X Elite CPU performance nearly identical on battery vs AC power in Vivobook S15 benchmarks
