Bastilla Posted May 11, 2017 Posted May 11, 2017 I want start global log on a database in mysql with query: SET global general_log = 1; Then i get error ERROR 3 (HY000): Error writing file '/var/log/mysql/mysql.log' (Errcode: 28) df-al shows me: Filesystem 1K-blocks Used Available Use% Mounted on sysfs 0 0 0 - /sys proc 0 0 0 - /proc udev 10240 0 10240 0% /dev devpts 0 0 0 - /dev/pts tmpfs 205032 26604 178428 13% /run /dev/mmcblk0p1 29267548 1546492 27394084 6% / tmpfs 512572 0 512572 0% /dev/shm tmpfs 5120 4 5116 1% /run/lock tmpfs 512572 0 512572 0% /sys/fs/cgroup cgroup 0 0 0 - /sys/fs/cgroup/systemd cgroup 0 0 0 - /sys/fs/cgroup/cpuset cgroup 0 0 0 - /sys/fs/cgroup/cpu,cpuacct cgroup 0 0 0 - /sys/fs/cgroup/blkio cgroup 0 0 0 - /sys/fs/cgroup/memory cgroup 0 0 0 - /sys/fs/cgroup/devices cgroup 0 0 0 - /sys/fs/cgroup/freezer cgroup 0 0 0 - /sys/fs/cgroup/net_cls,net_prio cgroup 0 0 0 - /sys/fs/cgroup/perf_event cgroup 0 0 0 - /sys/fs/cgroup/pids systemd-1 - - - - /proc/sys/fs/binfmt_misc debugfs 0 0 0 - /sys/kernel/debug mqueue 0 0 0 - /dev/mqueue fusectl 0 0 0 - /sys/fs/fuse/connections configfs 0 0 0 - /sys/kernel/config tmpfs 512572 0 512572 0% /tmp /dev/mmcblk0p1 29267548 1546492 27394084 6% /var/log.hdd log2ram 51200 51200 0 100% /var/log tracefs 0 0 0 - /sys/kernel/debug/tracing tmpfs 102516 0 102516 0% /run/user/0 /dev/sda2 - - - - /media/nas2 /dev/sda1 - - - - /media/nas1 /dev/sdb 3845579612 1998254388 1651957912 55% /media/usb binfmt_misc 0 0 0 - /proc/sys/fs/binfmt_misc /dev/sdc2 1473048140 809736700 588461880 58% /media/nas2 /dev/sdc1 1410974192 1249961916 89315872 94% /media/nas1 Anyone can help me please? Regards
martinayotte Posted May 11, 2017 Posted May 11, 2017 Do you have the folder /var/log/mysql/ ? If not, create it, and restart mysqld service.
Recommended Posts