1

[MySQL] Changing datadir location

view story
linux-howto

https://bbs.archlinux.org – Seems that you might be missing a file--at least, that's what the error is telling you.Confirm that mysql-bin.index exists in your ~/.mysql directory and try starting it again. Also, all files (and the directory containing them) should be set to mysql:mysql and the parent directory's permissions should probably be set to 0750 or 0770. Worst case remove your ~/.mysql directory and, as root, copy it back over:cp -a /var/lib/mysql /home/norvoles/.mysqlAlso, double-check your datadir setting in /etc/mysql/my.cnf. If it contains a typo, that might also explain what you're seeing. (HowTos)