Can't find file: './mysql/plugin.frm' (errno: 13)[mysql數(shù)據(jù)目錄遷移錯(cuò)位]錯(cuò)誤解決
數(shù)據(jù)目錄從/var/lib/mysql遷移至/data盤
1.拷貝文件到/data目錄千贯，需要保持權(quán)限
chown -R mysql:mysql /data/mysql*
2.修改/etc/mysql/my.cnf
指定datadir=/data/mysql
3.修改 vi /etc/apparmor.d/usr.sbin.mysqld
/var/lib/mysql/ r,# /var/lib/mysql/** rwk, 改為 /data/mysql/ r, /data/mysql/** rwk,
修改完重載該文件 /etc/init.d/apparmor reload
4.修改 vim /etc/mysql/mysql.conf.d/mysqld.cnf(具體看安裝路徑，/etc/mysql/my.cnf)
basedir = /usr
datadir = /dbs/mysql/data
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
secure_file_priv= /dbs/mysql-files
expire_logs_days = 7
max_binlog_size = 1024M
5.sql_mode修改
show variables like "sql_mode";
[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION
- Packet for query is too large (1649 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
修改max_allowed_packet參數(shù)
6.重啟mysql即可
