UpdraftPlus fails to restore database in remote

Hi,

Can you describe some of the symptoms of the problem you’re having? Was there a log file, or any error messages?

Best wishes,
David

Hi David,

after running the restore I get the following message:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [no address given] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

I’ve contacted my provider and he says that server log file is not available for security reason, but only php_error.log. Can it be useful to understand the problem?

I’ve contacted my provider and he says that server log file is not available for security reason, but only php_error.log. Can it be useful to understand the problem?

Yes, potentially.

Also, please post the restoration log that’s in the folder wp-content/updraft.

David

Ok, it should be this:

0000.010 () Opened log file at time: Tue, 25 Aug 2015 19:17:19 +0000 on http:
0000.010 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.11.5 WP: 4.3 PHP: 5.4.4-14+deb7u2 (Linux opus43 3.12.25-opus #1 SMP Thu Jul 31 13:37:45 CEST 2014 x86_64) MySQL: 5.5.34 Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 30.9M | 34.3M) multisite: N mcrypt: Y LANG: ZipArchive::addFile: Y
0000.029 () Free space on disk containing Updraft’s temporary directory: 2075403.9 Mb
0000.029 () Restore job started. Entities to restore: plugins, themes, uploads, others, db
0000.075 () Will not delete any archives after unpacking them, because there was no cloud storage for this backup
0000.075 () Entity: db
0000.075 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-db.gz, type=db, info=a:0:{}, last_one=)
0000.075 () Unpacking backup…
0000.178 () Database successfully unpacked
0000.179 () Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
0000.191 () Using direct MySQL access; value of use_mysqli is: 0
0000.196 () Tried to raise max_allowed_packet from 16 Mb to 32 Mb, but failed (Access denied; you need (at least one of) the SUPER privilege(s) for this operation, b:0;)
0000.196 () Max packet size: 16 Mb
0000.196 () Entering maintenance mode
0000.196 () Enabling Maintenance mode…
0000.200 () Backup created by: 1.10.3
0000.201 () Backup of: ………..
0000.202 () Content URL: …………./wp-content
0000.203 () Old table prefix: …._
0000.203 () Site information: multisite=0
0000.210 () New table prefix: …._
0000.322 () Restoring table (InnoDB): _options
0003.639 () Restoring prior UD configuration (table: _options; keys: 2)
0003.803 () Restoring table (InnoDB): _users
0006.416 () Restoring table (InnoDB): _usermeta
0010.253 () Database queries processed: 50 in 10.06 seconds
0021.290 () Database queries processed: 100 in 21.09 seconds
0032.783 () Database queries processed: 150 in 32.59 seconds
0043.453 () Database queries processed: 200 in 43.26 seconds
0051.776 () Restoring table (InnoDB): _commentmeta
0051.820 () Restoring table (InnoDB): _comments
0051.905 () Restoring table (InnoDB): _links
0051.955 () Restoring table (InnoDB): _postmeta
0053.533 () Database queries processed: 250 in 53.34 seconds
0059.901 () Restoring table (InnoDB): _posts
0062.324 () Restoring table (InnoDB): _term_relationships
0062.554 () Restoring table (InnoDB): _term_taxonomy
0062.658 () Restoring table (InnoDB): _terms
0062.769 () Restoring table (InnoDB): _woocommerce_order_itemmeta
0062.808 () Restoring table (InnoDB): _woocommerce_termmeta
0062.896 () Restoring table (InnoDB): _eg_attachments_clicks
0062.924 () Restoring table (InnoDB): _mycred_log
0062.981 () Restoring table (InnoDB): _pmpro_discount_codes
0063.011 () Restoring table (InnoDB): _pmpro_discount_codes_levels
0063.036 () Restoring table (InnoDB): _pmpro_discount_codes_uses
0063.067 () Restoring table (InnoDB): _pmpro_membership_levels
0063.106 () Restoring table (InnoDB): _pmpro_membership_orders
0063.162 () Restoring table (InnoDB): _pmpro_memberships_categories
0063.188 () Restoring table (InnoDB): _pmpro_memberships_pages
0063.223 () Restoring table (InnoDB): _pmpro_memberships_users
0063.264 () Restoring table (MyISAM): _woocommerce_api_keys
0063.291 () Restoring table (InnoDB): _woocommerce_attribute_taxonomies
0063.327 () Restoring table (InnoDB): _woocommerce_downloadable_product_permissions
0063.363 () Restoring table (InnoDB): _woocommerce_order_items
0063.391 () Restoring table (InnoDB): _woocommerce_tax_rate_locations
0063.447 () Restoring table (InnoDB): _woocommerce_tax_rates
0063.485 () Restoring table (MyISAM): _wpuf_transaction
0063.507 () Leaving maintenance mode
0063.508 () Disabling Maintenance mode…
0063.508 () Finished: lines processed: 346 in 63.32 seconds
0063.509 () Cleaning up rubbish…
0063.548 () Entity: plugins
0063.549 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-plugins.zip, type=plugins, info=a:2:{s:4:”path”;s:37:”/htdocs/public/www/wp-content/plugins”;s:11:”description”;s:7:”Plugins”;}, last_one=)
0063.549 () Unpacking backup… (backup_2015-08-20-1614_NameSite_929ee197fd58-plugins.zip, 19.3 Mb)
0089.327 () Moving old data: filesystem method / updraft_dir is potentially possible
0089.329 () Moving old data: can potentially use wp_filesystem method / -old
0089.329 () Moving old data out of the way…
0091.396 () Top-level entities being moved: advanced-ads, akismet, black-studio-tinymce-widget, collapsing-categories, cookie-notice, eg-attachments, login-logout, meks-smart-author-widget, siteorigin-panels, minimal-coming-soon-maintenance-mode, ml-slider, mycred, paid-memberships-pro, pinterest-pin-it-button-on-image-hover-and-post, recent-posts-widget-extended, regenerate-thumbnails, so-widgets-bundle, tablepress, socialbuttons110, woocommerce, updraftplus, woocommerce-product-image-watermark, woosidebars, wordpress-seo, wp-user-frontend-pro, zf-wrodpress-category-accordion, index.php, insert-headers-and-footers, wp-vanilla-connect, simple-301-redirects, stop-spam-comments, wpuf-mailchimp, wp-meta-data-filter-and-taxonomy-filter, woocommerce-direct-free-download (Install)
0091.467 () Moving unpacked backup into place…
0092.830 () Top-level entities being moved: advanced-ads, akismet, black-studio-tinymce-widget, collapsing-categories, cookie-notice, eg-attachments, insert-headers-and-footers, login-logout, meks-smart-author-widget, meta-data-filter, minimal-coming-soon-maintenance-mode, ml-slider, mycred, paid-memberships-pro, pinterest-pin-it-button-on-image-hover-and-post, recent-posts-widget-extended, regenerate-thumbnails, simple-301-redirects, siteorigin-panels, so-widgets-bundle, socialbuttons110, stop-spam-comments, tablepress, updraftplus, vanilla-forums, woocommerce, woocommerce-direct-free-download, woocommerce-product-image-watermark, woosidebars, wordpress-seo, wp-user-frontend-pro, wp-vanilla-connect, wpuf-mailchimp, zf-wrodpress-category-accordion, index.php
0092.894 () Cleaning up rubbish…
0092.894 () Entity: themes
0092.894 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-themes.zip, type=themes, info=a:2:{s:4:”path”;s:36:”/htdocs/public/www/wp-content/themes”;s:11:”description”;s:6:”Themes”;}, last_one=)
0092.895 () Unpacking backup… (backup_2015-08-20-1614_NameSite_929ee197fd58-themes.zip, 3.1 Mb)
0095.160 () Moving old data: filesystem method / updraft_dir is potentially possible
0095.161 () Moving old data: can potentially use wp_filesystem method / -old
0095.161 () Moving old data out of the way…
0095.378 () Top-level entities being moved: twentyfifteen, twentyfourteen, twentythirteen, index.php
0095.387 () Moving unpacked backup into place…
0095.521 () Top-level entities being moved: twentyfifteen, twentyfourteen, twentythirteen, index.php
0095.531 () Cleaning up rubbish…
0095.532 () Entity: uploads
0095.532 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-uploads.zip, type=uploads, info=a:2:{s:4:”path”;s:37:”/htdocs/public/www/wp-content/uploads”;s:11:”description”;s:7:”Uploads”;}, last_one=)
0095.532 () Unpacking backup… (backup_2015-08-20-1614_NameSite_929ee197fd58-uploads.zip, 499.7 Mb)
0140.229 () Moving old data: filesystem method / updraft_dir is potentially possible
0140.231 () Moving old data: can potentially use wp_filesystem method / -old
0140.231 () Moving old data out of the way…
0145.960 () Moving unpacked backup into place…
0147.889 () Cleaning up rubbish…
0147.890 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-uploads2.zip, type=uploads, info=a:2:{s:4:”path”;s:37:”/htdocs/public/www/wp-content/uploads”;s:11:”description”;s:7:”Uploads”;}, last_one=)
0147.890 () Unpacking backup… (backup_2015-08-20-1614_NameSite_929ee197fd58-uploads2.zip, 498.3 Mb)
0194.993 () Moving unpacked backup into place…
0206.861 () Cleaning up rubbish…
0206.863 () restore_backup(backup_file=backup_2015-08-20-1614_NameSite_929ee197fd58-uploads3.zip, type=uploads, info=a:2:{s:4:”path”;s:37:”/htdocs/public/www/wp-content/uploads”;s:11:”description”;s:7:”Uploads”;}, last_one=)
0206.863 () Unpacking backup… (backup_2015-08-20-1614_NameSite_929ee197fd58-uploads3.zip, 429.2 Mb)

Hi,

It looks like your webserver kills off the restore whilst unzipping the uploads – which is large, so it seems to hit a time limit and the webserver kills it off.

To overcome this, try a new restore of *only* the uploads. This will allow all the time to be given to just that, which should improve the chances of success. (And since the other components are already restored, only these now need restoring).

David

At the moment I ‘ve restored manually the site.
For a next time, do you suggest me to restore in two steps,
before only the uploads, and then the other components, right?

thank you.

Hi,

Yes – though, with the uploads, the order doesn’t matter, whether you do them before or after other parts, as all UD is doing with those is unzipping the zip into wp-content/uploads.

David