nixCraft

Dear all,

I wonder if someone can help me.
On a linux server (RHEL) I collect different output file from different informations.
these files I want to dump into a mysql db so I can create a php script that generate a reporting on the intranet.
this should all happen automatically via crontab.

Can someone help me please

thanks a lot
chebbab

use mysql -e 'sql-command1;sql-command2;' syntax for shell script to dump infomation from a shell script.
for example
Above is just an example now a working code but it should be used as starting point you can call about script from a crontab

On a related note I recommend php for all sort of work for getting input from system to dumping data to generating reports. PHP can work from a shell and cron

__________________
May the force with you!

Hi Monk,

Thanks for the reply.

just little question, what about the output file containing alle the gathered data, in which format should it be. do I need to put all data with a seperator?

greets
chebbab

Hi my latest question I managed to find the solution

tail -1 file | cut -d= -f3 -f6 -f8 -f10 -f12 >> file.out

touch file.tmp
(for text in `cat file.out`;
do
echo -e -n " \b$text " >> file.tmp
done

cat file.tmp | tr [:blank:] , >> file.csv

Now this works and I got all my needed data into a comma seperated file.
I also tried the above received code from you Monk but I don't understand what it realy does, where does my .CSV file fits?

these file need to be dumped into a mysql db in a table..

thanks for your help

Dear All,

In the meantime I'm using the above code to generate a file with all the necessary info I need and comma seperated.

Now what I need is that a file is generated with the following conntent already

insert into 'mytable' values (my comma seperated info generated from the previous script;

example

insert into 'mytable' values (1,2,3,4);

Who can help me out please