transfer files created on last day of month to ftp server

Habitual · 11-28-2015, 02:49 AM

Quote:

Originally Posted by hruday

td=$(echo emt_bus-$(date --date "-0 month" +01-m-%y).sql)

Missing an "%" delimiter:

Code:

td=$(echo emt_bus-$(date --date "-0 month" +01-%m-%y).sql)

hruday · 11-29-2015, 08:57 AM

Quote:

Originally Posted by berndbausch

Use cp -v (verbose).
What happens if you enter the exact same cp command manually?

nothing is happening. its not copying the file.

hruday · 11-29-2015, 09:22 AM

Quote:

Originally Posted by Habitual

Missing an "" delimiter:

Code:

td=$(echo emt_bus-$(date --date "-0 month" +01-%m-%y).sql)

yes i looked into that earlier mistake and changed it. still its not working

i tried with following commands at prompt

find ./* -type f -name "hri-01*" -exec ls {} \; ---> its working.!

but

find ./* -type f -name "hri-$(date --date "-0 month" +01-%m-%y).sql.zip" -exec ls {} \; ---> this didn't work as expected.

find ./* -type f -name "echo $(hri-$(date --date "-0 month" +01-%m-%y).sql.zip)" -exec ls {} \; --> this also didn't work

berndbausch · 11-29-2015, 06:24 PM

This string:

Code:

"hri-$(date --date "-0 month" +01-m-y).sql.zip"

expands to this on my system:

Code:

hri-01-m-y.sql.zip

So, it won't work.

Habitual · 11-29-2015, 08:26 PM

Quote:

Originally Posted by hruday

yes i looked into that earlier mistake and changed it. still its not working

i tried with following commands at prompt

find ./* -type f -name "hri-01*" -exec ls {} \; ---> its working.!

but

find ./* -type f -name "hri-$(date --date "-0 month" +01-m-y).sql.zip" -exec ls {} \; ---> this didn't work as expected.

find ./* -type f -name "echo $(hri-$(date --date "-0 month" +01-m-%y).sql.zip)" -exec ls {} \; --> this also didn't work

echo is your friend.

Code:

echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip

spits out
hri-01-11-15.sql.zip

touch is your friend.

Code:

touch  hri-$(date --date "-0 month" +01-%m-%y).sql.zip

hri-01-11-15.sql.zip

find is your friend:

Code:

find   hri-$(date --date "-0 month" +01-%m-%y).sql.zip

hri-01-11-15.sql.zip

Code:

find -name $(echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip)

and

Code:

find -name $(echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip) -exec ls {} \;

both work here.
both show
./hri-01-11-15.sql.zip

Go back to here. and use the 3 commands I gave you.

TARGET=
touch $TARGET
find

build from there.

What's not clear to me is why you insist on useless searching

Code:

find ./*

when you know where the files are at?

Code:

find /home/applications/ets/backup/ets_old_sqldumps/ -iname hri$(date -d "$(date -d month +Y-%m-1) -1 day" "+%m-%d-%Y").sql

+Y is missing an "%" operand, again.

http://www.cyberciti.biz/faq/howto-f...files-by-date/

hruday · 12-01-2015, 06:10 AM

Quote:

Originally Posted by Habitual

echo is your friend.

Code:

echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip

spits out
hri-01-11-15.sql.zip

touch is your friend.

Code:

touch  hri-$(date --date "-0 month" +01-%m-%y).sql.zip

hri-01-11-15.sql.zip

find is your friend:

Code:

find   hri-$(date --date "-0 month" +01-%m-%y).sql.zip

hri-01-11-15.sql.zip

Code:

find -name $(echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip)

and

Code:

find -name $(echo hri-$(date --date "-0 month" +01-%m-%y).sql.zip) -exec ls {} \;

both work here.
both show
./hri-01-11-15.sql.zip

Go back to here. and use the 3 commands I gave you.

TARGET=
touch $TARGET
find

build from there.

What's not clear to me is why you insist on useless searching

Code:

find ./*

when you know where the files are at?

Code:

find /home/applications/ets/backup/ets_old_sqldumps/ -iname hri$(date -d "$(date -d month +Y-%m-1) -1 day" "+%m-%d-%Y").sql

+Y is missing an "%" operand, again.

http://www.cyberciti.biz/faq/howto-f...files-by-date/

you are using "touch" command. it'll create a file. i don't want to create any file. i just want to find the files in a directory which match the pattern.

Habitual · 12-01-2015, 08:38 AM

Quote:

Originally Posted by hruday

i don't want to create any file.

Who cares? You have 29 days to remove the 0 byte file.
How are you going to find what doesn't exist yet?
It is going to be overwritten anyway, right? By the backup program or utility/script?
Or is that written by someone else as well?

using the touch command today allows you to create the file in advance so you can test your find command today with it.
You're in luck, it's a new calendar month, so this becomes easier.

Your solution is

Code:

#!/bin/bash
TARGET=hri-$(date -d "$(date -d month +Y-%m-1) -1 day" "+%m-%d-%Y").sql
find /home/applications/ets/backup/ets_old_sqldumps/ -name "$TARGET"
#EOF

YOU could simply add a touch and rm in bash now to that to test my work.

Code:

TARGET=hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
# Create file for testing.
touch /home/applications/ets/backup/ets_old_sqldumps/hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
OR...
touch /home/applications/ets/backup/ets_old_sqldumps/$TARGET
find /home/applications/ets/backup/ets_old_sqldumps/ -name "$TARGET"
# Remove file after testing.
rm /home/applications/ets/backup/ets_old_sqldumps/hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
or
rm /home/applications/ets/backup/ets_old_sqldumps/$TARGET

Have a Great Day.

hruday · 12-02-2015, 07:09 AM

Quote:

Originally Posted by Habitual

Who cares? You have 29 days to remove the 0 byte file.
How are you going to find what doesn't exist yet?
It is going to be overwritten anyway, right? By the backup program or utility/script?
Or is that written by someone else as well?

using the touch command today allows you to create the file in advance so you can test your find command today with it.
You're in luck, it's a new calendar month, so this becomes easier.

Your solution is

Code:

#!/bin/bash
TARGET=hri-$(date -d "$(date -d month +Y-%m-1) -1 day" "+%m-%d-%Y").sql
find /home/applications/ets/backup/ets_old_sqldumps/ -name "$TARGET"
#EOF

YOU could simply add a touch and rm in bash now to that to test my work.

Code:

TARGET=hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
# Create file for testing.
touch /home/applications/ets/backup/ets_old_sqldumps/hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
OR...
touch /home/applications/ets/backup/ets_old_sqldumps/$TARGET
find /home/applications/ets/backup/ets_old_sqldumps/ -name "$TARGET"
# Remove file after testing.
rm /home/applications/ets/backup/ets_old_sqldumps/hri-$(date -d "$(date -d month +%Y-%m-1) -1 day" "+%m-%d-%Y").sql
or
rm /home/applications/ets/backup/ets_old_sqldumps/$TARGET

Have a Great Day.

yeah i found my error and corrected it. i managed to copy the files to other directory. now how can i upload this file to ftp server

hruday · 12-03-2015, 02:00 AM

Quote:

Originally Posted by hruday

yeah i found my error and corrected it. i managed to copy the files to other directory. now how can i upload this file to ftp server

#!/bin/bash

HOST='ipaddress'
USER='username'
PASSWD='pwd'
cd ~/exp
FILE="f*.log" -----> trying to copy files starting with letter "f" with .log extension
REMOTEPATH='~/backup'

ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
cd $REMOTEPATH
put $FILE
quit
END_SCRIPT
exit 0

in "exp" directory i have created around 5 files like f1.log, f2.log, f3.log, f4.log, f5.log
but iam able to copy only one file f1.log

how to copy all files?

berndbausch · 12-03-2015, 02:18 AM

Quote:

Originally Posted by hruday

#!/bin/bash

HOST='ipaddress'
USER='username'
PASSWD='pwd'
cd ~/exp
FILE="f*.log" -----> trying to copy files starting with letter "f" with .log extension
REMOTEPATH='~/backup'

ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
cd $REMOTEPATH
put $FILE
quit
END_SCRIPT
exit 0

in "exp" directory i have created around 5 files like f1.log, f2.log, f3.log, f4.log, f5.log
but iam able to copy only one file f1.log

how to copy all files?

You need mput and prompt.
Or instead of prompt, use the ftp -i option.

Habitual · 12-03-2015, 06:01 AM

Quote:

Originally Posted by hruday

yeah i found my error and corrected it.

You're welcome.

Habitual · 12-03-2015, 06:03 AM

Quote:

Originally Posted by berndbausch

You need mput and prompt.
Or instead of prompt, use the ftp -i option.

Nooooooo, he needs to start a new thread.

berndbausch · 12-03-2015, 06:14 AM

I thought the thread title was sufficiently broad

Habitual · 12-03-2015, 06:20 AM

Quote:

Originally Posted by berndbausch

I thought the thread title was sufficiently broad

OK. Where's the coffee?

I'm gonna suggest sftp for easier automation.
That's my story and I'm sticking to it!

hruday · 12-03-2015, 11:22 PM

Quote:

Originally Posted by berndbausch

You need mput and prompt.
Or instead of prompt, use the ftp -i option.

ok thanx @brendbausch and @habitual

so how can i put these two tasks together?

#!/bin/bash
src=/root/exp

df=$(date --date "-`date +%d` days +1 month" +%d-%m-%y)
tf="hri-$df.sql"

find $src/* -type f -name "$tf" -exec ls {} \;

if [$? -eq 0] then

can i write the ftp script here to transfer the above file?
or what is the best way?