+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: database file deleted, cannot open Sentora panel,please help (/showthread.php?tid=3572)
database file deleted, cannot open Sentora panel,please help - peterfam - 02-19-2017
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!
RE: database deleted, how to recover?urgent,wait online! - Me.B - 02-19-2017
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/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files
M B
RE: database deleted, how to recover?urgent,wait online! - peterfam - 02-19-2017
(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/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-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#0 /etc/sentora/panel/dryden/db/driver.class.php(176): PDOStatement->execute()\n#1 /etc/sentora/panel/dryden/ctrl/options.class.php(29): db_driver->bindQuery('SELECT so_value...', Array)\n#2 /etc/sentora/panel/index.php(20): ctrl_options::GetSystemOption('debug_mode')\n#3 {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.