How to read a text file line by line and insert into a database table?
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C. Phrase "Dump is Complete"
3 Insert three extracted data columns into a Database table
4. Perform select and output result to html and email
I need to insert a file called temp_impact (which has about 15 lines in it) to a file called 11.23cfg starting at line 33. I searched the forums and found the
sed '34i\
test' 11.23cfg > newfile
That will enter word test at the appropriate line, but i need the entire file dumped there. Any... (4 Replies)
So I need to write lines into line X of file X.
I can get the file by doing:
cfgnumber=$(cat -n -comm.cfg| grep -i "servicegroup_name 24x7-comunicacions")
echo $cfgnumber
it outputs the Line where it finds now I need to start writing something right bellow that line.
thanks (10 Replies)
Dear Folks :),
I am new to UNIX scripting and I do not know how can I insert some text in the first column of a UNIX text file at command promtp.
I can do this in vi editor by using this command :g/^/s//BBB_
e,g I have a file named as Test.dat and it containins below text:
michal... (4 Replies)
I am using the while-loop to read a file.
The file has lines with null-terminated strings (words, actually.)
What I have by that reading - just a first word up to '\0'!
I need to have whole string up to 'new line' - (LF, 10#10, 16#A)
What I am doing wrong?
#make file 'grb' with... (6 Replies)
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Hi everyone,
I am writing a BASH shell script that I will use to process data files. I have a text file that contains the names of the files to be processed, for example:
cat filenames.txt
file1
file2
file3
file4
file5
What I would like to do is set up a FOR loop within my script... (2 Replies)
Hi ,
I am trying to write an shell, which reads a text file (from a location) having a list of numbers of strictly 5 digits only ex: 33144
Now my script will check :
1) that each entry is only 5 digits & numeric only, no alphabets, & its not empty.
2)then it executes a shell script called... (8 Replies)
Hi All,
I am using UNix Sun OS sun4u sparc SUNW,SPARC-Enterprise
My intention is to insert a line of text after 13th line of every file inside a particular directory.
While trying to do it for a single file , i am using sed
sed '3 i this is the 4th line' filename
sed: command garbled: 3... (5 Replies)
i have a text file as belows, it includes 2 columns, 1st is the column name, 2nd is the file_name
data_file.txt
column_name file_name
col1 file1
col2 file2
col3 file1
col4 file1
col5 file2
now, i would like to... (4 Replies)
Discussion started by: tester111
4 Replies
LEARN ABOUT OSF1
backup_dbverify
BACKUP_DBVERIFY(8) AFS Command Reference BACKUP_DBVERIFY(8)NAME
backup_dbverify - Checks the integrity of the Backup Database
SYNOPSIS
backup dbverify [-detail] [-localauth]
[-cell <cell name>]
[-help]
backup db [-d] [-l] [-c <cell name>] [-h]
DESCRIPTION
The backup dbverify command checks the integrity of the Backup Database. The command's output indicates whether the Backup Database is
damaged (data is corrupted) or not. If the Backup Database is undamaged, it is safe to continue using it. If it is corrupted, discontinue
any backup operations until it is repaired.
CAUTIONS
While this command runs, no other backup operation can access the Backup Database; the other commands do not run until this command
completes. Avoid issuing this command when other backup operations are likely to run. The backup savedb command repairs some types of
corruption.
OPTIONS -detail
Reports the number of orphaned blocks found, any inconsistencies, and the name of the server machine running the Backup Server that is
checking its copy of the database.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The backup command interpreter presents it to
the Backup Server, Volume Server and VL Server during mutual authentication. Do not combine this flag with the -cell argument. For more
details, see backup(8).
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see backup(8).
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The command displays one of the following two messages:
Database OK
The database is undamaged and can be used.
Database not OK
The database is damaged. You can use the backup savedb command to repair many kinds of corruption as it creates a backup copy. For
more detailed instructions, see the OpenAFS Administration Guide chapter about performing backup operations.
The -detail flag provides additional information:
o The number of orphan blocks found. These are ranges of memory that the Backup Server preallocated in the database but cannot use.
Orphan blocks do not interfere with database access, but do waste disk space. To free the unusable space, dump the database to tape by
using the backup savedb command, and then restore it by using the backup restoredb command.
o Any inconsistencies in the database, such as invalid hostnames for Tape Coordinator machines.
o The name of the database server machine on which the Backup Database was checked, designated as the "Database checker". For a detailed
trace of the verification operation, see the /var/log/openafs/BackupLog file on the indicated machine. You can use the bos getlog
command to display it.
EXAMPLES
The following command confirms that the Backup Database is undamaged:
% backup dbverify
Database OK
The following command confirms that the Backup Database is undamaged and that it has no orphan blocks or invalid Tape Coordinator entries.
The Backup Server running on the machine "db1.abc.com" checked its copy of the Database.
% backup dbverify -detail
Database OK
Orphan blocks 0
Database checker was db1.abc.com
PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on every machine where the Backup Server is running, or must be logged
onto a server machine as the local superuser "root" if the -localauth flag is included.
SEE ALSO BackupLog(5), backup(8), backup_restoredb(8), backup_savedb(8), bos_getlog(8)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BACKUP_DBVERIFY(8)