{"id":1956,"date":"2020-08-18T11:14:52","date_gmt":"2020-08-18T03:14:52","guid":{"rendered":"http:\/\/www.laihp.top\/zqb\/?p=1956"},"modified":"2020-08-19T16:25:40","modified_gmt":"2020-08-19T08:25:40","slug":"centos7%e4%b8%8bmariadbmysql%e6%9b%b4%e6%94%b9%e9%bb%98%e8%ae%a4%e7%9b%ae%e5%bd%95","status":"publish","type":"post","link":"https:\/\/www.laihp.top\/zqb\/?p=1956","title":{"rendered":"CentOS7\u4e0bMariaDB\/MySql\u66f4\u6539\u9ed8\u8ba4\u76ee\u5f55"},"content":{"rendered":"

\u6b63\u786e\u7684\u914d\u7f6e\u65b9\u6cd5\u5982\u4e0b\uff1a
\n\u8fd9\u91cc\u628a\u9ed8\u8ba4\u4f4d\u7f6e\u4ece\/var\/lib\/mysql\u6539\u4e3a\/data\/mysql<\/p>\n

systemctl stop mariadb<\/p>\n

\n
#\u65b0\u5efa\u76ee\u5f55\r\n[root@mariadb-t1 ~]# mkdir \/data\/mysql\r\n#\u4fee\u6539\u6743\u9650\r\n[root@mariadb-t1 ~]# chown mysql:mysql \/data\/mysql\r\n\r\ncp -rp \/var\/lib\/mysql\/*\u00a0\/data\/mysql\r\n \r\n \r\n#ll\u4e24\u4e2a\u76ee\u5f55\u5c5e\u6027\u548c\u6587\u4ef6\uff0c\u786e\u8ba4\u65e0\u8bef\u540e\uff0c\u5373\u53ef\u5c06\u539f\u76ee\u5f55\u91cd\u547d\u540d\r\nmv \/var\/lib\/mysql \/var\/lib\/mysql.bak<\/code><\/pre>\n<\/div>\n
\u6ce8\u610f\uff01\u5728\u786e\u8ba4\u8fc1\u79fb\u6210\u529f\u4e4b\u524d\u8bf7\u4e0d\u8981\u5220\u9664\u539f\u76ee\u5f55\uff0c\u4e5f\u4e0d\u8981\u4f7f\u7528mv\u547d\u4ee4\u5c06\u539f\u76ee\u5f55\u79fb\u52a8\u81f3\u65b0\u8def\u5f84\u4e2d\uff01\uff01\uff01<\/div>\n
 <\/p>\n
    \n
  • \u914d\u7f6e\u65b0\u76ee\u5f55
    \n\u6587\u4ef6:\u00a0\/etc\/my.cnf<\/li>\n<\/ul>\n
    [<\/span>mysqld]<\/span>\r\n\r\n# \u6ce8\u91ca\u65e7\u7684\u76ee\u5f55\u4f4d\u7f6e<\/span>\r\n# datadir=\/var\/lib\/mysql<\/span>\r\n# socket=\/var\/lib\/mysql\/mysql.sock<\/span>\r\n\r\n# \u5b9a\u4e49\u65b0\u7684\u76ee\u5f55\u4f4d\u7f6e<\/span>\r\ndatadir=<\/span>\/data\/mysql\r\nsocket=<\/span>\/data\/mysql\/mysql.sock<\/code><\/pre>\n
     <\/p>\n
      \n
    • \u670d\u52a1\u7aefsock\u914d\u7f6e
      \n\u6587\u4ef6:\u00a0\/etc\/my.cnf.d\/server.cnf<\/li>\n<\/ul>\n
      [<\/span>mysqld]<\/span>\r\nsocket=<\/span>\/data\/mysql\/mysql.sock<\/code><\/pre>\n
       <\/p>\n
        \n
      • \u5ba2\u6237\u7aefsock\u914d\u7f6e
        \n\u6587\u4ef6:\u00a0\/etc\/my.cnf.d\/client.cnf<\/li>\n<\/ul>\n
        [<\/span>client]<\/span>\r\nsocket=<\/span>\/data\/mysql\/mysql.sock\r\nprot=3306<\/code><\/pre>\n
        <\/div>\n
          \n
        • \u91cd\u542fMariaDB\u670d\u52a1<\/li>\n<\/ul>\n
          systemctl restart mariadb.service<\/code><\/pre>\n
           <\/p>\n
          \u53c2\u8003\u6587\u7ae0\uff1a<\/p>\n
          \u4fee\u6539\u4e0e\u8fc1\u79fbmariadb\u7684data\u6587\u4ef6\u5939<\/a><\/p><\/blockquote>\n