What do I actually need to backup?

Hi,

All posts, pages and settings are stored in the database.
The Plugins and Themes section of the backup store the actual plugin and theme files.

The Uploads section contains the image and other media files.

Please could you send us a copy of the latest backup log? This can be found in the Existing Backups tab. We can then check how large the backups are, and if there any any other errors occurring.

The contents will be too long to post here, but you can use an online service such as Pastebin, and post the link here.

Thanks @dnutbourne

This is the log file from the latest backup, this backup was ONLY of the database:

0000.000 (0) Opened log file at time: Mon, 17 Jul 2017 18:49:52 +0000 on https://beautybestfriend.com
0000.004 (0) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.13.4 WP: 4.8 PHP: 5.6.30 (cgi-fcgi, Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux) MySQL: 5.5.55 WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 268435456 (used: 44.9M | 45.8M) multisite: N openssl: OpenSSL 1.0.1t 3 May 2016 mcrypt: Y LANG: ZipArchive::addFile: Y
0000.005 (0) Free space on disk containing Updraft’s temporary directory: 383928.6 MB
0000.014 (0) Tasks: Backup files: 0 (schedule: manual) Backup DB: 1 (schedule: manual)
0000.030 (0) Requesting semaphore lock (d) (apparently not via scheduler)
0000.034 (0) Set semaphore last lock (d) time to 2017-07-17 18:49:52
0000.035 (0) Semaphore lock (d) complete
0000.040 (0) Backup run: resumption=0, nonce=098e6f093a63, begun at=1500317392 (0s ago), job type=backup
0000.043 (0) Scheduling a resumption (1) after 300 seconds (1500317692) in case this run gets aborted
0000.069 (0) This backup run is not intended for files – skipping
0000.070 (0) Beginning creation of database dump (WordPress DB)
0000.072 (0) Testing: /usr/bin/mysqldump
0000.101 (0) Output: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;\n/*!40103 SET TIME_ZONE=’+00:00′ */;\n/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\n/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\n/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;\n/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\nDROP TABLE IF EXISTS wp_options;\n/*!40101 SET @saved_cs_client = @@character_set_client */;\n/*!40101 SET character_set_client = utf8 */;\nCRE (truncated – 1080 bytes total)
0000.105 (0) Working binary mysqldump found: /usr/bin/mysqldump
0000.121 (0) Table wp_options: Total expected rows (approximate): 1006
0000.186 (0) Table wp_options: Total rows added: 1002 in 0.06 seconds
0000.188 (0) Table wp_options: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_options.table.gz – 110.5 KB)
0000.196 (0) Table wp_users: Total expected rows (approximate): 1
0000.202 (0) Table wp_users: Total rows added: 1 in 0.00 seconds
0000.205 (0) Table wp_users: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_users.table.gz – 0.6 KB)
0000.212 (0) Table wp_usermeta: Total expected rows (approximate): 38
0000.217 (0) Table wp_usermeta: Total rows added: 38 in 0.00 seconds
0000.219 (0) Table wp_usermeta: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_usermeta.table.gz – 2.3 KB)
0000.224 (0) Table wp_commentmeta: Total expected rows (approximate): 3823
0000.373 (0) Table wp_commentmeta: Total rows added: 3823 in 0.15 seconds
0000.376 (0) Table wp_commentmeta: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_commentmeta.table.gz – 77.6 KB)
0000.384 (0) Table wp_comments: Total expected rows (approximate): 1576
0000.551 (0) Table wp_comments: Total rows added: 1576 in 0.17 seconds
0000.553 (0) Table wp_comments: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_comments.table.gz – 178.6 KB)
0000.563 (0) Table wp_links: Total expected rows (approximate): 0
0000.567 (0) Table wp_links: Total rows added: 0 in 0.00 seconds
0000.569 (0) Table wp_links: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_links.table.gz – 0.4 KB)
0000.575 (0) Table wp_postmeta: Total expected rows (approximate): 13443
0000.991 (0) Table wp_postmeta: binary mysqldump finished (writes: 42) in 0.41 seconds
0000.993 (0) Table wp_postmeta: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_postmeta.table.gz – 652.1 KB)
0000.999 (0) Table wp_posts: Total expected rows (approximate): 7302
0002.831 (0) Table wp_posts: Total rows added: 7302 in 1.83 seconds
0002.834 (0) Table wp_posts: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_posts.table.gz – 1874.7 KB)
0002.839 (0) Table wp_term_relationships: Total expected rows (approximate): 9950
0002.890 (0) Table wp_term_relationships: binary mysqldump finished (writes: 30) in 0.05 seconds
0002.893 (0) Table wp_term_relationships: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_term_relationships.table.gz – 27.5 KB)
0002.899 (0) Table wp_term_taxonomy: Total expected rows (approximate): 2381
0002.959 (0) Table wp_term_taxonomy: Total rows added: 2381 in 0.06 seconds
0002.961 (0) Table wp_term_taxonomy: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_term_taxonomy.table.gz – 13.9 KB)
0002.965 (0) Table wp_termmeta: Total expected rows (approximate): 0
0002.968 (0) Table wp_termmeta: Total rows added: 0 in 0.00 seconds
0002.969 (0) Table wp_termmeta: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_termmeta.table.gz – 0.3 KB)
0002.973 (0) Table wp_terms: Total expected rows (approximate): 2381
0003.023 (0) Table wp_terms: Total rows added: 2381 in 0.05 seconds
0003.025 (0) Table wp_terms: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_terms.table.gz – 23.4 KB)
0003.030 (0) Table wp_wp_rp_tags: Total expected rows (approximate): 19236
0003.105 (0) Table wp_wp_rp_tags: binary mysqldump finished (writes: 31) in 0.07 seconds
0003.108 (0) Table wp_wp_rp_tags: finishing file (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_wp_rp_tags.table.gz – 95 KB)
0003.112 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_options.table.gz (1/13): adding to final database dump
0003.144 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_users.table.gz (2/13): adding to final database dump
0003.146 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_usermeta.table.gz (3/13): adding to final database dump
0003.148 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_commentmeta.table.gz (4/13): adding to final database dump
0003.194 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_comments.table.gz (5/13): adding to final database dump
0003.244 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_links.table.gz (6/13): adding to final database dump
0003.246 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_postmeta.table.gz (7/13): adding to final database dump
0003.501 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_posts.table.gz (8/13): adding to final database dump
0004.149 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_term_relationships.table.gz (9/13): adding to final database dump
0004.162 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_term_taxonomy.table.gz (10/13): adding to final database dump
0004.182 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_termmeta.table.gz (11/13): adding to final database dump
0004.184 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_terms.table.gz (12/13): adding to final database dump
0004.205 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db-table-wp_wp_rp_tags.table.gz (13/13): adding to final database dump
0004.234 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz: finished writing out complete database file (3040 KB)
0004.287 (0) Total database tables backed up: 13 (backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz, size: 3133065, sha256)
0004.293 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz: db: This file has not yet been successfully uploaded: will queue
0004.294 (0) Saving backup history. Total backup size: 3 MB
0004.297 (0) Requesting upload of the files that have not yet been successfully uploaded (1)
0004.300 (0) Cloud backup selection (1/1): googledrive (last)
0004.301 (0) Beginning dispatch of backup to remote (googledrive)
0004.347 (0) Google Drive: requesting access token: client_id=148969925649-j64umuivcsaouc64oelc43bc4sk27jal.apps.googleusercontent.com
0004.503 (0) Google Drive: successfully obtained access token
0006.283 (0) Google Drive quota usage: used=0 MB, total=15360 MB, available=15360 MB
0006.284 (0) backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz: Attempting to upload to Google Drive (into folder id: 0B5JW-LfVOgEAUC1iUDJaSl90ZUE)
0006.757 (0) Googledrive chunked upload: 33.5 % uploaded (1048576)
0006.936 (0) Googledrive chunked upload: 66.9 % uploaded (2097152)
0007.713 (0) Googledrive chunked upload: 100 % uploaded (2097152)
0007.718 (0) OK: Archive backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz uploaded to Google Drive in 1.43 seconds
0007.721 (0) Recording as successfully uploaded: backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz (e516611a3451a06271c3b7cf22eba4fb)
0007.727 (0) Deleting local file: backup_2017-07-17-1849_Beauty_Best_Friend_UK_Beauty_B_098e6f093a63-db.gz: OK
0007.733 (0) Retain: beginning examination of existing backup sets; user setting: retain_files=1, retain_db=1
0007.735 (0) Number of backup sets in history: 1; groups (db): 1
0007.736 (0) Examining (for databases) backup set with group_id=0, nonce=098e6f093a63, datestamp=1500317392 (Jul 17 2017 18:49:52)
0007.737 (0) This backup set is the backup set just made, so will not be deleted.
0007.738 (0) Number of backup sets in history: 1; groups (files): 1
0007.739 (0) Examining (for files) backup set with nonce=098e6f093a63, datestamp=1500317392 (Jul 17 2017 18:49:52)
0007.743 (0) This backup set remains non-empty (f=0/d=1); will retain in history
0007.745 (0) Retain: saving new backup history (sets now: 1) and finishing retain operation
0007.750 (0) Resume backup (098e6f093a63, 0): finish run
0007.755 (0) Decremented the semaphore (d) by 1
0007.757 (0) Semaphore (d) unlocked
0007.758 (0) There were no errors in the uploads, so the ‘resume’ event (1) is being unscheduled
0007.770 (0) Fetching RSS news feed
0008.078 (0) Fetched RSS news feed; result is a: SimplePie
0008.130 (0) Sending email (‘Database only (files were not part of this particular schedule)’) report (attachments: 0, size: 0 KB) to: laura…
0008.900 (0) The backup apparently succeeded and is now complete

Am I right in thinking that this has run successfully?

When I ran the very first backup and included the plugins, themes and uploads the log file was huge, I wasn’t even able to use PasteBin as it said the file was too big. I’m wondering if it is the images that are taking up all the space as I have over 600 blog posts all with at least 2 images.

Thanks,

Laura

Hi Laura,

The log file shows the backup completing successfully.

Depending on the size of the images, it is likely that the backups that include the Uploads section are quite large.

If you have Dropbox, you can upload the log file for a full backup there, and post the sharing link here.

Thanks @dnutbourne

Below is the link to my full backup, I’ve used Dropbox, I hope you can view it OK it’s the first time I’ve used Dropbox:

https://www.dropbox.com/s/mdyszvth9c2ogad/Backup%20Log%2019th%20July%202017.docx?dl=0

Let me know what you think. I don’t really understand the log files and it’s so long. I’m thinking that the images are taking up a lot of space, but not sure if I need to backup the images or not.

Thanks,

Laura

Hi Laura,

It appears that there was an error while creating the Uploads backup.
It appears that there may not be enough room on the hosting account to hold the backup.

Please could you check how much available quota is left in the hosting account?

Thanks @dnutbourne.

According to 1and1 I have 2553mb left. Do you think this is the problem?

I’m not really sure if I need to be backing up my images (I’m assuming these are what is taking up all the space, could this be the case?). I have all the images stored on my PC, but assume if the worst happened and unneeded to recreate my blog I’d need to re-add them post by post.

Thanks,

Laura

Thanks @dnutbourne. According to 1and1 I have 2553mb left, could this be the problem?

I’m not really sure if I need to backup my images, I’m assuming these are what is taking up most of the space – do you think this is the case? I have all the photos stored on my PC. If the worst happened and I needed to recreate my blog I assume I’d need to re-add the photos post by post? Whereas if I have them backed up would I just be able to instantly restore them all with one click?

Thanks

Laura

Hi Laura,

It appears that there is not enough space in the hosting account to fit the Uploads backup, which is ~2263MB.

When backing up each section, UpdraftPlus requires enough space to keep temporary files, and the final backup file. As such we usually recommend having at least twice the amount of total space in the hosting account as the size of the site.

If you have a separate backup of the images, and no new images are being added (e.g. by users of the sites), then it may not be necessary to backup the Uploads.
You would need to manually restore the images in this case, by uploading them to the site via FTP.

Thanks @dnutbourne I think I’m going to backup everything apart from the Uploads. Fingers crossed I never need to worry about uploading my images anyway, but if the worst happens I do have them saved and it’s only me who adds them.

Thanks for all your help!

Laura