...
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.