database file deleted, cannot open Sentora panel,please help

[peterfam]

I deleted the ibdata1,ib_logfile0,ib_logfile1 in /var/lib/mysql/,and restart mysqld. Now I could not connect to http://panel.mydomain.com.  The sub-directories such as sentora_core, sentora_postfix are still there.

When I visit Sentora panel, the following error occurs in /var/sentora/logs/sentora-error.log

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sentora_core.x_settings' doesn't exist' in /etc/sentora/panel/dryden/db/driver.class.php:176\nStack trace:\n /etc/sentora/panel/dryden/db/driver.class.php(176): PDOStatement->execute()\nForum Add-ons and Usage /etc/sentora/panel/dryden/ctrl/options.class.php(29): db_driver->bindQuery('SELECT so_value...', Array)\nMySupport Addon /etc/sentora/panel/index.php(20): ctrl_options::GetSystemOption('debug_mode')\nTest of MySupport MOD {main}\n  thrown in /etc/sentora/panel/dryden/db/driver.class.php on line 176

The error message says 'sentora_core.x_settings' doesn't exist, and there are indeed no x_settings.MYD and x_settings.MYI in directory sentor_core(but x_settings.frm exists). But this seems not the real cause because the .MYD and .MYI files do not exist on another working server, either.

Please help!


Thanks!

[Me.B]

That's the log file for mysql. Why did you mess up with those files?

You need to read and understand:

http://dba.stackexchange.com/questions/5...-ibd-files

M B

[peterfam]

That's the log file for mysql. Why did you mess up with those files?

You need to read and understand:

http://dba.stackexchange.com/questions/5...-ibd-files

M B

I deleted those files because one of the user databases occupies too much disk space, but I did not realize Sentora may store system data in its databases, and the system databases and user databases share the same ibdata1 file for innodb.

I do not know what databases sentora uses for its system data. Is there some command that can recover the databases to the initial status after sentora installation? I just want to login to the Sentora panel to recover all other stuff.

---

I just noticed the Sentora system databases:mysql,sentora_core,sentora_postfix,sentora_proftpd,sentora_roundcube are MyISAM databases. So the data were not in ibdata1 and not deleted by me. But why I cannot open the Sentora panel now?

When I visit Sentora panel, the following error occurs in /var/sentora/logs/sentora-error.log

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sentora_core.x_settings' doesn't exist' in /etc/sentora/panel/dryden/db/driver.class.php:176\nStack trace:\n /etc/sentora/panel/dryden/db/driver.class.php(176): PDOStatement->execute()\nForum Add-ons and Usage /etc/sentora/panel/dryden/ctrl/options.class.php(29): db_driver->bindQuery('SELECT so_value...', Array)\nMySupport Addon /etc/sentora/panel/index.php(20): ctrl_options::GetSystemOption('debug_mode')\nTest of MySupport MOD {main}\n  thrown in /etc/sentora/panel/dryden/db/driver.class.php on line 176


In the directory sentora_core, I only see x_settings.frm, but no x_settings.MYD and x_settings.MYI as other tables.