Backup Issue and Site Crashing

Hello - We have a daily backup schedule with virtualmin everytime it backup we get this error and sometime website just crashes this is the error we are getting

mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD'

Is there any resolution to this.

Dumping MySQL database blog .. .. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD' (Errcode: 24)' when trying to dump tablespaces mysqldump: Couldn't execute 'show fields from wp_commentmeta': Out of resources when opening file '/tmp/#sql_7c0_0.MYD' (Errcode: 24) (23)

Dumping MySQL database demo ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD' (Errcode: 24)' when trying to dump tablespaces

mysqldump: Couldn't execute 'show fields from 0_areas': Out of resources when opening file '/tmp/#sql_7c0_0.MYD' (Errcode: 24) (23)

Dumping MySQL database kayako ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD' (Errcode: 24)' when trying to dump tablespaces

mysqldump: Couldn't execute 'show fields from swapplogdata': Out of resources when opening file '/tmp/#sql_7c0_0.MYD' (Errcode: 24) (23)

Dumping MySQL database store ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD' (Errcode: 24)' when trying to dump tablespaces

mysqldump: Couldn't execute 'show fields from cscart_addon_descriptions': Out of resources when opening file '/tmp/#sql_7c0_0.MYD' (Errcode: 24) (23)

Dumping MySQL database ss ..
.. dump failed! mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_7c0_2.MYD' (Errcode: 24)' when trying to dump tablespaces

mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'thetowel'': Out of resources when opening file '/tmp/#sql_7c0_0.MYD' (Errcode: 24) (23)