You are getting this error while opening a file which means mysql file open permission has been exceeded.
Open files limit can be managed by open_files_limit variable, we can run below query in phpmyadmin:
You will check the limit of open_files_limit variable with the output
If you want to increase the limit then you have to make changes in /etc/my.cnf file file.
To reflect the changes you have to restart mysql:
For above steps it is must to have root access, you can again run show
Now, showing the variable should show the number you choose.
You can increase the open_files_limit according to your choice.
Open files limit can be managed by open_files_limit variable, we can run below query in phpmyadmin:
Code:
SHOW VARIABLES LIKE 'open%'If you want to increase the limit then you have to make changes in /etc/my.cnf file file.
Code:
[mysqld]
open_files_limit = 5000
Code:
sudo /etc/init.d/mysql restartNow, showing the variable should show the number you choose.
You can increase the open_files_limit according to your choice.