Solved

usr file excluded from Time Machine backup

Posted on 2013-01-15
16
31 Views
Last Modified: 2016-03-19
Yesterday, I gave myself permission to read/write a file in my usr file and since then Time Machine is not backing up the usr file at all.  Any idea what I've done wrong?
0
Comment
Question by:sully1958
  • 7
  • 6
16 Comments
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 38781773
Try a "Repair Permissions" using the Disk Utility application.

Can you see the previous backups of the file concerned in TimeMachine?
When you edited the file .. TimeMachine SHOULD take a snapshot of it.

Can you provide any more detail on the file and HOW you changed permissions on the file?  Did you change the owner or just add r/w permissions for all users?
0
 

Author Comment

by:sully1958
ID: 38783055
Repair Permissions did not fix the problem.  Yes, I can see previous backups of the usr foler, but the folder within that folder that I wanted access to (it is a database file within my mysql folder) was locked - I did not have permission to open it to grab the table I wanted to restore.  So, I gave myself permission on that database folder and can see it, access it, etc. when working in my finder window, but the entire usr folder no longer shows up in my Time Machine Backups.
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 38783776
So TimeMachine is ignoring the ENTIRE usr folder since you made this change?

Can you revert permissions to how they were before to see if it comes back?

If it comes back we can look at other ways to access files/folders inside the usr folder without changing permissions
0
 

Author Comment

by:sully1958
ID: 38783827
Yes, TM is ignoring the entire folder.  I tried reverting the permissions, but then I lost all access to the tables within the mysql database (weird, since I had access before I did the permission change).  I am able to back up the folder without problem using my remote solution (iBackup.com).  I backup with Time Machine for the hourly backkups and iBackup for the daily backups.
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 38783854
The mysql databases need to be owned by the current user or the mysql user account.

I'm guessing that the permissions are messed up overall.
Using the simplified File/Folder info window to change permissions can have unwanted effects on system-type folders as the permissions can often be more complex than they may first appear.


If you only made the changes recently could you restore the Timemachine backup of the usr folder??
0
 

Author Comment

by:sully1958
ID: 38783861
Unfortunately, more data has been added to the tables since I did the change and restoring the files to the previous state would lose the data.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 39

Accepted Solution

by:
Eoin OSullivan earned 500 total points
ID: 38783877
IF it is only the databases .. you could think about duplicating or backing up the databases and then restoring them once you've rebuilt the usr folder.

You could run a mysqldump on the current databases and restore it afterwards
http://blog.tatedavies.com/2011/01/18/how-to-use-mysqldump/
0
 

Author Comment

by:sully1958
ID: 38783885
Thanks.  I'll try that - may take a while.  Will let you know.  Thanks again.
0
 

Author Comment

by:sully1958
ID: 41503461
I've requested that this question be deleted for the following reason:

no responses
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 41503460
There were responses and this issue was awaiting asker feedback. Delete request cancelled pending user input
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 41503462
Several responses were provided
0
 

Author Comment

by:sully1958
ID: 41507054
My bad - I confused this with a different question I had posted.  The comment from 2013-01-16 at 10:41:57ID: 38783877 actually was the correct solution - I neglected to close it out.  Please advise how I do this.
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 41507391
Click the BEST SOLUTION button on the answer which is appropriate ... if there are other responses also relevant click ASSISTED SOLUTION on those too
Press NEXT in the toolbar at the bottom of the screen to proceed and allocate points and close the question.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Apple's Mac OS X has become an official member of the malware club. The Flashback Trojan has affected over half million Macs, worldwide. It is behavior that ultimately gets malware onto a person’s computer. Obsolete or out-of-date software helps…
In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
This video discusses moving either the default database or any database to a new volume.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now