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

Do you have the folder /var/log/mysql/ ?

If not, create it, and restart mysqld service.