Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

usr file excluded from Time Machine backup

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
sully1958
Asked:
sully1958
  • 7
  • 6
1 Solution
 
Eoin OSullivanConsultantCommented:
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
 
sully1958Author Commented:
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
 
Eoin OSullivanConsultantCommented:
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
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
sully1958Author Commented:
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
 
Eoin OSullivanConsultantCommented:
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
 
sully1958Author Commented:
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
 
Eoin OSullivanConsultantCommented:
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
 
sully1958Author Commented:
Thanks.  I'll try that - may take a while.  Will let you know.  Thanks again.
0
 
sully1958Author Commented:
I've requested that this question be deleted for the following reason:

no responses
0
 
Eoin OSullivanConsultantCommented:
There were responses and this issue was awaiting asker feedback. Delete request cancelled pending user input
0
 
Eoin OSullivanConsultantCommented:
Several responses were provided
0
 
sully1958Author Commented:
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
 
Eoin OSullivanConsultantCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now