Submitted by zerocoldgm on Mon, 11/04/2013 - 00:58
I tried to do the backup but I will generate this error
Any idea for fix...?
Dumping MySQL database gsaragno ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_73b_2.MYI' (Errcode: 24)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show events': Out of resources when opening file '/tmp/#sql_73b_0.MYI' (Errcode: 24) (23)
Dumping MySQL database gsaragno_web ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_73b_2.MYI' (Errcode: 24)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show events': Out of resources when opening file '/tmp/#sql_73b_0.MYI' (Errcode: 24) (23)
Status:
Closed (fixed)
Comments
Submitted by zerocoldgm on Mon, 11/04/2013 - 06:53 Comment #1
the problem is Fix.....
clearing the cache
and compact & fix the db (also insert in cronjob)
mysqlcheck -orA -pPassword > /dev/null
reboot the server
and backup and 'finished successfully
Submitted by andreychek on Mon, 11/04/2013 - 07:30 Comment #2
I'm glad you got it working!
If you run into that issue again, take a peek at my first comment here, which describes a method of fixing that:
http://www.virtualmin.com/node/24829