Home > Article > Backend Development > 【MySQL】迁移数据目录 php
【MySQL】迁移数据目录 php
- WBOYOriginal
- 2016-06-23 13:23:421098browse
//// move dir
# mv /var/libmysql /mnt/data/
//// vi /etc/my.cnf
【mysqld】 // 服务器端
datadir=/mnt/data/mysql
socket=/mnt/data/mysql/mysql.sock
【mysql】 // 客户端
socket=/mnt/data/mysql/mysql.sock
/// restart to check
/// need to update config in /etc/php.ini
pdo_mysql.default_socket=/mnt/data/mysql/mysql.sock
mysql.default_socket = /mnt/data/mysql/mysql.sock
mysqli.default_socket = /mnt/data1/mysql/mysql.sock
/// reference : http://www.aiezu.com/db/mysql_cant_connect_through_socket.html
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
Previous article：大神来帮忙啊！怎么把这两段代码的功能结合起来啊，试了一天了。Next article：PHP获取查询数据中最早的时间和最晚时间怎么写这样不知对不对