Hook for mysqlcheck repairs databases
Posted: March 6th, 2023, 9:11 am
Hi.
Before use hook for make a mysqlcheck all databases before backup job, I want to ask a question.
Jetbackup does a mysqlcheck before each backup job (global job) or before each mysqldump or individual job ?
If not is correcta my script
Script is on /hooks/mysqlchek.sh with 755 permissions and owner root.
Best regards
Before use hook for make a mysqlcheck all databases before backup job, I want to ask a question.
Jetbackup does a mysqlcheck before each backup job (global job) or before each mysqldump or individual job ?
If not is correcta my script
Code: Select all
#!/bin/bash
mysqlcheck --repair --all-databases
exit_code=$?
if [ $exit_code -eq 0 ]; then
echo "MySQL check was successful"
else
echo "MySQL checkfailed with exit code $exit_code"
fi
Script is on /hooks/mysqlchek.sh with 755 permissions and owner root.
Best regards