From: Date: January 2 2006 11:01pm
Subject: RE: File Permissions On Database Files
List-Archive: http://lists.mysql.com/mysql/193431
Message-Id: <2E5067E0651BCD4FB7133D3F8B854FEB09B78B@NWIEXC01.asiapacific.cpqcorp.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Hal,

You might like to try setting the umask for the mysql user. I would
think the server would abide by the OS rules for permission settings.
You may be able to set the UMASK_DIR environment variable (as described
here http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html).

Regards


---------------------------------------------------------------
********** _/     **********  David Logan=20
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
*****        _/       ******   =20
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia=20
i    n    v    e    n    t                                  =20
---------------------------------------------------------------

-----Original Message-----
From: Hal Vaughan [mailto:hal@stripped]=20
Sent: Tuesday, 3 January 2006 7:54 AM
To: mysql@stripped
Subject: File Permissions On Database Files

My MySQL databases are stored in a directory that is with the rest of my

project.  I am using rsync to back up the entire project, including the=20
database files.  I'd much rather do it this way than to create files
with=20
mysqldump.  Whenever MySQL creates a new database, the file is owned by
the=20
user mysql, and has limited read and write permissions (this is on
Linux,=20
btw).  It would be a HUGE help if I could make sure every time MySQL
creates=20
any files, it creates them with at least group if not all read access
for=20
backup purposes.

Is there a simple way to do this?=20

Thanks!

Hal

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Ddavid.logan@stripped