There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming google gpu hard drive hardware hdmi internet laptop malware memory monitor motherboard netgear network printer problem ram registry repair router security slow software sound trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit 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.

Reply  
Thread Tools
andynic's Avatar
Computer Specs
Member with 122 posts.
 
Join Date: May 2007
Location: Amsterdam
Experience: Beginner
23-Oct-2009, 10: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

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




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



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 02:39 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.