pls. help with SQL database...


 
Thread Tools Search this Thread
Top Forums Programming pls. help with SQL database...
# 1  
Old 10-04-2012
pls. help with SQL database...

On the Linux systems, we have scripts which monitor disk usage. I want to take that data and feed that into SQL database. Can you give some advise.

For example here is one of the file. I have many files like this but the format is same...

Code:
 
2012-09-24 04:36:14 2012-09-24 04:36:16 48414984 emc1:/home1/peter nfs 1393977600 590560512 803417088 43% /home/peter
 2012-09-25 02:06:00 2012-09-25 02:06:02 48414984 emc1:/home1/peter nfs 1393977600 647708736 746268864 47% /home/peter
 2012-09-26 04:00:22 2012-09-26 04:00:24 48414984 emc1:/home1/peter nfs 1393977600 800012576 593965024 58% /home/peter
 2012-09-27 05:01:11 2012-09-27 05:01:13 48414984 emc1:/home1/peter nfs 1393977600 800431776 593545824 58% /home/peter
 2012-09-28 05:13:25 2012-09-28 05:13:27 48414984 emc1:/home1/peter nfs 1393977600 800747072 593230528 58% /home/peter

# 2  
Old 10-04-2012
What type of sql database( i.e. oracle, db2, mySql, informix )?

What does your database table look like? , provide the "create table" sql or a 'desc' of table.
# 3  
Old 10-05-2012
I installed mysql. I didn't create the tables yet. I don't know how to do that. I have downloaded phpmyadmin to help me with it.
I wanted to find out am I going on the correct path, basically my manager wants to see all this results on some kind of DB. he doesn't care which database.
# 4  
Old 10-08-2012
Do you want to load the above data in table? if yes.. we need to create the external directory ..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies

2. Shell Programming and Scripting

SQL compare database

Hi , I have 2 databases which has same table names and I need to list entries of a particular table in database1 not existing in the same tablename of database2. eg : I have db1 having table name orders ad_d | code | start | end | amountscore | id | amount_class |... (1 Reply)
Discussion started by: siya@
1 Replies

3. Shell Programming and Scripting

SQL in LINUX. Variable or Database

Dear Friends :-), Need your help once again. I have following SQL in a shell script to pick values from database select date_stamp, time_stamp from logs where date=31012012 However, at times we need to take these value(s) from a variable. To do this we have following query. select... (2 Replies)
Discussion started by: anushree.a
2 Replies

4. UNIX for Dummies Questions & Answers

shell/sql to get difference between two database

I have two queries query1 select IDW_SITE_NAME REGION,a.location_sid,a.CALENDAR_SID,count(*) from idw.vod_stream a, IDW_REF_DATA b where a.location_sid = b.location_sid and a.calendar_sid between 20110901 and 20110915 --this is start date parameter and end date parameter and... (5 Replies)
Discussion started by: qutesanju
5 Replies

5. Programming

SQL for flat file database

I have a B+ tree flat file database which is used by the application we use. I would like to implement a SQL kind of access for that DB. I have implemented my data structures to parse and store the user written query for execution. But i would like to know, do we have any standard data... (2 Replies)
Discussion started by: kumaran_5555
2 Replies

6. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example? Thank you! :D J. (0 Replies)
Discussion started by: ph0enix
0 Replies

7. Programming

sql help pls

Can anyone help come up with an sql code for the below? The fields are as follows: SerialNum GroupCode TktType DueDate Amount Examples values are: 1. SN123456 GC0001 Start 15-OCT-2008 28,500 2. SN123460 GC0001 (1 Reply)
Discussion started by: xinoo
1 Replies

8. Shell Programming and Scripting

A script pls( To retrieve database information)

KSH - Unix -AIX - db2 ************** Get the input from the user say '123' (It varies) Then i want to connect to a database say "D1" then i want th extract from the database by giving "select * from tablename where input = '123' I also want to connect to another database "D2" then i... (3 Replies)
Discussion started by: rollthecoin
3 Replies

9. Shell Programming and Scripting

pls help me !! about text database shell programming

my teacher assigned me an assignment about text database shell programming but I don't know anything about that. here is about problem. I must submit this assignment to my teacher before 3 August. contact me at **deleted**, thank you Given a text database file for student registration name... (2 Replies)
Discussion started by: sunattha
2 Replies

10. UNIX for Dummies Questions & Answers

Read SQL database from Unix...

Hi there, I am new here and looking for a bit of help... I don't don't know much about Unix but I've tried to include as much info as possible. We currently operate our system as a bespoke on SCO 5.05 with Informix databases. This includes a financials package called "Multisoft". Both... (0 Replies)
Discussion started by: uptheposh
0 Replies
Login or Register to Ask a Question