How to implement Mysql switching data storage directory Today, I encountered at work that the partition space where mysql is stored has been used up, resulting in mysql being unable to start normally. For this reason, I had to migrate the data storage directory. 1. Transfer the existing data storage directory to another storage space. Today, it took more than 30 minutes to copy a 50G data file, which was a bit slow. 2. Modify the my.cf configuration file Modify the storage directory [mysqld] datadir=/home/mysql socket=/home/mysql/mysql.sock [mysql_safe] pid-file=/home/mysql/mysqld.pid Added [mysql] socket=/home/mysql/mysql.sock 3. Be sure to pay attention to modifying the permissions of the data storage directory, especially when mysql_safe pid home/mysql/mysqld.pid* ended Similar exceptions Thank you for reading, I hope it can help you, thank you for your support of this site! You may also be interested in:
|
<<: A brief discussion on why daemon off is used when running nginx in docker
>>: A brief talk about React Router's history
Use jQuery to implement form validation, for your...
By default, Flash will always be displayed at the ...
What is VNode There is a VNode class in vue.js, w...
Given an array [1,8,5,4,3,9,2], write an algorith...
Preface Linux does not have a prominent Recycle B...
Table of contents 1. Generate a certificate 2. En...
1. Rounded Corners Today's web designs are con...
Table of contents 1. What is virtual dom? 2. Why ...
First, the principle of esp8266 publishes message...
Table of contents 1. Environment Configuration 1....
Table of contents 1. Repeated declaration 1.1 var...
Preface For a data-centric application, the quali...
When the jsp that is jumped to after the struts2 a...
Copy code The code is as follows: html, address, ...
This article shares the specific code of Node.js+...