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 '',... (7 Replies)
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)
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)
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)
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)
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)
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)
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)
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 SUNOS
uucleanup
uucleanup(1M) System Administration Commands uucleanup(1M)NAME
uucleanup - uucp spool directory clean-up
SYNOPSIS
/usr/lib/uucp/uucleanup [-Ctime] [-Dtime] [-mstring] [-otime] [-ssystem] [-Wtime] [-xdebug-level] [-Xtime]
DESCRIPTION
uucleanup will scan the spool directories for old files and take appropriate action to remove them in a useful way:
o Inform the requester of send/receive requests for systems that can not be reached.
o Return undeliverable mail to the sender.
o Deliver rnews files addressed to the local system.
o Remove all other files.
In addition, there is a provision to warn users of requests that have been waiting for a given number of days (default 1 day). Note: uucle-
anup will process as if all option times were specified to the default values unless time is specifically set.
This program is typically started by the shell uudemon.cleanup, which should be started by cron(1M).
OPTIONS -Ctime Remove any C. files greater or equal to time days old and send appropriate information to the requester (default 7 days).
-Dtime Remove any D. files greater or equal to time days old, make an attempt to deliver mail messages, and execute rnews when
appropriate (default 7 days).
-mstring Include string in the warning message generated by the -W option. The default line is "See your local administrator to
locate the problem".
-otime Delete other files whose age is more than time days (default 2 days).
-ssystem Execute for system spool directory only.
-Wtime Any C. files equal to time days old will cause a mail message to be sent to the requester warning about the delay in con-
tacting the remote. The message includes the JOBID, and in the case of mail, the mail message. The administrator may
include a message line telling whom to call to check the problem (-m option) (default 1 day).
-xdebug-level Produce debugging output on standard ouput. debug-level is a single digit between 0 and 9; higher numbers give more
detailed debugging information. (This option may not be available on all systems.)
-Xtime Any X. files greater or equal to time days old will be removed. The D. files are probably not present (if they were, the X.
could get executed). But if there are D. files, they will be taken care of by D. processing (default 2 days).
FILES
/usr/lib/uucp directory with commands used by uucleanup internally
/var/spool/uucp spool directory
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWbnuu |
+-----------------------------+-----------------------------+
SEE ALSO uucp(1C), uux(1C), cron(1M), attributes(5)SunOS 5.10 19 May 1993 uucleanup(1M)