quota error with /var/lib/mysql

[iczy]

I set quota on

#it worked
/home
/


#does not work
/var/lib/mysql


[root@ns3 mysql]# quota -v
quota: Cannot open quotafile /var/lib/mysql/aquota.user: No such file or directory
Disk quotas for user root (uid 0):
Filesystem blocks quota limit grace files quota limit grace
/dev/sda2 2007224 0 0 52193 0 0
/dev/sda5 28 0 0 4 0 0




[root@ns3 mysql]# df -lh
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 58G 2.8G 53G 5% /
tmpfs 939M 0 939M 0% /dev/shm
/dev/sda1 485M 30M 430M 7% /boot
/dev/sda5 827G 201M 785G 1% /home
/dev/sda3 1008M 34M 924M 4% /tmp
/dev/sdb2 150G 255M 142G 1% /var/lib/mysql



my fstab

/dev/sda2 / ext4 defaults,usrquota,grpquota 1 1
/dev/sda1 /boot ext4 defaults 1 2
/dev/sda5 /home ext4 defaults,usrquota,grpquota,nosuid 1 2
/dev/sda3 /tmp ext4 loop,noexec,nosuid,rw 0 0
/dev/sdb2 /var/lib/mysql ext4 defaults,usrquota,grpquota 1 2
/dev/sdb1 swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults,nosuid,noexec,rw 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0

 

[scsi]

Because you didnt enable quotas on the filesystem yet.

quotacheck -avug

 

[zEitEr]

quota error with /var/lib/mysql

Hello,

What are trying to achieve with that? Do you think it's possible to set quotas on MySQL databases in such a way?