...
As a result, reports will not work.
Shell |
---|
mysqlcheck -u`cat /etc/voipnow/.sqldb | awk -F ":" '{print $2}'` -p`cat /etc/voipnow/.sqldb | awk -F ":" '{print $3}'` voipnow call_history |
When the table is OK, the output is this:
...
You can also perform a check on all tables (beware that this will create load on the system):
Shell |
---|
mysqlcheck -u`cat /etc/voipnow/.sqldb | awk -F ":" '{print $2}'` -p`cat /etc/voipnow/.sqldb | awk -F ":" '{print $3}'` voipnow |
Fix the crashed table
To fix the table, simply log in to MySQL.
Shell |
---|
mysql -u`cat /etc/voipnow/.sqldb | awk -F ":" '{print $2}'` -p`cat /etc/voipnow/.sqldb | awk -F ":" '{print $3}'` voipnow |
And run:
Shell |
---|
MariaDB [voipnow]> repair table call_history; |
Related articles
Content by Label | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
hidden | true |
---|
...
|
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.