BACKUP TABLE - file rights
Posted: Thu Jun 26, 2003 11:12 am
Hi,
Doing a backup of db tables under mysql using
$sql = '
BACKUP TABLE
test_table
TO
"/backup"
';
give the backup files the rights of the mysql server. I my environement this is:
user: mysql
group: daemon
If the apache isn't a member of the "daemon" group, php can not do some work on this files, ex.: file compression.
Question:
Is this the case, that the mysql and the apache server where members of the same group in most server environements?
Thanks,
Armand
Doing a backup of db tables under mysql using
$sql = '
BACKUP TABLE
test_table
TO
"/backup"
';
give the backup files the rights of the mysql server. I my environement this is:
user: mysql
group: daemon
If the apache isn't a member of the "daemon" group, php can not do some work on this files, ex.: file compression.
Question:
Is this the case, that the mysql and the apache server where members of the same group in most server environements?
Thanks,
Armand