Search Results

Result Should be into single line

# create temporary table `temp4277`(key(waybill_no)) select waybill_no,concat_ws('',card_type,card_series_no) cardinfo from...

I have code as below

# create temporary table `temp4277`(key(waybill_no))
select waybill_no,concat_ws('',card_type,card_series_no) cardinfo
...

I have query to replace the first word in line using below code but its replace the middle word too

sed -i 's/load /# LOAD/' /tmp/check.sql

Query 1 :

UPDATE accheadcon_data_last_upload SET...

using in single script is good logic bit a complex as you have to keep history of Last two execution

I have query apply crontab entry that the script executes as below


day hours (before 8:00 PM and after 7:00 AM) execute every 5 min

in Night hours (after 8:00 PM to 7:00 AM) executes every...

I want the tomcat to restart when java goes 100% cpu utilize and remain on this , Get pid kill and start tomcat .

top | grep java

We can get pid and cpu utilize , But how can we do on run...

thanks

this is resolve by installing MySQL-shared-advanced-5.6.14-1.el6.x86_64 pkg

While trying to install sybench giving below error

[root@localhost ~]# rpm -ivh sysbench-0.5-3.el6_.x86_64.rpm
error: Failed dependencies:
libmysqlclient.so.18()(64bit) is needed by...

Yes there will be only two lines in log.log
when the error comes It will stop restoration

we can do search a word before colon in log.log

There are some sql commands

REPLACE INTO `bus_stop`...

I have a file log.log

cat log.log
Warning: Using a password on the command line interface can be insecure.
ERROR 1136 (21S01) at line 65: Column count doesn't match value count at row 1

The...

Hi ,

My Script work as below

1-
On server 1

execute script1.sh ,

through this script one parameter file is generated as file.txt this is to transfer on server 2

2-
After reaching on...

awk works for me

Thanks

Hi ,

I am passing date parameter through file

my shell script testing.sh is


#set -x
#set -v
asd=$1
asd1=$2
echo $asd
echo $asd1


Passing parameter as below

sh testing.sh `cat...

sshd is installed and working fine

/etc/init.d/sshd status
openssh-daemon (pid 3486) is running


Thanks This is resolved

I Reset to default the Virtual network than it works fine and able...

I am using ifconfig to get ip address and used /etc/init.d/iptables stop

and on windows stopped firewall still not able to connect from windows putty to vmware

Hi ,

I have installed Centos 6.5 in my VMWare on windows 7 , My Internet is running fine on both VMWare OS and windows 7 .

When I am trying to connect from putty on my window to Vimware Linux...

Hi,

var=QSB SBD SDN SGJ SJP SKB SKD SLP SML SNB SRE SRG STP TAJ UMP UNO VKS VND VNS WAH ZRR

I have to put *.sql after every word

What I did

echo $var>/root/file1.sql
sed -i 's/ /*.sql...

It looks fine now . I dropped the user and recreated then looks fine for me

Don't know what was the problem . Overall issue is rectified ..

when I created user and use su - username then its prompt come in bash mode

[root@nn ~]# su - uusr
-bash-4.1$


What is this bash mode .

this also show


-bash-4.1$ touch filename...

I have a file and I want to remove quotes from the word " ` " through sed command but unable to remove
I am using below command

sed s/"`XYZ`"/"ZXY"/g file1.txt > file2.txt

But this is not...

Thanks This works for me

I Have attached the file as dynamic.txt

In This there are

# at 4
# at 98
# at 211

Want to replace with as below for all
insert into test.counter(id) values(4);
insert into...

Thanks for reply

What I did


$ sed s/'# at '/'insert into test.dummy(id) values ("'/ dynamic

COMMIT
insert into test.dummy(id) values ("2345

insert into test.dummy(id) values ("2346...

Jotne Its works But My Concern is

Original file output

COMMIT
# at 2345

# at 2346
COMMIT
# at 2478
dummy
# at 2489


and by your command


$ awk '/# at/ {print "insert into...

Thanks for reply

This command works in file but the remaining data does not show between "# at"
That I had not mentioned

I tried below


grep "# at" dynamic | sed s/'# at '/'insert into...