Disk quota values are different from the actual values
Symptoms
The value in the Disk field in user settings differs from the actual disk quotas.
Causes
- partition mount point was changed
- quotas were defined incorrectly during installation
Solution
Download this script for disk quotas synchronization, save to any directory (e.g. /root) and make it executable:
chmod +x /root/fix_quotas.sh
The script will not work if it is run without administrator rights and if the DBMS administrator password in the file at /root/.my.cnf differs from the actual one.
The script automatically defines the file system type and the type of the database server:
sh /root/fix_quotas.sh
If necessary, you can specify the path to a specific directory if another partition with a different file system is mounted into it (e.g. /var/www):
sh /root/fix_quotas.sh /var/www