ansaurus

Question

Answer 1

A:

  head -40 backup20-Apr-2010-07-32.sql |
  grep 'CHANGE MASTER TO ' |
  perl -lpe "s/-- CHANGE MASTER TO/CHANGE MASTER TO MASTER_HOST='111.222.333.444', MASTER_USER='slave_user', MASTER_PASSWORD='slave_user',/"

Chris Dolan 2010-04-20 05:38:38

Answer 2

A:

head -40 ORS20-Apr-2010-07-32.sql | grep 'CHANGE MASTER TO ' | sed 's/CHANGE MASTER TO/CHANGE MASTER TO MASTER_HOST='111.222.333.444', MASTER_USER='slave_user', MASTER_PASSWORD='slave_user'/g' | sed 's/^--//g'

Is it the correct way to do this?

shantanuo 2010-04-20 05:45:12

The problem is that the single inverted comma is not preserved. # correct # MASTER_HOST='111.222.333.444' #result that I am getting is # MASTER_HOST=111.222.333.444

shantanuo 2010-04-20 06:26:51

Use double quotes for the outer quotes: `echo "abc"|sed "s/b/'/"` or quote and escape the single quote: `echo "abc"|sed 's/b/'\''/'`

Dennis Williamson 2010-04-20 07:22:02

Thanks a lot. double quotes, I will try to remember.

shantanuo 2010-04-20 11:20:34

Answer 3

A:

#!/bin/bash

s="MASTER_HOST='111.222.333.444', MASTER_USER='slave_user',"
awk -vs="$s" ' /-- CHANGE MASTER TO/{
  gsub("-- CHANGE MASTER TO","CHANGE MASTER TO "s)
}1 ' file >temp
mv temp file

ghostdog74 2010-04-20 06:13:28

ansaurus

tags:

views:

answers:

replace the line to add some text

related questions