Database Restore fails with "Invalid File Specified"
Permalink
Running 5.6.2.1. I ran a backup earlier today and then I got into some trouble so I figured I'd restore my backup. When I submitted the restore job my browser window went white and never returned. After waiting a bit I issues a refresh, that's when I received "Invalid file Specified." I checked my log file and there's some curious stuff in there, looks like the job is failing right away although it does produce a *.sql dump file. Anyone see this before? I checked around and I didn't see anything.
Here's what my logs say: I test ran 4 jobs. I'll post my environment info at the bottom:
[code]
10:58:35 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:48:36 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:44:38 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:30:43 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
##################################
Environment
##############################
# concrete5 Version
5.6.2.1
# concrete5 Packages
Amiant CSS3 Menu (0.3), Amiant Image Gallery (0.7.3), Background Image (1.0), Black Accents (2.0), Global Areas (1.0), Image Caption (1.5.1), Login (1.1.1), Pictures Gallery (1.1.2), Power Slider Lite (1.1.1), Sortable Fancybox Gallery (1.17), Transparent Email Obfuscation (1.0.3).
# concrete5 Overrides
themes/greek_yogurt_custom, themes/ARS_black_accents, themes/basic_bootstrap
# Server Software
Apache
# Server API
cgi-fcgi
# PHP Version
5.4.22
# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, odbc, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, recode, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Guard Loader, zip, zlib.
# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 10M
sql.safe_mode - Off
upload_max_filesize - 10M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
Here's what my logs say: I test ran 4 jobs. I'll post my environment info at the bottom:
[code]
10:58:35 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:48:36 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:44:38 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
10:30:43 PM exceptions admin Exception Occurred: /home2/arssouth/public_html/concrete/core/controllers/single_pages/dashboard/system/backup_restore/backup.php:99 Invalid backup file specified. (0)
#0 [internal function]: Concrete5_Controller_Dashboard_System_BackupRestore_Backup->restore_backup()
#1 /home2/arssouth/public_html/concrete/core/libraries/controller.php(264): call_user_func_array(Array, Array)
#2 /home2/arssouth/public_html/concrete/core/libraries/controller.php(234): Concrete5_Library_Controller->runTask('restore_backup', Array)
#3 /home2/arssouth/public_html/concrete/core/libraries/view.php(783): Concrete5_Library_Controller->setupAndRun()
#4 /home2/arssouth/public_html/concrete/dispatcher.php(264): Concrete5_Library_View->render(Object(Page))
#5 /home2/arssouth/public_html/index.php(2): require('/home2/arssouth...')
#6 {main}
##################################
Environment
##############################
# concrete5 Version
5.6.2.1
# concrete5 Packages
Amiant CSS3 Menu (0.3), Amiant Image Gallery (0.7.3), Background Image (1.0), Black Accents (2.0), Global Areas (1.0), Image Caption (1.5.1), Login (1.1.1), Pictures Gallery (1.1.2), Power Slider Lite (1.1.1), Sortable Fancybox Gallery (1.17), Transparent Email Obfuscation (1.0.3).
# concrete5 Overrides
themes/greek_yogurt_custom, themes/ARS_black_accents, themes/basic_bootstrap
# Server Software
Apache
# Server API
cgi-fcgi
# PHP Version
5.4.22
# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, odbc, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, recode, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Guard Loader, zip, zlib.
# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 10M
sql.safe_mode - Off
upload_max_filesize - 10M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
Early in my c5 experience, I found the Dashboard's Backup/Restore functions to be 'unforgiving' so I no longer use them. I think the server time-out limits are a problem on busy, shared servers and sometimes c5 doesn't die very gracefully when something goes wrong. As weyboat mentioned, I only use phpMyAdmin to 'Export' and 'Import' my databases. I haven't used the Dashboard functions lately so I was hoping that these problems might have gone away but since you're still having issues with it, my concerns remain.
The dashboard restore usually fails on timeout before the dashboard backup runs out of time.
phpMyAdmin run from a web page is usually subject to the same timeouts, but without the overhead of concrete5.
If the restore is too big for phpMyAdmin, you can usually slice a database .sql file up into smaller pieces with a text editor and import them in sequence.
My Backup Voodoo addon can be configured to create a sql backup already sliced for you according to a file size trip.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
phpMyAdmin run from a web page is usually subject to the same timeouts, but without the overhead of concrete5.
If the restore is too big for phpMyAdmin, you can usually slice a database .sql file up into smaller pieces with a text editor and import them in sequence.
My Backup Voodoo addon can be configured to create a sql backup already sliced for you according to a file size trip.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
Mhawk, thanks for the reply and your recommendation. I'll move to
phpmyadmin.
-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Saturday, January 04, 2014 8:30 AM
To: david@ballsmachine.com
Subject: Database Restore fails with "Invalid File Specified" : Building
with concrete5
phpmyadmin.
-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Saturday, January 04, 2014 8:30 AM
To: david@ballsmachine.com
Subject: Database Restore fails with "Invalid File Specified" : Building
with concrete5
Great advice! I'm cool with that, that's how I'll do it. Thanks Weyboat!
-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Saturday, January 04, 2014 4:22 AM
To: david@ballsmachine.com
Subject: Database Restore fails with "Invalid File Specified" : Building
with concrete5
-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Saturday, January 04, 2014 4:22 AM
To: david@ballsmachine.com
Subject: Database Restore fails with "Invalid File Specified" : Building
with concrete5
To do this I visit Dashboard/System & Settings/Backup Database and "Download" the backup file to my PC
Then I log into my servers control panel and from phpMyAdmin I "Drop" the database, once the database is dropped I import the "Downloaded" backup file,
To be on the safe side I would recommend running the "Export" command on phpMyAdmin to make a backup of the database before you drop it.