Restoring an encrypted backup - ADODB_Exception
Permalink
Hi, we are trying to restore a Database backup. We have a .sql.zip file, that I unzipped and placed in the /files/backups directory. When we choose it for restoration the following error occurs:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [2006: MySQL server has gone away] in EXECUTE("SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()") ' in /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 2006, 'MySQL server ha...', 'SELECT TABLE_NA...', false, Object(ADODB_mysqlt)) #1 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('SELECT TABLE_NA...', false) #2 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(2334): ADOConnection->Execute('SELECT TABLE_NA...') #3 /var/www/cc5/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(150): ADOConnection->MetaTables(false, false) #4 /var/www/cc5/concrete/startup/exceptions.php(7): ADODB_mysql->MetaTables() #5 [internal function]: Concrete5_Exception_Handler(Object(ADO in /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any ideas as to what might be causing this error message? What is the correct way to restore a backup that has .zip extension?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [2006: MySQL server has gone away] in EXECUTE("SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()") ' in /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 2006, 'MySQL server ha...', 'SELECT TABLE_NA...', false, Object(ADODB_mysqlt)) #1 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('SELECT TABLE_NA...', false) #2 /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb.inc.php(2334): ADOConnection->Execute('SELECT TABLE_NA...') #3 /var/www/cc5/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(150): ADOConnection->MetaTables(false, false) #4 /var/www/cc5/concrete/startup/exceptions.php(7): ADODB_mysql->MetaTables() #5 [internal function]: Concrete5_Exception_Handler(Object(ADO in /var/www/cc5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any ideas as to what might be causing this error message? What is the correct way to restore a backup that has .zip extension?
If your backup was unencrypted, you could get round it by slicing the .sql file and importing piecemeal through phpMyAdmin.
With the encryption key, you may be able to get a zip program to unzip the encrypted file offline and extract the .sql file inside it. Its not something I have ever tried to do.