pls. help with SQL database...

Applications Programming
1

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...

 
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

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

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

Do you want to load the above data in table? if yes.. we need to create the external directory ..