CDR disappeared overnight?

[GSnover]

I have used this method MANY times in the past successfully with no side effects:

How do I fix this error?

When someone gives you an answer that you don’t know what it is go to Google. If you put in “linux mysql command line database repair” you would be shocked. It’s a miracle, the answer is right before your eyes. If you Google “fix mysql database” you will be lost. Learning to construct useful searches is imperative if you are trying to self support yourself on complex IT tasks without experience. And, for the love of God, make a backup of the hosed DB (from said command line not FreePBX) bef…

Specifically:

@Phades

Log in to your server via SSL or whatever you use to get a Linux command prompt with admin priveledges
type: mysqlcheck --repair --use-frm --all-databases

Do run a backup before you do this just in case.