Why script wont read data from file ?

[JackTheRussel]

Hi all.

I have backup script which backup my database in every day.

#!/bin/sh

datetime=`date '+%y-%m-%d-%H-%M-%S'`
mysqldump -u root -pPassword database | gzip > /home/user/backups/backup-$datetime.sql.gz

And its works perfectly.

Now I would like to increase security and I wrote username and password information in file named security.ini
it locates in address /home/user/security.ini

seurity.ini

[DATABASE]
db_host= localhost
db_name=database
db_username=root
db_password=Password

How my script can read these informations ? I try like this, but
its not working.

#!/bin/sh

$security=`'/home/user/security.ini'`;
datetime=`date '+%y-%m-%d-%H-%M-%S'`

mysqldump -u $security{'DATABASE'}{'db_username'} -p$security{'DATABASE'}{'password'} database | gzip > /home/user/backups/backup-$datetime.sql.gz

I just get error: Got error: 1045: Access denied for user '{DATABASE}'@'localhost' (using password: YES) when trying to connect

 

[KevinADC]

wrong forum mate, this is the perl forum, you want the appropriate shell scripting forum.

- Kevin, perl coder unexceptional!

 

[max1x]

In shell it would be like this

security=`cat /path/to/file`;
echo "$security"

for Perl;

open FILE,"< /path/to/file" or warn "$!\n";
while (<FILE>) {
do what you need to do here;
}
close FILE;