Good morning Bene ... thank you very much for your interest, sorry the delay was outside, enjoying a little summer with the family
Sorry for my english ... I only use a google translate.
I have tried several things reading some forums but none of them have been effective in order to expand the 2000 that I need
I have changed values
Ulimit -n 10000
I have changed values in
/etc/security/limits.conf
I have modified values on mysql in your configuration file forcing the new values on the parameter
Open-files-limit = 2000
But I have not been able to get all the data at once .., so far I have worked with workbench to get sql ...
But with the script that makes our backup in the panel does not leave the whole copy,
More or less is a small summary
output --- >
mysql> SHOW GLOBAL STATUS LIKE 'Open_files';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Open_files | 442 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'Open_files_limit';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 1024 |
+------------------+-------+
1 row in set (0.00 sec)