#Administration
Summary
Dropped Aegir database, failed restoration
Steps to reproduce
Miscommunication caused dropping key database, we tried restoring it from mysql binlog and didn’t work quite right.
Expected behavior
We expected that this would help is restore it, but it didn’t work. Problem is that the server is in testing stage so mistakes were made, thus no backups were made. We need a solution that will solve current problem and restore Aegir to its glory.
Observed behavior
Here is error we are currently getting on aegir:
PDOException: SQLSTATE[HY000] [1049] Unknown database ‘civingbalkanscat’ in lock_may_be_available() (line 167 of /var/aegir/hostmaster-7.x-3.11/includes/lock.inc).
When we add mysql binlog, this is the error we are getting from the drupal website:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘civingbalkanscat.semaphore’ doesn’t exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /var/aegir/hostmaster-7.x-3.11/includes/lock.inc).
List of tables in database we need:
SYS_COLUMNS
SYS_FIELDS
SYS_INDEXES
SYS_TABLES
semaphore
Anything needed can be provided, just let me know
TIA