Bash script doesnt work
Hello, i'm trying to make a bash script which backs-up all mysql databases with their own name and todays date.I got this so far:
Code:
#!/bin/bash
tijd=`date +%A`
/usr/local/psa/mysql/bin/mysqlshow -u admin --password=pass | grep '^|'|grep -v
Databases | cut -f 2 -d ' ' | awk '{ print "/usr/local/psa/mysql/bin/mysqldump -u
admin --password=pass " $1 " > " $tijd "-" $1 ".sql" }' | sh
Now it does work except that the filename wont become (ie) "Sunday-databasename.sql" but instead "databasename-databasename.sql"
I have _NO_ clue why this isnt working...i also tried:
Code:
/usr/local/psa/mysql/bin/mysqlshow -u admin --password=pass | grep '^|'|grep -v
Databases | cut -f 2 -d ' ' | awk '{ print "/usr/local/psa/mysql/bin/mysqldump -u
admin --password=pass " $1 " > " `date +%A` "-" $1 ".sql" }' | sh
can anyone help me

