Backup issues

[george]

Hello,

I use the DirectAdmin System backup, but, when i make the backup of 2 different hosting accounts, i receive the following error messages.

Error message on user test1:

Error while backing up database test1_db1
mysqldump error output: mysqldump: Got error: 1356: View 'test1_db1.ass_sobi2_cache' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES

Error message on user test2:

Error while backing up database test2_db2
mysqldump error output: mysqldump: Got error: 29: File './test2_db2/crs_LM85DG_student_publication.MYD' not found (Errcode: 24) when using LOCK TABLES

I do not know how to solve the previous issues.
Is there anyone that can help me, please?
Thank you.

Regards,
George

 

[SeLLeRoNe]

Ok i should be wrong but ofc this will not break anything.

Try to check/optimize all databases:

/usr/bin/mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --check --optimize --all-databases

Regards