One solution for 100 problems

[globalme]

I have seen many problem get solved once we run below command :

mysqlcheck --auto-repair asterisk -ppassword

1) How to provide a link in admin section of the portal where even the normal tech guy can click and repair the db ?

2) How to add these line in cronjob so that when we start the server , db get repair automatically ??

[gardo]

You can add it to /etc/rc.local. That's the file responsible for automatically starting programs on bootup.

[globalme]

Trick is when we run that command, it asks for password.

How to bypass that ?

[gardo]

mysqlcheck --auto-repair asterisk -p"password"

Where "password" is the password without the quotes. That should do the trick.

[globalme]

In my case password is blank , so in mine , statement would be

mysqlcheck --auto-repair asterisk -p""


OR

mysqlcheck --auto-repair asterisk -p

[globalme]

Tried mysqlcheck --auto-repair asterisk -p"" but it get stuck at

enter password :

[marcin]

You have to put root password for mysql between quotes:
i.e. if mysql root password is gue12T7
the command should look :
mysqlcheck --auto-repair asterisk -uroot -p"gue12T7"
or
mysqlcheck --auto-repair asterisk -uroot -pgue12T7
in case of blank password use this:
mysqlcheck --auto-repair asterisk -uroot -p""
if there is no password for root use this :
mysqlcheck --auto-repair asterisk -uroot