vicidial.org

hi gain guys.... i just want to know on how to execute this repair automatically in a given time everyday.....

" mysqlcheck -u cron -p --repair --all-databases "

... and also steps on how to do it. thanks again guys for the help and more power to you

God bless!

Just put that command in the crontab
http://www.computerhope.com/unix/ucrontab.htm

You should run a check repair and optimize often
One liner for cron that will check repair and optimize at whatever time you specifiy for the cron.

mysqlcheck -uxxx -pxxx -cs dbname && mysqlcheck -uxxx -pxxx -rs dbname mysqlcheck -uxxx -pxxx -os dbname

Then grab a backup of the db.

thank you for the reply....

can i write directly this on crontab -e ...

01 9 * * * mysqlcheck -u cron -p'*****' --repair --all-databases

thanks again

I create an script for this:
This will CHECK DB
mysqlcheck -u root -pPASSWORD --auto-repair --check -e -o --optimize --all-databases


and this will generate a BackUP with the time as part of file name ( and will be compressed ):
mysqldump -u root -pPASSWORD --all-databases | xz -9 > DB_BackUp-`(date +"%m-%d-%Y")`.sql.xz

I may be wrong, but you should enforce the check and the backup of DB, always worth to be prepared for a DISASTER !!!

is it okay to write that? or should i write it like this on crontab

01 9 * * * /usr/bin/mysqlcheck -u root -p'PASSWORD' --auto-repair --check -e -o --optimize --all-databases

or this .....

01 9 * * * mysqlcheck -u root -p'PASSWORD' --auto-repair --check -e -o --optimize --all-databases

and what is the syntax to back up the database?

thanks for the help.... i really really appreciate it

We do have a script to check tables in VICIdial

# /usr/share/astguiclient/AST_DB_check_tables.pl --help
allowed run time options:
[--quick] = run test in QUICK mode, may not catch all issues
[--email-list=test.com:test2.com] = send email results to these addresses
[--email-sender=vicidial] = sender for the email results
[--test] = test
[--quiet] = quiet
[--debug] = verbose debug messages
[--debugX] = extra verbose debug messages