问题原文
原帖链接 · iWizard · CC BY-SA 3.0
I used to use mysql data in /var/lib/mysql, now I have created new partition and created tank on it to use with zfs.
After that I follow this steps to move my existing mysql data to new dir: https://serverfault.com/a/539729/184573
Everything worked ok so I have imported new big db (100 GB) and now is not working anymore.
in "/var/log/mysql/error.log"
Detailed explanation:
I'm on /tank/mysql, using zfs and everything is working ok
imported new db, mysql was working ok
stopped mysql service and executed zfs
snapshot tank/mysql@imported now I cannot start mysql because of upper error
- tried to chown mysql:mysql /tank/mysql -R , still same error
I have google that problem and none of solutions helped me. Permissions, settings,... everything seems to be ok.
OS: Ubuntu server 14.04.
Server: IBM X3200 m3
What could be a problem?
Thank you
已采纳解答
原帖链接 · ksm · CC BY-SA 3.0
Posting this as an answer.
It was a file permissions issue. U need to ensure that the mysql user has access to the mysql datadir and the directory it is in, all the way to the root level directory.
If multiple users need access to these directories, then put them in a group and then give that group access to those directories.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
