- This topic has 4 replies, 2 voices, and was last updated 7 years, 7 months ago by Dee Nutbourne.
-
Posts
-
Hello,
I had a problem while restoring my website’ complete backup to another site. Error happens in restoring one of the table in database. See at the end of the log file.
Log below :
0000.009 () Opened log file at time: Wed, 03 May 2017 19:16:08 +0000 on https://52.32.70.81
0000.009 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 2.12.32.22 WP: 4.7.4 PHP: 5.6.30 (apache2handler, Linux ip-172-31-18-38 4.9.17-8.31.amzn1.x86_64 #1 SMP Sat Apr 1 01:22:16 UTC 2017 x86_64) MySQL: 5.5.54 WPLANG: en_US Server: Apache/2.4.25 (Amazon) PHP/5.6.30 safe_mode: 0 max_execution_time: 900 memory_limit: 2028M (used: 27.2M | 27.5M) multisite: N openssl: OpenSSL 1.0.1k-fips 8 Jan 2015 mcrypt: Y LANG: C ZipArchive::addFile: Y
0000.009 () Free space on disk containing Updraft’s temporary directory: 17055.6 MB
0000.013 () Restore job started. Entities to restore: plugins, themes, uploads, wpcore, others, db. Restore options: {“updraft_restorer_replacesiteurl”:true,”updraft_encryptionphrase”:””,”updraft_restorer_wpcore_includewpconfig”:true}
0000.055 () Entity: db
0000.055 () restore_backup(backup_file=backup_2017-04-27-0200_Danby_02f42a55f8b1-db.gz, type=db, info=a:0:{}, last_one=)
0000.055 () Unpacking backup… (backup_2017-04-27-0200_Danby_02f42a55f8b1-db.gz, 239.6 Mb)
0001.875 () Database successfully unpacked
0001.878 () 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)…
0001.878 () Using direct MySQL access; value of use_mysqli is: 1
0001.886 () Max packet size: 1024 MB
0001.886 () Entering maintenance mode
0001.886 () Enabling Maintenance mode…
0001.887 () Backup of: https://www.danby.com
0001.920 () Content URL: https://www.danby.com/wp-content
0001.921 () Uploads URL: https://www.danby.com/wp-content/uploads
0001.921 () Old table prefix: wp_
0001.921 () Site information: multisite=0
0001.926 () New table prefix: wp_
0001.932 () Processing table (InnoDB): wp_options
0002.016 () Processing table (InnoDB): wp_options
0006.333 () Database queries processed: 50 in 4.45 seconds
0010.036 () Restoring prior UD configuration (table: wp_options; keys: 97)
0010.631 () Search and replacing table: wp_options: rows: 52126
0011.636 () Searching and replacing reached row: 5000
0012.176 () Searching and replacing reached row: 10000
0012.803 () Searching and replacing reached row: 15000
0013.375 () Searching and replacing reached row: 20000
0013.947 () Searching and replacing reached row: 25000
0014.550 () Searching and replacing reached row: 30000
0015.127 () Searching and replacing reached row: 35000
0015.713 () Searching and replacing reached row: 40000
0016.416 () Searching and replacing reached row: 45000
0017.080 () Searching and replacing reached row: 50000
0017.352 () Processing table (InnoDB): wp_users
0017.375 () Search and replacing table: wp_users: rows: 42
0017.384 () Processing table (InnoDB): wp_usermeta
0017.572 () Search and replacing table: wp_usermeta: rows: 1156
0017.733 () Processing table (InnoDB): wp_commentmeta
0017.780 () Search and replacing table: wp_commentmeta: rows: 177
0017.921 () Processing table (InnoDB): wp_comments
0017.951 () Search and replacing table: wp_comments: rows: 52
0017.967 () Processing table (InnoDB): wp_links
0017.983 () Search and replacing table: wp_links: rows: 0
0017.983 () Processing table (InnoDB): wp_postmeta
0017.989 () Database queries processed: 100 in 16.11 seconds
0026.547 () Database queries processed: 150 in 24.67 seconds
0042.850 () Database queries processed: 200 in 40.97 seconds
0053.347 () Database queries processed: 250 in 51.47 seconds
0139.120 () Database queries processed: 500 in 137.24 seconds
0145.565 () Search and replacing table: wp_postmeta: rows: 9409
0152.290 () Searching and replacing reached row: 5000
0161.274 () Processing table (InnoDB): wp_posts
0176.507 () Skipping search/replace on GUID column in posts table
0176.564 () Search and replacing table: wp_posts: rows: 174639
0178.529 () Searching and replacing reached row: 5000
0180.531 () Searching and replacing reached row: 10000
0182.497 () Searching and replacing reached row: 15000
0184.474 () Searching and replacing reached row: 20000
0186.480 () Searching and replacing reached row: 25000
0188.440 () Searching and replacing reached row: 30000
0190.441 () Searching and replacing reached row: 35000
0192.501 () Searching and replacing reached row: 40000
0194.533 () Searching and replacing reached row: 45000
0196.561 () Searching and replacing reached row: 50000
0198.616 () Searching and replacing reached row: 55000
0200.685 () Searching and replacing reached row: 60000
0202.771 () Searching and replacing reached row: 65000
0204.864 () Searching and replacing reached row: 70000
0206.967 () Searching and replacing reached row: 75000
0209.053 () Searching and replacing reached row: 80000
0211.162 () Searching and replacing reached row: 85000
0213.294 () Searching and replacing reached row: 90000
0215.420 () Searching and replacing reached row: 95000
0217.558 () Searching and replacing reached row: 100000
0219.699 () Searching and replacing reached row: 105000
0221.845 () Searching and replacing reached row: 110000
0224.007 () Searching and replacing reached row: 115000
0226.179 () Searching and replacing reached row: 120000
0228.368 () Searching and replacing reached row: 125000
0230.595 () Searching and replacing reached row: 130000
0232.792 () Searching and replacing reached row: 135000
0235.092 () Searching and replacing reached row: 140000
0237.429 () Searching and replacing reached row: 145000
0239.700 () Searching and replacing reached row: 150000
0241.941 () Searching and replacing reached row: 155000
0244.258 () Searching and replacing reached row: 160000
0246.551 () Searching and replacing reached row: 165000
0249.228 () Searching and replacing reached row: 170000
0251.351 () Processing table (InnoDB): wp_term_relationships
0252.055 () Skipping this table: data in this table (wp_term_relationships) should not be search/replaced
0252.055 () Processing table (InnoDB): wp_term_taxonomy
0252.122 () Search and replacing table: wp_term_taxonomy: rows: 373
0252.172 () Processing table (InnoDB): wp_termmeta
0252.321 () Search and replacing table: wp_termmeta: rows: 916
0252.421 () Processing table (InnoDB): wp_terms
0252.480 () Search and replacing table: wp_terms: rows: 359
0252.524 () Processing table (InnoDB): beanstream_responses
0252.538 () Search and replacing table: beanstream_responses: rows: 0
0252.539 () Processing table (MyISAM): danby_warranties
0272.626 () Database queries processed: 750 in 270.75 seconds
0318.304 () Search and replacing table: danby_warranties: rows: 970927
0321.670 () Searching and replacing reached row: 5000
0325.026 () Searching and replacing reached row: 10000
0328.372 () Searching and replacing reached row: 15000
0331.745 () Searching and replacing reached row: 20000
0333.730 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0333.732 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0335.132 () Searching and replacing reached row: 25000
0336.793 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0338.518 () Searching and replacing reached row: 30000
0341.905 () Searching and replacing reached row: 35000
0343.772 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0345.341 () Searching and replacing reached row: 40000
0348.778 () Searching and replacing reached row: 45000
0352.223 () Searching and replacing reached row: 50000
0355.658 () Searching and replacing reached row: 55000
0359.105 () Searching and replacing reached row: 60000
0362.469 () Searching and replacing reached row: 65000
0365.821 () Searching and replacing reached row: 70000
0369.198 () Searching and replacing reached row: 75000
0372.640 () Searching and replacing reached row: 80000
0376.118 () Searching and replacing reached row: 85000
0379.560 () Searching and replacing reached row: 90000
0383.035 () Searching and replacing reached row: 95000
0384.461 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0386.513 () Searching and replacing reached row: 100000
0389.983 () Searching and replacing reached row: 105000
0393.467 () Searching and replacing reached row: 110000
0396.924 () Searching and replacing reached row: 115000
0400.407 () Searching and replacing reached row: 120000
0403.912 () Searching and replacing reached row: 125000
0407.403 () Searching and replacing reached row: 130000
0410.901 () Searching and replacing reached row: 135000
0414.438 () Searching and replacing reached row: 140000
0414.923 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0417.152 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0417.906 () Searching and replacing reached row: 145000
0421.394 () Searching and replacing reached row: 150000
0424.901 () Searching and replacing reached row: 155000
0427.974 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0428.450 () Searching and replacing reached row: 160000
0429.520 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0432.006 () Searching and replacing reached row: 165000
0435.540 () Searching and replacing reached row: 170000
0438.141 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0439.069 () Searching and replacing reached row: 175000
0442.657 () Searching and replacing reached row: 180000
0445.086 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0446.226 () Searching and replacing reached row: 185000
0447.223 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0449.778 () Searching and replacing reached row: 190000
0450.165 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0450.924 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0453.343 () Searching and replacing reached row: 195000
0453.868 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0456.914 () Searching and replacing reached row: 200000
0460.489 () Searching and replacing reached row: 205000
0464.079 () Searching and replacing reached row: 210000
0467.644 () Searching and replacing reached row: 215000
0471.148 () Searching and replacing reached row: 220000
0473.244 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0474.783 () Searching and replacing reached row: 225000
0478.396 () Searching and replacing reached row: 230000
0481.483 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0482.035 () Searching and replacing reached row: 235000
0485.494 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0485.643 () Searching and replacing reached row: 240000
0489.246 () Searching and replacing reached row: 245000
0492.877 () Searching and replacing reached row: 250000
0494.064 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0496.507 () Searching and replacing reached row: 255000
0499.729 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0500.139 () Searching and replacing reached row: 260000
0503.791 () Searching and replacing reached row: 265000
0507.395 () Searching and replacing reached row: 270000
0508.100 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0511.021 () Searching and replacing reached row: 275000
0514.616 () Searching and replacing reached row: 280000
0518.288 () Searching and replacing reached row: 285000
0521.979 () Searching and replacing reached row: 290000
0524.877 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0525.642 () Searching and replacing reached row: 295000
0529.295 () Searching and replacing reached row: 300000
0533.042 () Searching and replacing reached row: 305000
0536.771 () Searching and replacing reached row: 310000
0540.451 () Searching and replacing reached row: 315000
0544.148 () Searching and replacing reached row: 320000
0547.869 () Searching and replacing reached row: 325000
0551.607 () Searching and replacing reached row: 330000
0555.411 () Searching and replacing reached row: 335000
0559.169 () Searching and replacing reached row: 340000
0562.744 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0562.921 () Searching and replacing reached row: 345000
0566.704 () Searching and replacing reached row: 350000
0570.483 () Searching and replacing reached row: 355000
0574.291 () Searching and replacing reached row: 360000
0578.103 () Searching and replacing reached row: 365000
0581.870 () Searching and replacing reached row: 370000
0585.618 () Searching and replacing reached row: 375000
0589.378 () Searching and replacing reached row: 380000
0593.149 () Searching and replacing reached row: 385000
0595.578 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0596.924 () Searching and replacing reached row: 390000
0600.735 () Searching and replacing reached row: 395000
0604.556 () Searching and replacing reached row: 400000
0608.004 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0608.378 () Searching and replacing reached row: 405000
0612.211 () Searching and replacing reached row: 410000
0616.032 () Searching and replacing reached row: 415000
0619.861 () Searching and replacing reached row: 420000
0623.678 () Searching and replacing reached row: 425000
0627.499 () Searching and replacing reached row: 430000
0631.317 () Searching and replacing reached row: 435000
0635.191 () Searching and replacing reached row: 440000
0635.699 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0639.081 () Searching and replacing reached row: 445000
0642.976 () Searching and replacing reached row: 450000
0646.845 () Searching and replacing reached row: 455000
0650.754 () Searching and replacing reached row: 460000
0654.696 () Searching and replacing reached row: 465000
0656.318 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0658.581 () Searching and replacing reached row: 470000
0662.479 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0662.498 () Searching and replacing reached row: 475000
0666.373 () Searching and replacing reached row: 480000
0670.262 () Searching and replacing reached row: 485000
0674.186 () Searching and replacing reached row: 490000
0678.075 () Searching and replacing reached row: 495000
0681.972 () Searching and replacing reached row: 500000
0685.462 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0685.842 () Searching and replacing reached row: 505000
0689.738 () Searching and replacing reached row: 510000
0693.612 () Searching and replacing reached row: 515000
0697.478 () Searching and replacing reached row: 520000
0701.435 () Searching and replacing reached row: 525000
0705.333 () Searching and replacing reached row: 530000
0709.190 () Searching and replacing reached row: 535000
0713.112 () Searching and replacing reached row: 540000
0717.015 () Searching and replacing reached row: 545000
0720.961 () Searching and replacing reached row: 550000
0724.888 () Searching and replacing reached row: 555000
0728.819 () Searching and replacing reached row: 560000
0732.706 () Searching and replacing reached row: 565000
0736.667 () Searching and replacing reached row: 570000
0740.605 () Searching and replacing reached row: 575000
0744.534 () Searching and replacing reached row: 580000
0748.280 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0748.480 () Searching and replacing reached row: 585000
0752.442 () Searching and replacing reached row: 590000
0756.344 () Searching and replacing reached row: 595000
0760.261 () Searching and replacing reached row: 600000
0764.201 () Searching and replacing reached row: 605000
0765.380 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0768.236 () Searching and replacing reached row: 610000
0772.269 () Searching and replacing reached row: 615000
0776.278 () Searching and replacing reached row: 620000
0780.315 () Searching and replacing reached row: 625000
0784.359 () Searching and replacing reached row: 630000
0787.132 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0788.427 () Searching and replacing reached row: 635000
0792.423 () Searching and replacing reached row: 640000
0795.552 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0796.483 () Searching and replacing reached row: 645000
0800.554 () Searching and replacing reached row: 650000
0804.643 () Searching and replacing reached row: 655000
0808.731 () Searching and replacing reached row: 660000
0810.799 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0812.810 () Searching and replacing reached row: 665000
0816.874 () Searching and replacing reached row: 670000
0820.897 () Searching and replacing reached row: 675000
0821.825 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0824.959 () Searching and replacing reached row: 680000
0829.045 () Searching and replacing reached row: 685000
0832.167 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0833.146 () Searching and replacing reached row: 690000
0837.287 () Searching and replacing reached row: 695000
0841.382 () Searching and replacing reached row: 700000
0845.488 () Searching and replacing reached row: 705000
0849.600 () Searching and replacing reached row: 710000
0853.726 () Searching and replacing reached row: 715000
0857.875 () Searching and replacing reached row: 720000
0860.247 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0862.008 () Searching and replacing reached row: 725000
0865.520 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0866.123 () Searching and replacing reached row: 730000
0870.241 () Searching and replacing reached row: 735000
0874.399 () Searching and replacing reached row: 740000
0878.515 () Searching and replacing reached row: 745000
0882.673 () Searching and replacing reached row: 750000
0883.533 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0886.859 () Searching and replacing reached row: 755000
0891.033 () Searching and replacing reached row: 760000
0894.502 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0895.261 () Searching and replacing reached row: 765000
0899.458 () Searching and replacing reached row: 770000
0902.011 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0903.353 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0903.453 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0903.653 () Searching and replacing reached row: 775000
0907.846 () Searching and replacing reached row: 780000
0912.044 () Searching and replacing reached row: 785000
0914.368 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0916.260 () Searching and replacing reached row: 790000
0920.483 () Searching and replacing reached row: 795000
0922.343 () PHP event: code E_NOTICE: json_decode(): integer overflow detected (line 1418, wp-content/plugins/updraftplus/addons/migrator.php)
0924.698 () Searching and replacing reached row: 800000
0928.907 () Searching and replacing reached row: 805000
0933.208 () Searching and replacing reached row: 810000
0937.462 () Searching and replacing reached row: 815000
0941.655 () Searching and replacing reached row: 820000
0945.865 () Searching and replacing reached row: 825000
0950.102 () Searching and replacing reached row: 830000
0954.416 () Searching and replacing reached row: 835000
0958.677 () Searching and replacing reached row: 840000
0962.912 () Searching and replacing reached row: 845000
0967.173 () Searching and replacing reached row: 850000
0971.434 () Searching and replacing reached row: 855000
0975.707 () Searching and replacing reached row: 860000
0979.969 () Searching and replacing reached row: 865000
0984.230 () Searching and replacing reached row: 870000
0988.498 () Searching and replacing reached row: 875000
0992.776 () Searching and replacing reached row: 880000
0997.081 () Searching and replacing reached row: 885000
1001.387 () Searching and replacing reached row: 890000
1005.709 () Searching and replacing reached row: 895000
1010.029 () Searching and replacing reached row: 900000
1014.359 () Searching and replacing reached row: 905000
1018.665 () Searching and replacing reached row: 910000
1022.997 () Searching and replacing reached row: 915000
1027.343 () Searching and replacing reached row: 920000
1031.685 () Searching and replacing reached row: 925000
1036.036 () Searching and replacing reached row: 930000
1040.396 () Searching and replacing reached row: 935000
1044.718 () Searching and replacing reached row: 940000
1049.069 () Searching and replacing reached row: 945000
1053.416 () Searching and replacing reached row: 950000
1057.767 () Searching and replacing reached row: 955000
1062.133 () Searching and replacing reached row: 960000
1066.511 () Searching and replacing reached row: 965000
1070.895 () Searching and replacing reached row: 970000
1072.521 () Processing table (MyISAM): dealers
1074.267 () Search and replacing table: dealers: rows: 6718
1076.623 () Searching and replacing reached row: 5000
1077.460 () Processing table (InnoDB): dhub_product_categories
1077.724 () Search and replacing table: dhub_product_categories: rows: 1752
1077.910 () Processing table (MyISAM): wp_icl_content_status
1077.921 () Search and replacing table: wp_icl_content_status: rows: 0
1077.921 () Processing table (MyISAM): wp_icl_core_status
1077.930 () Search and replacing table: wp_icl_core_status: rows: 0
1077.930 () Processing table (MyISAM): wp_icl_flags
1077.946 () Search and replacing table: wp_icl_flags: rows: 66
1077.953 () Processing table (MyISAM): wp_icl_languages
1077.969 () Search and replacing table: wp_icl_languages: rows: 65
1077.981 () Processing table (MyISAM): wp_icl_languages_translations
1078.548 () Skipping this table: data in this table (wp_icl_languages_translations) should not be search/replaced
1078.548 () Processing table (MyISAM): wp_icl_locale_map
1078.557 () Search and replacing table: wp_icl_locale_map: rows: 4
1078.558 () Processing table (MyISAM): wp_icl_message_status
1078.566 () Search and replacing table: wp_icl_message_status: rows: 0
1078.566 () Processing table (MyISAM): wp_icl_node
1078.574 () Search and replacing table: wp_icl_node: rows: 0
1078.574 () Processing table (MyISAM): wp_icl_reminders
1078.582 () Search and replacing table: wp_icl_reminders: rows: 0
1078.582 () Processing table (MyISAM): wp_icl_string_packages
1078.592 () Search and replacing table: wp_icl_string_packages: rows: 8
1078.594 () Processing table (InnoDB): wp_icl_string_pages
1079.036 () Search and replacing table: wp_icl_string_pages: rows: 44663
1079.463 () Searching and replacing reached row: 5000
1079.887 () Searching and replacing reached row: 10000
1080.313 () Searching and replacing reached row: 15000
1080.739 () Searching and replacing reached row: 20000
1081.172 () Searching and replacing reached row: 25000
1081.600 () Searching and replacing reached row: 30000
1082.032 () Searching and replacing reached row: 35000
1082.467 () Searching and replacing reached row: 40000
1082.873 () Processing table (MyISAM): wp_icl_string_positions
1082.957 () Skipping this table: data in this table (wp_icl_string_positions) should not be search/replaced
1082.957 () Processing table (MyISAM): wp_icl_string_status
1082.966 () Search and replacing table: wp_icl_string_status: rows: 0
1082.966 () Processing table (MyISAM): wp_icl_string_translations
1083.091 () Skipping this table: data in this table (wp_icl_string_translations) should not be search/replaced
1083.091 () Processing table (InnoDB): wp_icl_string_urls
1083.242 () Search and replacing table: wp_icl_string_urls: rows: 835
1083.310 () Processing table (MyISAM): wp_icl_strings
1083.667 () Skipping this table: data in this table (wp_icl_strings) should not be search/replaced
1083.667 () Processing table (MyISAM): wp_icl_translate
1083.843 () Database queries processed: 1000 in 1081.96 seconds
1083.896 () Search and replacing table: wp_icl_translate: rows: 1320
1084.197 () Processing table (MyISAM): wp_icl_translate_job
1084.222 () Search and replacing table: wp_icl_translate_job: rows: 145
1084.240 () Processing table (MyISAM): wp_icl_translation_batches
1084.266 () Search and replacing table: wp_icl_translation_batches: rows: 51
1084.271 () Processing table (MyISAM): wp_icl_translation_status
1084.770 () Search and replacing table: wp_icl_translation_status: rows: 3172
1085.599 () Processing table (MyISAM): wp_icl_translations
1113.676 () Search and replacing table: wp_icl_translations: rows: 207624
1114.445 () Searching and replacing reached row: 5000
1115.220 () Searching and replacing reached row: 10000
1116.005 () Searching and replacing reached row: 15000
1116.783 () Searching and replacing reached row: 20000
1117.560 () Searching and replacing reached row: 25000
1118.325 () Searching and replacing reached row: 30000
1119.080 () Searching and replacing reached row: 35000
1119.840 () Searching and replacing reached row: 40000
1120.588 () Searching and replacing reached row: 45000
1121.346 () Searching and replacing reached row: 50000
1122.117 () Searching and replacing reached row: 55000
1122.887 () Searching and replacing reached row: 60000
1123.655 () Searching and replacing reached row: 65000
1124.415 () Searching and replacing reached row: 70000
1125.183 () Searching and replacing reached row: 75000
1125.953 () Searching and replacing reached row: 80000
1126.720 () Searching and replacing reached row: 85000
1127.488 () Searching and replacing reached row: 90000
1128.257 () Searching and replacing reached row: 95000
1129.029 () Searching and replacing reached row: 100000
1129.802 () Searching and replacing reached row: 105000
1130.575 () Searching and replacing reached row: 110000
1131.348 () Searching and replacing reached row: 115000
1132.127 () Searching and replacing reached row: 120000
1132.905 () Searching and replacing reached row: 125000
1133.720 () Searching and replacing reached row: 130000
1134.500 () Searching and replacing reached row: 135000
1135.284 () Searching and replacing reached row: 140000
1136.066 () Searching and replacing reached row: 145000
1136.852 () Searching and replacing reached row: 150000
1137.641 () Searching and replacing reached row: 155000
1138.428 () Searching and replacing reached row: 160000
1139.205 () Searching and replacing reached row: 165000
1139.988 () Searching and replacing reached row: 170000
1140.766 () Searching and replacing reached row: 175000
1141.546 () Searching and replacing reached row: 180000
1142.328 () Searching and replacing reached row: 185000
1143.117 () Searching and replacing reached row: 190000
1143.907 () Searching and replacing reached row: 195000
1144.703 () Searching and replacing reached row: 200000
1145.501 () Searching and replacing reached row: 205000
1145.938 () Processing table (MyISAM): wp_icl_translations_copy
1165.959 () Search and replacing table: wp_icl_translations_copy: rows: 151839
1166.721 () Searching and replacing reached row: 5000
1167.499 () Searching and replacing reached row: 10000
1168.277 () Searching and replacing reached row: 15000
1169.041 () Searching and replacing reached row: 20000
1169.821 () Searching and replacing reached row: 25000
1170.589 () Searching and replacing reached row: 30000
1171.354 () Searching and replacing reached row: 35000
1172.118 () Searching and replacing reached row: 40000
1172.874 () Searching and replacing reached row: 45000
1173.640 () Searching and replacing reached row: 50000
1174.406 () Searching and replacing reached row: 55000
1175.178 () Searching and replacing reached row: 60000
1175.952 () Searching and replacing reached row: 65000
1176.702 () Searching and replacing reached row: 70000
1177.458 () Searching and replacing reached row: 75000
1178.218 () Searching and replacing reached row: 80000
1178.977 () Searching and replacing reached row: 85000
1179.736 () Searching and replacing reached row: 90000
1180.498 () Searching and replacing reached row: 95000
1181.263 () Searching and replacing reached row: 100000
1182.030 () Searching and replacing reached row: 105000
1182.792 () Searching and replacing reached row: 110000
1183.558 () Searching and replacing reached row: 115000
1184.344 () Searching and replacing reached row: 120000
1185.133 () Searching and replacing reached row: 125000
1185.940 () Searching and replacing reached row: 130000
1186.728 () Searching and replacing reached row: 135000
1187.535 () Searching and replacing reached row: 140000
1188.320 () Searching and replacing reached row: 145000
1189.103 () Searching and replacing reached row: 150000
1189.407 () Processing table (MyISAM): wp_icl_translations_copy1
1210.182 () Search and replacing table: wp_icl_translations_copy1: rows: 162404
1210.933 () Searching and replacing reached row: 5000
1211.698 () Searching and replacing reached row: 10000
1212.468 () Searching and replacing reached row: 15000
1213.236 () Searching and replacing reached row: 20000
1214.003 () Searching and replacing reached row: 25000
1214.761 () Searching and replacing reached row: 30000
1215.514 () Searching and replacing reached row: 35000
1216.270 () Searching and replacing reached row: 40000
1217.011 () Searching and replacing reached row: 45000
1217.765 () Searching and replacing reached row: 50000
1218.523 () Searching and replacing reached row: 55000
1219.297 () Searching and replacing reached row: 60000
1220.067 () Searching and replacing reached row: 65000
1220.821 () Searching and replacing reached row: 70000
1221.581 () Searching and replacing reached row: 75000
1222.350 () Searching and replacing reached row: 80000
1223.115 () Searching and replacing reached row: 85000
1223.880 () Searching and replacing reached row: 90000
1224.641 () Searching and replacing reached row: 95000
1225.406 () Searching and replacing reached row: 100000
1226.188 () Searching and replacing reached row: 105000
1226.951 () Searching and replacing reached row: 110000
1227.719 () Searching and replacing reached row: 115000
1228.487 () Searching and replacing reached row: 120000
1229.253 () Searching and replacing reached row: 125000
1230.026 () Searching and replacing reached row: 130000
1230.794 () Searching and replacing reached row: 135000
1231.587 () Searching and replacing reached row: 140000
1232.357 () Searching and replacing reached row: 145000
1233.129 () Searching and replacing reached row: 150000
1233.904 () Searching and replacing reached row: 155000
1234.686 () Searching and replacing reached row: 160000
1235.079 () Processing table (InnoDB): wp_masterslider_options
1235.097 () Search and replacing table: wp_masterslider_options: rows: 6
1235.098 () Processing table (InnoDB): wp_masterslider_sliders
1235.117 () Search and replacing table: wp_masterslider_sliders: rows: 3
1235.118 () Processing table (InnoDB): wp_posts_before_acf
1275.120 () Database queries processed: 1250 in 1273.24 seconds
1275.808 () Search and replacing table: wp_posts_before_acf: rows: 448092
1278.086 () Searching and replacing reached row: 5000
1280.341 () Searching and replacing reached row: 10000
1282.610 () Searching and replacing reached row: 15000
1284.886 () Searching and replacing reached row: 20000
1287.138 () Searching and replacing reached row: 25000
1289.400 () Searching and replacing reached row: 30000
1291.637 () Searching and replacing reached row: 35000
1293.913 () Searching and replacing reached row: 40000
1296.194 () Searching and replacing reached row: 45000
1298.483 () Searching and replacing reached row: 50000
1300.787 () Searching and replacing reached row: 55000
1303.116 () Searching and replacing reached row: 60000
1305.450 () Searching and replacing reached row: 65000
1307.784 () Searching and replacing reached row: 70000
1310.130 () Searching and replacing reached row: 75000
1312.523 () Searching and replacing reached row: 80000
1314.919 () Searching and replacing reached row: 85000
1317.306 () Searching and replacing reached row: 90000
1319.700 () Searching and replacing reached row: 95000
1322.097 () Searching and replacing reached row: 100000
1324.501 () Searching and replacing reached row: 105000
1326.906 () Searching and replacing reached row: 110000
1329.316 () Searching and replacing reached row: 115000
1331.712 () Searching and replacing reached row: 120000
1334.106 () Searching and replacing reached row: 125000
1336.492 () Searching and replacing reached row: 130000
1338.887 () Searching and replacing reached row: 135000
1341.302 () Searching and replacing reached row: 140000
1343.749 () Searching and replacing reached row: 145000
1346.199 () Searching and replacing reached row: 150000
1348.652 () Searching and replacing reached row: 155000
1351.092 () Searching and replacing reached row: 160000
1353.529 () Searching and replacing reached row: 165000
1355.999 () Searching and replacing reached row: 170000
1358.469 () Searching and replacing reached row: 175000
1360.958 () Searching and replacing reached row: 180000
1363.458 () Searching and replacing reached row: 185000
1365.954 () Searching and replacing reached row: 190000
1368.522 () Searching and replacing reached row: 195000
1371.058 () Searching and replacing reached row: 200000
1373.662 () Searching and replacing reached row: 205000
1376.202 () Searching and replacing reached row: 210000
1378.731 () Searching and replacing reached row: 215000
1381.279 () Searching and replacing reached row: 220000
1383.825 () Searching and replacing reached row: 225000
1386.373 () Searching and replacing reached row: 230000
1388.940 () Searching and replacing reached row: 235000
1391.524 () Searching and replacing reached row: 240000
1394.124 () Searching and replacing reached row: 245000
1396.826 () Searching and replacing reached row: 250000
1399.572 () Searching and replacing reached row: 255000
1402.210 () Searching and replacing reached row: 260000
1404.836 () Searching and replacing reached row: 265000
1407.463 () Searching and replacing reached row: 270000
1410.119 () Searching and replacing reached row: 275000
1412.778 () Searching and replacing reached row: 280000
1415.434 () Searching and replacing reached row: 285000
1418.098 () Searching and replacing reached row: 290000
1420.765 () Searching and replacing reached row: 295000
1423.472 () Searching and replacing reached row: 300000
1426.145 () Searching and replacing reached row: 305000
1428.868 () Searching and replacing reached row: 310000
1431.573 () Searching and replacing reached row: 315000
1434.350 () Searching and replacing reached row: 320000
1437.050 () Searching and replacing reached row: 325000
1439.769 () Searching and replacing reached row: 330000
1442.528 () Searching and replacing reached row: 335000
1445.235 () Searching and replacing reached row: 340000
1448.014 () Searching and replacing reached row: 345000
1450.790 () Searching and replacing reached row: 350000
1453.755 () Searching and replacing reached row: 355000
1457.272 () Searching and replacing reached row: 360000
1460.157 () Searching and replacing reached row: 365000
1463.056 () Searching and replacing reached row: 370000
1465.955 () Searching and replacing reached row: 375000
1469.528 () Searching and replacing reached row: 380000
1472.390 () Searching and replacing reached row: 385000
1475.258 () Searching and replacing reached row: 390000
1478.162 () Searching and replacing reached row: 395000
1481.044 () Searching and replacing reached row: 400000
1483.957 () Searching and replacing reached row: 405000
1486.845 () Searching and replacing reached row: 410000
1489.704 () Searching and replacing reached row: 415000
1492.601 () Searching and replacing reached row: 420000
1495.494 () Searching and replacing reached row: 425000
1498.366 () Searching and replacing reached row: 430000
1501.256 () Searching and replacing reached row: 435000
1504.198 () Searching and replacing reached row: 440000
1507.107 () Searching and replacing reached row: 445000
1509.263 () Processing table (InnoDB): wp_posts_copy
1542.197 () Search and replacing table: wp_posts_copy: rows: 376798
1544.405 () Searching and replacing reached row: 5000
1546.647 () Searching and replacing reached row: 10000
1548.867 () Searching and replacing reached row: 15000
1551.139 () Searching and replacing reached row: 20000
1553.394 () Searching and replacing reached row: 25000
1555.617 () Searching and replacing reached row: 30000
1557.835 () Searching and replacing reached row: 35000
1560.114 () Searching and replacing reached row: 40000
1562.361 () Searching and replacing reached row: 45000
1564.639 () Searching and replacing reached row: 50000
1566.949 () Searching and replacing reached row: 55000
1569.251 () Searching and replacing reached row: 60000
1571.538 () Searching and replacing reached row: 65000
1573.841 () Searching and replacing reached row: 70000
1576.175 () Searching and replacing reached row: 75000
1578.495 () Searching and replacing reached row: 80000
1580.823 () Searching and replacing reached row: 85000
1583.171 () Searching and replacing reached row: 90000
1585.500 () Searching and replacing reached row: 95000
1587.851 () Searching and replacing reached row: 100000
1590.228 () Searching and replacing reached row: 105000
1592.626 () Searching and replacing reached row: 110000
1594.997 () Searching and replacing reached row: 115000
1597.379 () Searching and replacing reached row: 120000
1599.744 () Searching and replacing reached row: 125000
1602.089 () Searching and replacing reached row: 130000
1604.447 () Searching and replacing reached row: 135000
1606.816 () Searching and replacing reached row: 140000
1609.195 () Searching and replacing reached row: 145000
1611.562 () Searching and replacing reached row: 150000
1613.985 () Searching and replacing reached row: 155000
1616.372 () Searching and replacing reached row: 160000
1618.799 () Searching and replacing reached row: 165000
1621.225 () Searching and replacing reached row: 170000
1623.659 () Searching and replacing reached row: 175000
1626.123 () Searching and replacing reached row: 180000
1628.596 () Searching and replacing reached row: 185000
1631.053 () Searching and replacing reached row: 190000
1633.526 () Searching and replacing reached row: 195000
1636.026 () Searching and replacing reached row: 200000
1638.507 () Searching and replacing reached row: 205000
1641.001 () Searching and replacing reached row: 210000
1643.525 () Searching and replacing reached row: 215000
1646.035 () Searching and replacing reached row: 220000
1648.565 () Searching and replacing reached row: 225000
1651.101 () Searching and replacing reached row: 230000
1653.635 () Searching and replacing reached row: 235000
1656.187 () Searching and replacing reached row: 240000
1658.773 () Searching and replacing reached row: 245000
1661.451 () Searching and replacing reached row: 250000
1664.217 () Searching and replacing reached row: 255000
1666.829 () Searching and replacing reached row: 260000
1669.432 () Searching and replacing reached row: 265000
1672.158 () Searching and replacing reached row: 270000
1674.887 () Searching and replacing reached row: 275000
1677.513 () Searching and replacing reached row: 280000
1680.139 () Searching and replacing reached row: 285000
1682.789 () Searching and replacing reached row: 290000
1685.434 () Searching and replacing reached row: 295000
1688.075 () Searching and replacing reached row: 300000
1690.725 () Searching and replacing reached row: 305000
1693.391 () Searching and replacing reached row: 310000
1696.083 () Searching and replacing reached row: 315000
1698.762 () Searching and replacing reached row: 320000
1701.472 () Searching and replacing reached row: 325000
1704.205 () Searching and replacing reached row: 330000
1706.908 () Searching and replacing reached row: 335000
1709.620 () Searching and replacing reached row: 340000
1712.372 () Searching and replacing reached row: 345000
1715.088 () Searching and replacing reached row: 350000
1717.998 () Searching and replacing reached row: 355000
1721.509 () Searching and replacing reached row: 360000
1724.406 () Searching and replacing reached row: 365000
1727.329 () Searching and replacing reached row: 370000
1730.251 () Searching and replacing reached row: 375000
1732.074 () Processing table (InnoDB): wp_registrations
1746.877 () Database queries processed: 1500 in 1745.00 seconds
1784.911 () Database queries processed: 1750 in 1783.03 seconds
1827.117 () Database queries processed: 2000 in 1825.24 seconds
1870.585 () Database queries processed: 2250 in 1868.71 secondsThanks,
Hi,
From the log, it appears that your database contains a number of very large tables, and the connection to the database is not very fast.
As such, UpdraftPlus is not able to complete the database search and restore operation.However, the options and user tables are restored, so you should be able to gain access to the site. You should then be able to see a ‘Continue restoration’ button in the UpdraftPlus settings page. Can you see this button?
Best Wishes,
David NHi Mark,
Apologies for the delay. It appears that my previous reply did not post correctly.
There are some other options that can be tried. However, these will require a fresh backup to be taken.
Firstly, please could you try using our free WP Optimize plugin on the original site? This will hopefully clear out any obsolete data from the database, and reduce the size of the problem tables.
You can also try taking a backup of the database in several parts. UpdraftPlus Premium allows you to exclude database tables from the backup. If you backup the larger tables separately, you can restore them individually, then restore the rest of the database. This should allow enough time to restore each section.
Best Wishes,
David N
- The topic ‘Restoration Error’ is closed to new replies.