Search Results

and the reason for the behavior is....

I get the same value "chinchwad" for the following 3 statements.

echo "ABCDchinchwad18-Mar-2010-11.sql.zip" | sed -r 's/([A-Z]+)([a-z]+)(.*)/\2/'
echo "ABCDchinchwadII18-Mar-2010-11.sql.zip" |...

The following statement does work. But the second command does not work as expected.

ssh root@123.123.123.123 \\"mysqldump -h localhost -u root -pPassWord dbName -d | gzip -cf\\" | gunzip -c >...

#!/bin/sh
for dbName in `mysqlshow -uroot -pPassWord | awk '{print $2}'`
do
echo "$dbName" | egrep -v 'mysql|test|Databases|information_schema';
done

mysql -uroot -pPassWord --tee='/root/myquery.txt'

I do always use tee while accessing Mysql database. This helps me to check the output of a sql command when I can not browse the earlier pages...

# find /home/shantanu -name 'my_stops*' | xargs ls -lt | head -2

The command mentioned above will list the latest 2 files having my_stops in it's name. I want to keep these 2 files. But I want to...

The problem was resoved when I added the "s" in double quotes like this...

sed "s/$combined/$table/g"

Thanks a lot for that syntax. I requested the change and I am now getting the correct results.
I can not use the module because I have only the access_log text files. :)

I want to replace one line from my configuration file with the new settings.
The file Name: /etc/httpd/conf/httpd.conf

The following line should be replaced with the line mentioned below.
...

When I used double quotes, the grep statement translates without any quotes.

mysqldump --compact --add-drop-table -h192.168.150.80 -uroot -p somePass $combined | sed '/$combined/$table/g' | mysql $databaseThe sed part is not working from the above statement.
The variables...

I have changed the LogFormat of httpd
But the %t display the date in the following format.

[31/Aug/2009:11:56:59 +0530]


MySQL does not understand this format and needs to be formatted...

Hi,
My access log looks like this...

192.168.50.184 - - [31/Aug/2009:11:56:59 +0530] "GET /ATIM_LATEST/ABC/ HTTP/1.1" 200 522 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.13)...

I have a site with a few hundred pages.
I want to know which pages load in more than 6 seconds.
Is it possible? Is there any shell script or tool for this purpose?

The shell mentioned below will show a warning if the page takes more than 6 seconds to load.
The problem is that myduration variable is not an integer. How do I convert it to integer?


...

I tried the

tail -f my-slow.log | grep 'someWord' > /root/myfile.txt

This does not work.

I tried --tee as well and that too does not work. Any help?

Your code did work.
Thanks.

Now I get the following error:

highprocess.sh: line 11: [[: |: syntax error: operand expected (error token is "|")

The following script should kill all the queries taking more than say 600 seconds. But it seems that it is killing queries taking more than 6 seconds.

>> sh myscript.sh 600

#!/bin/bash
#kill...

I tried both the commands and the only difference is the missing ';' from the last line while using awk

$ sed 's/DEFAULT CHARSET=[^ \;]*//;s/COLLATE=[^ \;]*//;s/AUTO_INCREMENT=[^...

Thanks chipcmc.
But as shown in your own example, the CHARSET=latin1; is still there on line 3. The lines 1 and 2 are OK.

I want to download xyz.php to abc.php and save it in the directory mentioned.

wget -directory-prefix=/usr/local/apache/htdocs/ http://somesite.com/xyz.phpThis command will save the file as xyz.php...

Thanks. But it it does not work when the line does not has the auto_increment clause. In the example, the third line is wrong. There should have been no "Default charset".

>> cat test.txt
)...

A typical line looks like this...

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=129 COMMENT='Compiled E-Mails';I want to remove DEFAULT CHARSET= and COLLATE= after...

I have a file with one or two lengthy lines like....
masterUserID = 'S' OR masterUserID = 'S' OR masterUserID = 'S' (many many more times)

How do I display only the first few hundred characters...