we own a elastix server and since yesterday we face some serious issues, suddenly the vtiger crm is not working any more. According to analisis from anther expert who is doing costomization on vtiger for us the problem is that sql server is damaged and has to be fixed. THIS IS A VERY URGENT JOB AND HAS TO BE DONE AS SOON AS POSIBLE.
The job is to restore MySQL and take a backup / or enable me to take a backup of vtiger database, later restore this database on another server (vtiger is already installed and ready to work, just backup file has to be restored.
Here some comments what might help:
----- only possible solution i see right now is install another setup of same mysql on some machine, once done then copy missing file in /var/lib/mysql/mysql/ on current server from this new install mysql server "/var/lib/mysql/mysql/". Also just copy only missing files and not all. One more note before copy you will have to stop mysql server on new installation.
---- I tried restoring your server back but it not working. After looking in your server i found that some of table in a database called mysql are missing. this are tables used by mysql server to run properly. one of table was plugins, it was missing. i tried to move my local machine table to upload there but still it not working. Then to setup of different server you send me, i had to take backup of vtiger database for which mysql server has to first start working. I cant just copy actual files from hard disk as vtiger database is innodb and it will not work.
---- Just finding a situation where mysql is totally crashed and lot of it system table are missing. Im not that expert to handle this kind of issues. The table i had uploaded(plugins) i removed them.