Strange error in bash script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Strange error in bash script
# 1  
Old 01-25-2010
Strange error in bash script

Howdy all, I have a scritp that does a sqldump. But for some goofy reason, a certain part of it behaves uber strange.
It does a daily dump of my sql, according to parameters I enter in hardcode.

The script is:
Code:
#!/bin/bash

APP_NAME="app_com_site"
wikiname="wiki_com_site"

BACKUP_DIR="/home/app/backup/DAILY"      

DB_NAME="app_com_db"
DB_USER="app_com_admi"
DB_PASS="notgonnatellyou"

# Number of Backup files to save
FILES_TO_KEEP=2

##################
# END OF OPTIONS #
##################

timestamp=`date +%Y-%m-%d`

dbdump="$BACKUP_DIR/$APP_NAME-$timestamp.sql.gz"
filedump="$BACKUP_DIR/$APP_NAME-$timestamp.files.tgz"

#Create a MySQL dump of the database
echo "creating database dump:" $dbdump
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B | gzip > test.gz
#mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B  | gzip >  "$dbdump"

The thing is that the commented line is NOT creating the file, but the uncommented one IS working. I do want this to be dynamically.

I couldn't find any errors. can anyone have a clue please?
# 2  
Old 01-25-2010
Hello ,

Add 'set -x' to the beginning of the script

Regards,
Gaurav.
# 3  
Old 01-25-2010
Try to use braces around the variable names on these lines:

Code:
dbdump="$BACKUP_DIR/$APP_NAME-${timestamp}.sql.gz"
filedump="$BACKUP_DIR/$APP_NAME-${timestamp}.files.tgz"

# 4  
Old 01-25-2010
Thanks for your ideas

set -x did gave me the output, but no apparent error what so ever
Code:
+ . ../SCRIPTS/test.sh
++ set -x
++ APP_NAME=app_com_site
++ wikiname=app_com_site
++ BACKUP_DIR=/home/app/backup/DAILY
++ DB_NAME=app_com_db
++ DB_USER=app_com_admi
++ DB_PASS=ermno
++ FILES_TO_KEEP=2
+++ date +%Y-%m-%d
++ timestamp=2010-01-25
++ dbdump=/home/app/backup/DAILY/app_com_site-2010-01-25.sql.gz
++ filedump=/home/app/backup/DAILY/app_com_site-2010-01-25.files.tgz
++ echo 'creating database dump:' /home/app/backup/DAILY/app_com_site-2010-01-25.sql.gz
creating database dump: /home/optitex/backup/DAILY/app_com_site-2010-01-25.sql.gz
++ gzip
++ mysqldump --database app_com_db -u appx_com_admi -permpass --add-drop-table -B
++ pushd /home/app/public_html
~/public_html ~/backup/DAILY
++ popd
~/backup/DAILY
++ echo 'Done!'
Done!

Adding the brackets to my source code, didn't change the result.

I started to think that it's permission issue.
The target folder is 755, and owned by the same user that is running the script (other user that runs the cron job is root - at night run). so I don't think it's permissions.

Why is it that if I put a direct file name it works, but using a parameter it doesn't?

---------- Post updated at 03:09 PM ---------- Previous update was at 02:42 PM ----------

I had another try, to see if I can make this work in a different way:

These two lines are working, the name of the output sql file and gz file are hardcoded.
Code:
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B > "$BACKUP_DIR"/dump.sql

gzip "$BACKUP_DIR"/dump.sql


These 2 lines are NOT working
Code:
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B > "$BACKUP_DIR"/"$APP_NAME-$timestamp.sql.gz"

gzip "$BACKUP_DIR"/"$APP_NAME-$timestamp.sql.gz"

My guess is that something is weird with the timestamp naming? how can that be?
# 5  
Old 01-25-2010
Quote:
Originally Posted by saariko
Howdy all, I have a scritp that does a sqldump. But for some goofy reason, a certain part of it behaves uber strange.
It does a daily dump of my sql, according to parameters I enter in hardcode.

The script is:
Code:
#!/bin/bash

APP_NAME="app_com_site"
wikiname="wiki_com_site"

BACKUP_DIR="/home/app/backup/DAILY"      

DB_NAME="app_com_db"
DB_USER="app_com_admi"
DB_PASS="notgonnatellyou"

# Number of Backup files to save
FILES_TO_KEEP=2

##################
# END OF OPTIONS #
##################

timestamp=`date +%Y-%m-%d`

dbdump="$BACKUP_DIR/$APP_NAME-$timestamp.sql.gz"
filedump="$BACKUP_DIR/$APP_NAME-$timestamp.files.tgz"

#Create a MySQL dump of the database
echo "creating database dump:" $dbdump
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B | gzip > test.gz
#mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B  | gzip >  "$dbdump"

The thing is that the commented line is NOT creating the file, but the uncommented one IS working. I do want this to be dynamically.

I couldn't find any errors. can anyone have a clue please?
Hi try this ,
Code:
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B  | gzip >  "${dbdump}.gz"

Regards,
Gaurav.
# 6  
Old 01-25-2010
Also make sure you are able to create file in /home/app/backup/DAILY/ folder
# 7  
Old 01-25-2010
Thanks all for your comments.

I had to try and see where the problem, so I creeated a new var: sqlfile="/home/app/backup/DAILY/dump.sql"
and added that to the script.

Code:
sqlfile="/home/app/backup/DAILY/file.sql"

#Create a MySQL dump of the database
echo "creating database dump:" $dbdump
#mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B | gzip > "$BACKUP_DIR"/"$APP_NAME-$timestamp.sql.gz"
mysqldump --database $DB_NAME -u $DB_USER -p$DB_PASS --add-drop-table -B  | gzip >  "${sqlfile}.gz"

amazingly everything works (@xoops = that answers te Q if I can write to DAILY folder, thanks)

So now I am left with the puzzle, why when I use the following:
Code:
dbdump="$BACKUP_DIR/$APP_NAME-${timestamp}.sql"

the script is not working.

printing out the value of $dbdump gives the correct folder. but nothing is saved there, that is weird with a capital 'W' !!!

---------- Post updated at 03:30 PM ---------- Previous update was at 03:27 PM ----------

The command:
Code:
echo "creating database dump:"$dbdump":"

outputs the following:
Code:
creating database dump:/home/app/backup/DAILY/app_com_site-2010-01-25.sql:

but again, there is nothing there.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Ubuntu 16 Bash strange output

Hello, I work in Ubuntu 16.04, I am new to Bash and something is wrong with my script, please help. I have a few hundreds of subjects data (like subj003.nii.gz, subj012.nii.gz etc. up to subj567.nii.gz) in a directory /usr/afewmoredirectories/subjects. I may run for each subject a command... (5 Replies)
Discussion started by: lim-lim
5 Replies

3. Shell Programming and Scripting

Bash - concatenate string - strange variable scoping

Hello, I am trying to concatenate a string in a bash script like this: runCmd="docker run -e \"IMAGE_NAME=$IMAGE_NAME\" " env | grep "$ENV_SUFFIX" | while read line; do envCmd="-e \"${line}\" " runCmd=$runCmd$envCmd echo $runCmd # here concatenation works fine done echo... (3 Replies)
Discussion started by: czabak
3 Replies

4. Shell Programming and Scripting

Strange fork error while running script

more run.sh !/bin/bash input="data.txt" while IFS= read -r var do startdir="/web/logs" searchterm=$(echo $var | awk -F'=' '{print $1}') replaceterm=$(echo $var | awk -F'=' '{print $2}') find "$startdir" -type f -exec grep -l "$searchterm" {} + | while read file do if sed -e... (1 Reply)
Discussion started by: mohtashims
1 Replies

5. Shell Programming and Scripting

Strange suppression of output with bash and cygwin

Hi, although I am not expert in bash, so please forgive me if this is silly, I think that this is strange: I have this command: find . -type f -print0 |xargs -0 grep -i -e 'some rexp' and it works fine. But when I create a bash script (on cygwin) to run this command, there is no output !!!... (3 Replies)
Discussion started by: Niki999
3 Replies

6. Shell Programming and Scripting

BASH script outputting strange file formats

Hi I am very new to using BASH, but I have a problem with a piece of script that I have been working on. Basically the script goes through a mailbox file looking at particular aspects of the file, for example how many spamwords there are email address etc. It does this pretty well except for an... (13 Replies)
Discussion started by: 9aza
13 Replies

7. Shell Programming and Scripting

Getting error on for loop - bash script

Hi, I am working on bash script after a long time. I am getting error near done statement while running a for loop snippet. The error says "Syntax error near unexpcted token 'done'" please suggest what could be wrong. here is the snippet elements=${#option_arr} //an array of values... (1 Reply)
Discussion started by: arundhati_s
1 Replies

8. Shell Programming and Scripting

Help in error seen in the Bash script

Hi, I am currently encounter an error of:- ./max.bash: line 45: then max=0 else max=$maximum It seems that it does not allow max to assigned with floating numbers. Please help. Thanks. (2 Replies)
Discussion started by: ahjiefreak
2 Replies

9. Shell Programming and Scripting

Bash Script error?

I'm currently playing with the below script; #!/bin/sh for d in /export/home/siward/staff/pasit/jamiecr/scripts/first-file.sh \ /export/home/siward/staff/pasit/jamiecr/scripts/second-file.sh \ /export/home/siward/staff/pasit/jamiecr/scripts/third-file.sh \ ... (13 Replies)
Discussion started by: JayC89
13 Replies

10. Shell Programming and Scripting

error in bash script 'if' loop

SEND_MESSAGE=test echo $SEND_MESSAGE if then echo `date` > update_dt_ccaps.lst echo "The file transfer failed" >> update_dt_ccaps.lst SEND_MESSAGE=false fi The above code is showing error in bash shell as : ./test: line 5: [: test: integer expression expected ... (2 Replies)
Discussion started by: DILEEP410
2 Replies
Login or Register to Ask a Question