MySQL ODBC Connector - File Permissions On Database Files

Author

File Permissions On Database Files

Hal Vaughan

2006-01-02, 8:23 pm

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
database files. I'd much rather do it this way than to create files with
mysqldump. Whenever MySQL creates a new database, the file is owned by the
user mysql, and has limited read and write permissions (this is on Linux,
btw). It would be a HUGE help if I could make sure every time MySQL creates
any files, it creates them with at least group if not all read access for
backup purposes.

Is there a simple way to do this?

Thanks!

Hal

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Logan, David

2006-01-02, 8:23 pm

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...-variables.html).

Regards

---------------------------------------------------------------
********** _/ ********** David Logan=20
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com
**** _/ _/ _/ _/ **** 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 & #91;mailto:hal@thres
holddigital.com]=20
Sent: Tuesday, 3 January 2006 7:54 AM
To: mysql@lists.mysql.com
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@hp.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links