AWK find and replace URL

blueAlien · 09-28-2010, 03:28 PM

I'm creating a bash script that will allow for me to move my database between dev, stage and prod servers. I already have a script that backs up the database to a compressed file, which is what I am using for the find and replace. My only problem is that I can't figure out how to escape the url I am searching for.

Code:

strFrom="dev\.domain\.com"
strTo="stage\.domain\.com"

gunzip < $1 | awk 's/$strFrom/$strTo/g' | gzip -c > /srv/admin/database-$date.sql.gz

Returns:

Code:

awk: s/dev\.domain\.com/stage\.domain\.com/g
awk:      ^ backslash not last character on line

Cany anyone please tell me where I am going wrong.

Thanks!

murugesan · 09-29-2010, 01:07 AM

You need to use sed instead of using awk for the format you mentioned
Use

Code:

sed 's/'"$strFrom"'/'"$strTo"'/g'

druuna · 09-29-2010, 01:33 AM

Hi,

The mixing of quotes isn't needed:
sed "s/$strFrom/$strTo/"

You also do not need to escape the dots in the replacement string (strTo="stage.domain.com").

Hope this helps.

blueAlien · 09-29-2010, 11:37 AM

Just wanted to say thanks for the help! The following code works like a charm.

Code:

strFrom="dev.domain.com"
strTo="stage.domain.com"

gunzip < $1 | awk "s/$strFrom/$strTo/g" | gzip -c > /srv/admin/database-$date.sql.gz

druuna · 09-29-2010, 12:34 PM

Hi,

Quote:

Originally Posted by blueAlien

The following code works like a charm.

Code:

strFrom="dev.domain.com"
strTo="stage.domain.com"

gunzip < $1 | awk "s/$strFrom/$strTo/g" | gzip -c > /srv/admin/database-$date.sql.gz

This works??? I really doubt that. This is not a legal command: awk "s/$strFrom/$strTo/g"

I hope you meant: sed "s/$strFrom/$strTo/g"

murugesan · 09-29-2010, 09:07 PM

Quote:

Originally Posted by blueAlien

Just wanted to say thanks for the help! The following code works like a charm.

Code:

strFrom="dev.domain.com"
strTo="stage.domain.com"

gunzip < $1 | awk "s/$strFrom/$strTo/g" | gzip -c > /srv/admin/database-$date.sql.gz

If you could have used awk instead of using sed,
check the file size

Code:

gunzip /srv/admin/database-......sql.gz
ls -l /srv/admin/database-......sql

to be of zero bytes.