12-28-2009
it's time for a database solution.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I do an and condition with fgrep.
I want to do:
ps -ef | fgrep -f searchvalues > tempmail.file
mailx -s "Email Subject" email@domain.com < tempmail.file
The search values file contains:
opt/bea.*java.*80
mysqld
What I want is to find things that contain:
mysqld OR... (7 Replies)
Discussion started by: jimmy
7 Replies
2. UNIX for Advanced & Expert Users
Hi Guys,
Can anyone explain why I'm getting error below? when I execute in other server there is no error, what could be the reason.
$ fgrep -f timecell.txt ldap_prev.dat
wordlist too large
$ wc -l timecell.txt ldap_prev.dat
372461 timecell.txt
3722878 ldap_prev.dat
Thanks in... (2 Replies)
Discussion started by: krishna
2 Replies
3. Shell Programming and Scripting
Hi all,
I need to transport a number of files from one server to other. I like to ensure the integrity using file checksum values.
The action plan is,
1. create the list of checksum values for all the files using cksum command in source server.
2. Transfer all the files including the file... (5 Replies)
Discussion started by: r_sethu
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I need fgrep to search all files in the subdirectories in /var/spool/postfix/defer/...
How can I issue such a command? (3 Replies)
Discussion started by: mojoman
3 Replies
5. Shell Programming and Scripting
Hi,
I know that I can grep desired data to a file but is there a way to add an additional field of data to the output in addition to what is found. I want to add a login id to the data that is found in the grep. Is this even possible? Thanks for your help.
Toni (14 Replies)
Discussion started by: ski
14 Replies
6. Shell Programming and Scripting
How can we use fgrep command to search pattern on perticular field on a file.
eg : I have a parren file having format
cat patternfile
SPA16S199982
SPA5S26330
I want to seach these pattern on FIRST field of File2(since other field has
same data) and that too maching entirely.
... (10 Replies)
Discussion started by: morbid_angel
10 Replies
7. Shell Programming and Scripting
Hi,
I'm struggling a little here, so I figured it's time to ask for help.
I have a file with a list of several hundred IDs (the hit file- "hitfile.txt"), which is newline delimited, and a much bigger (~500Mb) text file, "FASTA.txt" with several thousand entries, delimited by ">". It's the... (8 Replies)
Discussion started by: Tbox
8 Replies
8. Shell Programming and Scripting
Hi ,
Please help me resolve the below issue.
I need to combine the below two command into one.
grep 'ImanItemP' import.report| tr -s ' ' | cut -f2 -d ' ' > tmp.txt
fgrep -v -f tmp.txt input.txt > reuired file.txt
Thanks
Ramesh (4 Replies)
Discussion started by: ramesh12621
4 Replies
9. Shell Programming and Scripting
Is there any equivalent of the below requirement in perl
fgrep -f file1 file2 > file3 (2 Replies)
Discussion started by: aravindj80
2 Replies
10. UNIX for Dummies Questions & Answers
Using the fgrep command with the -v option.
I have two files:
file1:
dog 1
cat 3
bird 5
fish 7file2:
dog
catUsing fgrep -v file2 file1 According to the fgrep man page, the output should be bird5
fish 7 but I can't seem to get it to work. Any help would be appreciated. (2 Replies)
Discussion started by: jimmyf
2 Replies
LEARN ABOUT SUSE
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE [ IF EXISTS ] name
DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only
be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to
postgres or any other database to issue this command.)
DROP DATABASE cannot be undone. Use it with care!
PARAMETERS
IF EXISTS
Do not throw an error if the database does not exist. A notice is issued in this case.
name The name of the database to remove.
NOTES
DROP DATABASE cannot be executed inside a transaction block.
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb
[dropdb(1)] instead, which is a wrapper around this command.
COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard.
SEE ALSO
CREATE DATABASE [create_database(7)]
SQL - Language Statements 2010-05-14 DROP DATABASE(7)