11-06-2008
remove text from string
I use the following command to know the create table structure.
mysqldump myDBName myTBName -d --compact
And I get the following output...
CREATE TABLE `tblThreads` (
`threadID` smallint(4) unsigned zerofill NOT NULL auto_increment,
`threadTitle` varchar(255) NOT NULL default '',
PRIMARY KEY (`threadID`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=latin1 COMMENT='Forum threads';
I want to remove everything after AUTO_INCREMENT till the end of that line. But I want to retain the last semicolon ;
The engine can be MyISAM or InnoDB or Memory and so on. something like...
mysqldump myDBName myTBName -d --compact | grep --keep engine --remove others
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to append string "Hi" to the beginning of the lines containing some specific string. How can I achieve that?
Please help.
Malay (1 Reply)
Discussion started by: malaymaru
1 Replies
2. Shell Programming and Scripting
Hi
I have been struggling with a script for removing duplicate messages from a shared mailbox.
I would like to search for duplicate messages based on the “Message-ID” string within the messages files.
I have managed to find the duplicate “Message-ID” strings and (if I would like) delete... (1 Reply)
Discussion started by: spangberg
1 Replies
3. Shell Programming and Scripting
Hello Folks..
I need your help ..
here the example of my problem..i know its easy..i don't all the commands in unix to do this especiallly sed...here my string..
dwc2_dfg_ajja_dfhhj_vw_dec2_dfgh_dwq
desired output is..
dwc2_dfg_ajja_dfhhj
it's a simple task with tail... (5 Replies)
Discussion started by: victor369
5 Replies
4. Shell Programming and Scripting
Hello All,
I am new to Bash Programming, I just started a few days ago. OK now to my Question. I want to remove a text from a string. Example:
var="Hello Bad World!"
echo $var
Output: Hello Bad World!
But i want:
Hello World!
How can i remove the word "Bad" ? I heard about sed... (7 Replies)
Discussion started by: Coolman24
7 Replies
5. Shell Programming and Scripting
Hi,
I have a file containing the DDLs of tables in a schema. From that I need to remove all the lines from a starting string till a specific string. Here is an example.
File1.txt
-------------
CREATE TABLE "SCHEMA1"."LKP11_TBL_USERS"
( "ID" NUMBER(8,0) NOT NULL ENABLE,
"USER_ID"... (3 Replies)
Discussion started by: satyaatcgi
3 Replies
6. Shell Programming and Scripting
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies
7. Shell Programming and Scripting
Dear All
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB... (5 Replies)
Discussion started by: suryanarayana
5 Replies
8. Shell Programming and Scripting
Hi Perl users,
I have another problem with text processing in Perl. I have a file below:
Linux Unix Linux Windows SUN
MACOS SUN SUN HP-AUX
I want the result below:
Unix Windows SUN
MACOS HP-AUX
so the duplicate string will be removed and also the keyword of the string on... (2 Replies)
Discussion started by: askari
2 Replies
9. UNIX for Beginners Questions & Answers
I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file.
Please use CODE tags as... (7 Replies)
Discussion started by: ANKIT ROY
7 Replies
10. Shell Programming and Scripting
Hello experts,
I have a text file with lot of curly brackets (both opening { & closing } ). I need to delete them alongwith the text between opening & closing brackets' pair.
For ex: Input:-
59. Rh1 Qe4 {(Qf5-e4 Qd8-g8+ Kg6-f5
Qg8-h7+ Kf5-e5 Qh7-e7+ Ke5-f5 Qe7-d7+ Qe4-e6 Qd7-h7+ Qe6-g6... (6 Replies)
Discussion started by: prvnrk
6 Replies
LEARN ABOUT DEBIAN
mysqmail-dovecot-logger
mysqmail-dovecot-logger(8) System Manager's Manual mysqmail-dovecot-logger(8)
NAME
mysqmail-dovecot-logger - logs dovecot-imapd and dovecot-pop3d traffic to a mysql database
SYNOPSIS
mysqmail-dovecot-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-dovecot-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq-
mail-dovecot-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf.
mysqmail-dovecot-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS pop_access (
id varchar(32) NOT NULL default '',
uid int(11) NOT NULL default '65534',
gid int(11) NOT NULL default '65534',
home varchar(255) NOT NULL default '',
shell varchar(255) NOT NULL default '',
mbox_host varchar(120) NOT NULL default '',
crypt varchar(50) NOT NULL default '',
passwd varchar(50) NOT NULL default '',
active int(11) NOT NULL default '1',
start_date date NOT NULL default '0000-00-00',
expire_date date NOT NULL default '0000-00-00',
quota_size int(11) NOT NULL default '0',
type varchar(20) NOT NULL default 'default',
memo text,du bigint(20) NOT NULL default '0',
another_perso varchar(5) NOT NULL default 'no',
redirect1 varchar(255) default NULL,
redirect2 varchar(255) default NULL,
localdeliver varchar(10) NOT NULL default 'yes',
pop3_login_count int(9) NOT NULL default '0',
pop3_transfered_bytes int(14) NOT NULL default '0',
imap_login_count int(9) NOT NULL default '0',
imap_transfered_bytes int(14) NOT NULL default '0',
last_login int(14) NOT NULL default '0',
PRIMARY KEY (id,mbox_host) ) TYPE=MyISAM
VERSION
This documentation describes mysqmail-dovecot-logger version 0.4.4 or superior. See http://gplhost.com/softwares-mysqmail.html for
updates.
SEE ALSO
qmail-send(3), syslog(3), logger(8)
mysqmail-dovecot-logger(8)