Bastilla Posted May 11, 2017 Share 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 Link to comment Share on other sites More sharing options...
martinayotte Posted May 11, 2017 Share Posted May 11, 2017 Do you have the folder /var/log/mysql/ ? If not, create it, and restart mysqld service. Link to comment Share on other sites More sharing options...
Recommended Posts