• Linux

mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’

By Prasad Naik

July 15, 2016

While creating of backup of mysql I was getting below error mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’ (Errcode: 24 “Too many open files”)’ The error is due to Mysql exceeding the limit of open files on mysql So I just went ahead and saw the open file limit MariaDB [(none)]> SHOW VARIABLES […]