Mourning the loss of our friend, WhitPhil.
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Apple MacOS
Tag Cloud
access audio black screen blue screen boot bsod connection crash dell desktop drivers dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor motherboard network networking outlook problem processor recovery registry cleaner router screen slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless
Search
Search for:
Tech Support Guy Forums > Operating Systems > Apple MacOS >
mac os X 10.6 file permissions in ls -l listing.

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
andynic's Avatar
Computer Specs
Member with 51 posts.
 
Join Date: May 2007
Location: Amsterdam
Experience: Beginner
23-Oct-2009, 09:39 AM #1
mac os X 10.6 file permissions in ls -l listing.
Hi,
I'm fairly new to Mac OS X having been a Windows XP user for a number of years.

Two sections follow:
1. The Question
2. Additional Information

1. The Question
============
What is the @ in the following listing?
What does it mean?
How can I change the permissions to get rid of it?
bash-3.2# ls -l
total 41008
-rw-rw----@ 1 _mysql wheel 20803 23 Oct 12:41 andy-nicastros-imac.local.err
drw-rw----@ 6 _mysql wheel 204 22 Oct 13:23 gfr
-rw-rw----@ 1 _mysql wheel 5242880 23 Oct 11:28 ib_logfile0
-rw-rw----@ 1 _mysql wheel 5242880 21 Oct 21:01 ib_logfile1
-rw-rw----@ 1 _mysql wheel 10485760 23 Oct 11:28 ibdata1
drwxr-x---@ 71 _mysql wheel 2414 21 Oct 20:50 mysql
drwxr-x---@ 2 _mysql wheel 68 4 Sep 21:18 test

2. Additional Information
==================
1. Using cp -p -r I copied the data directory to a directory in my user environment to prepare it for backup to a DVD.

In order to test the backup concept:
2. I renamed (mv) /usr/local/mysql/data to /usr/local/mysql/data_save
3. Using cp -p -r I copied the backed up data directory to /usr/local/mysql/data

When trying to start mysql using
sudo bash
/usr/local/mysql/bin/mysqld_safe
the db fails to start.

If I rename the data directory to data_from_backup and the data_save directory to data,
the db starts as it should.

The failed startup produces the following error:
091023 12:41:54 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
091023 12:41:54 mysqld_safe mysqld from pid file /usr/local/mysql/data/andy-nicastros-imac.local.pid ended

If I do a directory listing on the data directory that allows mysql to start (or the data_save directory) it looks like this:
-rw-rw---- 1 _mysql wheel 19071 23 Oct 12:49 andy-nicastros-imac.local.err
drwx------ 6 _mysql wheel 204 22 Oct 13:23 gfr
-rw-rw---- 1 _mysql wheel 5242880 23 Oct 12:49 ib_logfile0
-rw-rw---- 1 _mysql wheel 5242880 21 Oct 21:01 ib_logfile1
-rw-rw---- 1 _mysql wheel 10485760 23 Oct 12:49 ibdata1
drwxr-x--- 71 _mysql wheel 2414 21 Oct 20:50 mysql
drwxr-x--- 2 _mysql wheel 68 4 Sep 21:18 test
Note that there is no @ at the end of the permissions, so I assume its presence in the restored backup (see the questions above) is the problem.

Mac OS X 10.6.1 (Snow Leopard)
mysql 5.1 installed from a dmg.

Thanks for your help.
Andynic
Reply Bookmark and Share

Smart Search

Find your solution!



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.

Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 09:20 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Powered by Cermak Technologies, Inc.