Perl script for mysql crash report

[14sudharsan]

Hi Team,
Some time tables are getting crash . Later only we came to know while pulling reports data missing it was paining.

So could pls give me a perl script to check asterisk database every hour .

If any tables crashed generate notification or If mail notification it will be very help full for us

I hope you guys give me a solution

Thanks in advance

[williamconley]

1) Welcome back to the Party!

2) I will now remind you of the Newbie Suggestions, please try to remember them:

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) command line to repair

Code: Select all

mysqlcheck --auto-repair asterisk -p

4) If your HD is full, this can cause frequent data corruption. If it is not a full HD, you have a dying hard drive or Bad Install.

5) Happy Hunting!