consider there is create table commands in a file for eg:
like the above block there are many blocks in the file, i mean many create table queries in the file.
i have two doubts which i need help in
1) what i need to do is separate out one create table block based on idetifier such as "create table" which is the start and "ENGINE=" as end and seperate it out and write to a file for processing (which i will be doing in a while loop so that every time a new create table overwrite in that particular file for processing).
2) if i have a string "CREATE TABLE `Blahblahblah`" in a variable how to extract `blahblahblah` and store it in a variable..?
i need a shell program to extract a substring from a main string..
for eg:- main string is madhu..
sub string is mad
o/p:- be mad.
try to solve this one (5 Replies)
i need a shell program,to extract a string from a main string.
main string is "madhu"
sub string is "mad"..means any word from the main string
please di this (1 Reply)
Hi, guys. I have one question:
I need to search for a string in a file, and then extract another string from the file and assign it to a variable.
For example:
the contents of the file (group) is below:
...
ftp:x:23:
mail:x:34
...
testing:x:2001
sales:x:2002
development:x:2003
...... (6 Replies)
attempting the hangman program. This was an optional assignment from the professor. I have completed the logical coding, debugging now.
##I have an array $wordString that initializes to a string of dashes
##reflecting the number of letters in $theWord
##every time the user enters a (valid)... (5 Replies)
Hi,
May i ask if someone share some command for extracting a string between 2 ref string in a txt file
My objective: i had a file with multiple lines and wants only to extract the string "watch?v=IbkAXOmEHpY" or "watch?v=<11 random character>", when i used "grep 'watch?=*' i got a results per... (4 Replies)
Hi ,
am getting output file, it sontains the below values.
./hawk_DOM1_FIRST_ENV
./hawk_DOM2_SECOND_ENV
./hawk_DOM3_THIRD_ENV
Now I need to grep the word "DOM1_FIRST_ENV","DOM2_SECOND_ENV"
like that.
I tired with cut -d "_". Its not working with any deleimiter.
Can you please help to... (3 Replies)
Need Assistance in shell programming... I have a huge file which has multiple stations and i wanted to search particular station and extract few lines from it and the rest is not needed
Bold letters are the stations . The whole file has multiple stations .
Below example i wanted to search... (4 Replies)
Hi Team
I have an huge xml where i need to search for a ceratin numbers. For example
2014-05-06 15:15:41,498 INFO WebContainer : 10 CommonServicesLogs - CleansingTriggerService.invokeCleansingService Entered PUBSUB NOTIFY MESSAGE () -
<?xml version="1.0" encoding="UTF-8"... (5 Replies)
Hello guys,
I have problem with hpux shell script. I have one big text file that contains like
SOH
bla bla bla
bla bla bla
ETX SOH
bla bla bla
ETX
SOH
bla bla bla
ETX
What I need to do is save first SOH*BLA into file1.txt, save second SOH*BLA into file2.txt and so on.... (17 Replies)
I have the logic below to look up for matches within the columns between the two files with awk.
In the if statement is where the string comparison is attempted with ==
The issue seems to be with the operands, as
1. when " '${SECTOR}' " -- double quote followed by single quote -- awk matches... (1 Reply)
Discussion started by: deadyetagain
1 Replies
LEARN ABOUT DEBIAN
mysqmail-postfix-logger
mysqmail-postfix-logger(8) System Manager's Manual mysqmail-postfix-logger(8)NAME
mysqmail-postfix-logger - logs smtp traffic to a mysql database
SYNOPSIS
mysqmail-postfix-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-postfix-logger reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
(configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to field of
the smtp traffic table.
mysqmail-postfix-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS smtp_logs (
id int(11) NOT NULL auto_increment,
newmsg_id bigint(20) default NULL,
bounce_qp int(11) default NULL,
bytes int(11) NOT NULL default '0',
sender_user varchar(128) NOT NULL default '',
sender_domain varchar(128) NOT NULL default '',
delivery_id bigint(20) default NULL,
delivery_user varchar(128) NOT NULL default '',
delivery_domain varchar(128) NOT NULL default '',
delivery_success enum('yes','no') NOT NULL default 'no',
time_stamp timestamp(14) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY bounce_qp (bounce_qp),
UNIQUE KEY newmsg_id (newmsg_id),
KEY sender_domain (sender_domain),
KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;
VERSION
This documentation describes mysqmail-postfix-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.
SEE ALSO syslog(3), logger(8)mysqmail-postfix-logger(8)