I just had to look for something that got deleted in one of the systems I administrate. \u00a0We have daily backups for the last week, weekly backups for the last two month, monthly backups for the last year, and yearly backups for ever. \u00a0That seemed like a sensible backup plan. \u00a0Unfortunately, the item that I was looking for was deleted created and deleted a couple of weeks ago. \u00a0It probably made it into one of the daily backups, but got rotated out. \u00a0And it didn’t live long enough to get into the weekly backup. \u00a0And now it’s gone.<\/p>\n
(It wasn’t anything critical – but it would be awesome to restore it anyway.)<\/p>\n
If it was a file, a backup tool like HashBackup<\/a> could have made sure I’d never lose it. \u00a0But it was an item in the database, of which I have a compressed dump. \u00a0I’m guessing it’s probably the time to look for a proper database backup tool…<\/p>\n Any recommendations for MySQL?<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n I just had to look for something that got deleted in one of the systems I administrate. \u00a0We have daily backups for the last week, weekly backups for the last two month, monthly backups for the last year, and yearly backups for ever. \u00a0That seemed like a sensible backup plan. \u00a0Unfortunately, the item that I … Continue reading Backup black hole<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,133,62],"tags":[251,1559,3213,3066],"keyring_services":[],"class_list":["post-22246","post","type-post","status-publish","format-standard","hentry","category-general","category-sysadmin","category-technology","tag-backup","tag-databases","tag-hashbackup","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t