Mysql – autothesqlbackup – dumped files permissions

backupMySQLpermissionsroot

I'm using automysqlbackup, here is the default cron entry created

#!/bin/sh
test -x /usr/sbin/automysqlbackup && /usr/sbin/automysqlbackup

My files are stored here

/var/cache/automysqlbackup

I need to read them with my user but all the dumps are owned by root:root and 600

-rw------- 1 root root 945671 mars  12 06:49 my_2013-03-12.sql.gz
-rw------- 1 root root 951541 mars  13 06:32 my_2013-03-13.sql.gz
-rw------- 1 root root 956770 mars  14 06:31 my_2013-03-14.sql.gz
-rw------- 1 root root 961125 mars  15 06:53 my_2013-03-15.sql.gz
-rw------- 1 root root 969009 mars  17 06:38 my_2013-03-17.sql.gz
-rw------- 1 root root 969139 mars  18 06:38 my_2013-03-18.sql.gz

How can I configure automysqlbackup to use different owner and permissions ?

Best Answer

Alternatively, last time I checked automysqlbackup was plain bash so one could easily make a modified local copy....

On Ubuntu, default install for automysqlbackup

$ sudo nano /usr/sbin/automysqlbackup

Search for chmod (only one occurrence) and replace 600 by 640 for example

Related Topic