Dear All,

I want to create a reporting DB with mysql and bash script. I have directories which are growing day by day. I want to store their size in database along with incremental size on day to day basis so that I may retrieve records from database on need basis.

i.e directory listing by command du -sh --block-size=M * is

755M newyork
919M pakistan
197M britain
189M america

Now my Database has following columns. database name=reporting, table name=reporting.

Name, Current_Size, Old_Size, Date

Please guide me to write bash script which insert folder names alongwith size in mysql database mentioned.

Thanks

Regards,
Kamran

We will be glad to 'guide you'...so show us what YOU wrote already, and tell us where you're having problems. We are NOT going to write your script for you, but will be happy to help. There are THOUSANDS of easily-found bash scripting tutorials, many that include importing data into MySQL.

Please show some effort of your own, and don't ask people to write your scripts for you.

Hello TbOne,

Yes I have written a script. here are commands which I am using.

#!/bin/bash
cd /recording/web/

du -sh --block-size=M * | awk '{print $2}' > /home/kamran/names
du -sh --block-size=M * | awk '{print $1}' > /home/kamran/size


echo "INSERT INTO 'reporting' (Date) values (NOW());" | mysql -h x.x.x.x -u root -ppassword reporting;done

#################################

Not actually not getting to insert my collected directory names and sizes from mentioned files into mysql columns.
When I tried different commands it give me that columns and rows count does not match.

regards,
kamran

Ok...so that VERY CLEARLY tells you what the problem is. Did you read and understand what you posted in your first post, and consider what the error says??

You said your table has FOUR columns...and your data has TWO. And you also need to read the man page on the mysql command, because you can easily specify the insert on the command line, without the echo. And you're putting data into two different files for some reason, first the name, then the size...and then you insert BOTH of them (somewhere...certainly not in the echo statement) into the database. So why bother to split them up?

Again, you need to look at one of the MANY easily found examples on how to do what you're after.