How to read a text file line by line and insert into a database table?

Shell Programming and Scripting
1

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
  3. Perform select and output result to html and email
 
Feb 10 23:20:27 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 14675188 kilobytes (86%) DUMPED.
Feb 10 23:20:54 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 14841824 kilobytes (87%) DUMPED.
Feb 10 23:21:06 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 14968036 kilobytes (89%) DUMPED.
Feb 10 23:21:20 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 15119660 kilobytes (91%) DUMPED.
Feb 10 23:21:36 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 15259614 kilobytes (94%) DUMPED.
Feb 10 23:21:48 2014: Backup Server: 3.43.1.1: Dump phase number 1 completed.
Feb 10 23:21:48 2014: Backup Server: 3.43.1.1: Dump phase number 2 completed.
Feb 10 23:21:48 2014: Backup Server: 3.43.1.1: Dump phase number 3 completed.
Feb 10 23:21:48 2014: Backup Server: 4.188.1.1: Database EligKeyDB: 15387946 kilobytes (100%) DUMPED.
Feb 10 23:21:48 2014: Backup Server: 3.42.1.1: DUMP is complete (database EligKeyDB).
Feb 10 23:21:48 2014: Backup Server: 2.23.1.1: Connection from Server CBSPRO on Host DSHSSAVWN8 with HostProcid 4688.
Feb 10 23:21:48 2014: Backup Server: 2.23.1.1: Connection from Server CBSPRO on Host DSHSSAVWN8 with HostProcid 4688.
2

You are asing us to write the entire script
What have you tried?
what database are you inserting these details into?

3

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.

(Original thread is here)