RE: database deleted, how to recover?urgent,wait online!
02-19-2017, 07:22 PM
(This post was last modified: 02-19-2017, 08:03 PM by peterfam.)
(02-19-2017, 07:12 PM)Me.B Wrote: 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.