- Posts
Hi there,
Total Upkeep does not seem to be backing up my databases. When I go to my back ups it and click on database it says “And unexpected error occurred” for all the database backups. I am also not 100% sure if it is backing up my entire files and folders as the file size seems very small. Please advise. Thank you.
Hi,
Thank you for reaching out and thanks for using Total Upkeep WordPress Backup Plugin. I’m sorry to hear you’re having trouble backing up your databases. Total Upkeep makes a log every time you create a backup, and that’s going to be the where we want to check first.
Navigate to Total Upkeep<<Tools<<Logs and find your most recent log, it’ll have a name like
archive-xxxxxxx.log. If you can copy/paste your log results in your reply we’ll be able to give you some more information on what’s going wrong.Hi,
Thanks for your reply.
Here is the latest archive log….
Kind regards
[2021-11-08 12:24:13 UTC] PHP Version: 7.3.32
[2021-11-08 12:24:13 UTC] WordPress Version: 5.8.1
[2021-11-08 12:24:13 UTC] Total Upkeep version: 1.14.13
[2021-11-08 12:24:13 UTC] getpgid support: Available
[2021-11-08 12:24:13 UTC] Backup process initialized.
[2021-11-08 12:24:13 UTC] Process id: 197584
[2021-11-08 12:24:13 UTC] ——————————————————————————–
[2021-11-08 12:24:13 UTC] Starting dump of database…
[2021-11-08 12:24:13 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 15310304 (14.60 MB) / 15927240 (15 MB)
[2021-11-08 12:24:13 UTC] Database info: Array
(
[wpaz_actionscheduler_actions] => 80
[wpaz_actionscheduler_claims] => 0
[wpaz_actionscheduler_groups] => 2
[wpaz_actionscheduler_logs] => 228
[wpaz_bwg_album] => 1
[wpaz_bwg_album_gallery] => 0
[wpaz_bwg_file_paths] => 6
[wpaz_bwg_gallery] => 1
[wpaz_bwg_image] => 2
[wpaz_bwg_image_comment] => 0
[wpaz_bwg_image_rate] => 0
[wpaz_bwg_image_tag] => 0
[wpaz_bwg_shortcode] => 3
[wpaz_bwg_theme] => 2
[wpaz_bwge_album] => 0
[wpaz_bwge_album_gallery] => 0
[wpaz_bwge_ecommerceoptions] => 40
[wpaz_bwge_gallery] => 0
[wpaz_bwge_image] => 0
[wpaz_bwge_image_comment] => 0
[wpaz_bwge_image_rate] => 0
[wpaz_bwge_image_tag] => 0
[wpaz_bwge_option] => 1
[wpaz_bwge_order_images] => 0
[wpaz_bwge_orders] => 0
[wpaz_bwge_parameters] => 0
[wpaz_bwge_payment_systems] => 4
[wpaz_bwge_pricelist_items] => 0
[wpaz_bwge_pricelist_parameters] => 0
[wpaz_bwge_pricelists] => 0
[wpaz_bwge_shortcode] => 0
[wpaz_bwge_theme] => 1
[wpaz_commentmeta] => 0
[wpaz_comments] => 1
[wpaz_create_map] => 0
[wpaz_crp_portfolios] => 1
[wpaz_crp_projects] => 3
[wpaz_fv_player_playermeta] => 1
[wpaz_fv_player_players] => 2
[wpaz_fv_player_videometa] => 0
[wpaz_fv_player_videos] => 2
[wpaz_gmw_forms] => 0
[wpaz_gmw_locationmeta] => 0
[wpaz_gmw_locations] => 0
[wpaz_group_map] => 0
[wpaz_iowd_images] => 23
[wpaz_leafletmapsmarker_layers] => 11
[wpaz_leafletmapsmarker_markers] => 63
[wpaz_links] => 0
[wpaz_map_locations] => 0
[wpaz_mapfig_premium_groups] => 7
[wpaz_mapfig_premium_groups_has_layers] => 31
[wpaz_mapfig_premium_layers] => 17
[wpaz_mapfig_premium_map] => 1
[wpaz_mappress_maps] => 0
[wpaz_mappress_posts] => 0
[wpaz_mmp_layers] => 17
[wpaz_mmp_maps] => 25
[wpaz_mmp_markers] => 325
[wpaz_mmp_relationships] => 748
[wpaz_nextend2_image_storage] => 58
[wpaz_nextend2_section_storage] => 6
[wpaz_nextend2_smartslider3_generators] => 0
[wpaz_nextend2_smartslider3_sliders] => 38
[wpaz_nextend2_smartslider3_sliders_xref] => 1
[wpaz_nextend2_smartslider3_slides] => 118
[wpaz_ngg_album] => 0
[wpaz_ngg_gallery] => 0
[wpaz_ngg_pictures] => 0
[wpaz_options] => 984
[wpaz_page_visit] => 1196
[wpaz_page_visit_history] => 64100
[wpaz_page_visit_referer] => 2091
[wpaz_page_visit_wizard] => 1
[wpaz_postmeta] => 9069
[wpaz_posts] => 4938
[wpaz_pps_countries] => 240
[wpaz_pps_popup] => 46
[wpaz_pps_popup_show_categories] => 0
[wpaz_pum_subscribers] => 0
[wpaz_smush_dir_images] => 0
[wpaz_term_relationships] => 164
[wpaz_term_taxonomy] => 43
[wpaz_termmeta] => 43
[wpaz_terms] => 43
[wpaz_totalsoft_galleryv_dbt] => 17
[wpaz_totalsoft_galleryv_dbt_1] => 17
[wpaz_totalsoft_galleryv_dbt_2] => 17
[wpaz_totalsoft_galleryv_dbt_3] => 0
[wpaz_totalsoft_galleryv_dbt_4] => 0
[wpaz_totalsoft_galleryv_id] => 2
[wpaz_totalsoft_galleryv_manager] => 0
[wpaz_totalsoft_galleryv_videos] => 0
[wpaz_totalsoft_new_plugin] => 2
[wpaz_ums_icons] => 47
[wpaz_ums_maps] => 9
[wpaz_ums_marker_groups] => 27
[wpaz_ums_marker_groups_relation] => 28
[wpaz_ums_markers] => 25
[wpaz_ums_modules] => 12
[wpaz_ums_modules_type] => 4
[wpaz_ums_options] => 2
[wpaz_ums_options_categories] => 4
[wpaz_ums_usage_stat] => 0
[wpaz_usermeta] => 62
[wpaz_users] => 1
[wpaz_wc_download_log] => 0
[wpaz_wc_product_meta_lookup] => 2
[wpaz_wc_webhooks] => 0
[wpaz_wd_fb_data] => 4
[wpaz_wd_fb_info] => 1
[wpaz_wd_fb_option] => 1
[wpaz_wd_fb_shortcode] => 0
[wpaz_wd_fb_theme] => 1
[wpaz_web_paceportfolio_images] => 9
[wpaz_web_paceportfolio_portfolios] => 1
[wpaz_webpace_maps_circles] => 1
[wpaz_webpace_maps_directions] => 0
[wpaz_webpace_maps_maps] => 1
[wpaz_webpace_maps_markers] => 2
[wpaz_webpace_maps_polygons] => 1
[wpaz_webpace_maps_polylines] => 1
[wpaz_webpace_maps_stores] => 0
[wpaz_woocommerce_api_keys] => 0
[wpaz_woocommerce_attribute_taxonomies] => 0
[wpaz_woocommerce_downloadable_product_permissions] => 0
[wpaz_woocommerce_log] => 0
[wpaz_woocommerce_order_itemmeta] => 0
[wpaz_woocommerce_order_items] => 0
[wpaz_woocommerce_payment_tokenmeta] => 0
[wpaz_woocommerce_payment_tokens] => 0
[wpaz_woocommerce_sessions] => 1
[wpaz_woocommerce_shipping_zone_locations] => 0
[wpaz_woocommerce_shipping_zone_methods] => 0
[wpaz_woocommerce_shipping_zones] => 0
[wpaz_woocommerce_tax_rate_locations] => 0
[wpaz_woocommerce_tax_rates] => 0
[wpaz_wpforms_tasks_meta] => 56
[wpaz_wpgmza] => 1
[wpaz_wpgmza_categories] => 0
[wpaz_wpgmza_category_maps] => 0
[wpaz_wpgmza_circles] => 0
[wpaz_wpgmza_maps] => 1
[wpaz_wpgmza_polygon] => 0
[wpaz_wpgmza_polylines] => 0
[wpaz_wpgmza_rectangles] => 0
[wpaz_yoast_indexable] => 332
[wpaz_yoast_indexable_hierarchy] => 70
[wpaz_yoast_migrations] => 21
[wpaz_yoast_primary_term] => 1
[wpaz_yoast_seo_links] => 508
[wpaz_yoast_seo_meta] => 2074
)[2021-11-08 12:24:18 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:20 UTC] Dump of database complete! $status = 1
[2021-11-08 12:24:20 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 15310616 (14.60 MB) / 19061272 (18 MB)
[2021-11-08 12:24:20 UTC] ——————————————————————————–
[2021-11-08 12:24:23 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:26 UTC] Database dump file added to file list: /home/satouikg/boldgrid_backup/satouikg_wp567.20211108-122413.sql / 178529560 (170.26 MB)
[2021-11-08 12:24:26 UTC] Starting archiving of files. Chosen compressor: php_zip
[2021-11-08 12:24:26 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 27916144 (26.62 MB) / 29520568 (28 MB)
[2021-11-08 12:24:27 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:30 UTC] Total files / size archived: 18728 / 610255057 (581.98 MB)
[2021-11-08 12:24:31 UTC] Starting to close the zip file.
[2021-11-08 12:24:31 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 28425160 (27.11 MB) / 29520568 (28 MB)
[2021-11-08 12:24:33 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:37 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:43 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:48 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:53 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:24:58 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:25:03 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:25:08 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:25:13 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:25:18 UTC] Backup process running: Yes (pgid = 88485)
[2021-11-08 12:25:47 UTC] Finished closing the zip file.
[2021-11-08 12:25:47 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 28425064 (27.11 MB) / 29520568 (28 MB)
[2021-11-08 12:25:47 UTC] Archiving of files complete!
[2021-11-08 12:25:47 UTC] Archive filepath / size: /home/satouikg/boldgrid_backup/boldgrid-backup-satourismtv.co_.za-222beec7-20211108-122426.zip / 239485729 (228.39 MB)
[2021-11-08 12:25:47 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 28424560 (27.11 MB) / 29520568 (28 MB)
[2021-11-08 12:25:47 UTC] Starting sending of email…
[2021-11-08 12:25:47 UTC] Sending of email complete! Status: 1
[2021-11-08 12:25:49 UTC] Backup complete!
[2021-11-08 12:25:49 UTC] Memory usage – limit / current / peak memory usage: 1073741824 / 29304408 (27.95 MB) / 51247352 (49 MB)
[2021-11-08 12:27:18 UTC] Backup process running: Yes (pgid = 88485)Just looking at your log it seems your backup completed properly. I do see the
Dump of database complete! $status = 1message which indicates the database dump was indeed successful.At what point do you get the “An unexpected error occurred” message? If you are backing up the entire database you just need to make sure the “Backup all tables (full backup)” under Database is selected and you shouldn’t have to make any extra steps, just click “Backup Site Now” and let the backup run its course.
Hi Brandon,
Unfortunately I can’t post a screenshot here but I will try to explain it…
I click on TOTAL UPKEEP > BACKUPS. I then get a list of a number of archived backups.
I click on VIEW BACKUP for one of them.
I then scroll down to under…
“Backup Browser
Use the File & Folders and Database tools below to browse the contents of this backup file.”
There are two tabs below this – “Files & Folders” and “Database”
Under “Files and Folders” I see a list of files and folders.
However, if I click on the DATABASE tab it says “loading” for 1 or 2 seconds and then says “An unknown error has occurred”
Hope this explains it… ThanksPS. Backup of all files (under files and folders setting) and all tables (under database setting) are checked.
Thank you for that detailed information. So your backup file is really large and that’s why it’s timing out under your Backup Browser tab.
/home/satouikg/boldgrid_backup/satouikg_wp567.20211108-122413.sql / 178529560 (170.26 MB)I also noticed that you’re using Zip Archive as your compressor. Try changing the compressor type to “System Zip” and then run your backup again to see if you get different results.
Hi,
I changed to System Zip and the download got a lot further down the download process before it bombed out – stating “Failed – server problem”. Tried a few times with the same result. Also, after switching to System Zip, clicking on the “DATABASE” tab still came back with “An unknown error has occurred.”
So besides not being able to download to my local machine it means that I cannot restore any of the databases from the pre-existing archived backups made on my server by Total Upkeep either.
Another thing to note is that my main domain also has a sub-domain. That sub-domain folder is not in my public-html folder but sits outside the public-html folder in its own folder called maps.satourismtv.co.za. I do not see that folder in the Total Upkeep FILES & FOLDERS that are in the archived server backup.
Having a sub-domain also means that I have 2 databases and not just one.
Not sure if this could have anything do with how Total Upkeep backs up but just thought I’d mention it.
Thx.
Thank you for that information. We can rule out the concern of the sub domain because there is only one database prefix in the log.
More than likely the issue is being caused by some server resource is getting hit while total Upkeep tries to read the database backup file. Your database size (4,938 posts at 170MB) is quite large. For comparison Boldgrid.com/support has 28,118 posts and is only 9.5MB.
I noticed in your log that,
wpaz_page_visit_historyhas &rt;64,000 records. One thing you could try is excluding that table from a backup and see if that allows it to complete. There’s also nextend2_image_storage, which could possibly be very large if it’s actually storing image files as database globs instead of using the media library.For your download concern –
download process before it bombed out – stating "Failed – server problem", sounds like it is also a server resource issue, possibly Apache’sLimitRequestBodyor Nginx’s client_max_body_size.Reach out to your Web Host and ask them if your resources are adequate to read and run a database of this size.
I hope this helps! Please reach back out if you have any other questions.
Hi Brandon,
Thanks for sticking with me on this.
Unfortunately we re now moving beyond my technical expertise (which is not very high to begin with).
To me only one database prefix would be a concern as there are two databases. So I’m not sure what you mean here?
I have no idea why the database is quite large. I thought 180mb was small. I checked the phpMyAdmin and there are two large structures in my main database:
– wpaz_posts (98.6Mb)
– wpaz_postmeta (68.8Mb)
– wpaz_page_visit_history (8.6Mb)
The rest are all small in Kb
nextend2_image_storage is only 30kbThe weird thing is that I do not have one “post” on my website as far as I understand what a normal “post” is.
I will reach out to my web host as suggested and ask them if they can assist.
Thank you so much for your time and advice.
Yes, so Total Upkeep is a plugin that is associated with your website, so it’s only configured to backup/restore one database at a time, the database that is specific to your website. You may have 2 databases showing in the phpMyAdmin section of your Web Hosting account, one for your main domain and one for your subdomain but in order to download backups for both using Total Upkeep you would need to install the Total Upkeep plugin on your sub domain and back it up as a separate instance. Your web host more than likely allows cPanel backups for multiple databases server side.
As for your database size 180mb was the compressed amount. The total size of the database was closer to 700mb which is very large. Your web host should be able to allocate the resources that would allow your server to read a file this size.
I hope I’ve answered all your questions. We’re always here to help if you need any additional assistance.
- The topic ‘Total Upkeep is Not Backing Up My Database’ is closed to new replies.
