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?
sully1958Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eoin OSullivanConnect With a Mentor ConsultantCommented:
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
 
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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.