Creating file system info and put into mysql db

rajeshkumar created the topic: Creating file system info and put into mysql db

Create a perl script for following task…
1. Read the directory mentioned by users and list all the files along with their size and Create a property file which has following info of each file.

# Server name Path File Name date Size
1 rajesh /perforce/server:port/root xyz.txt today 10KB

2. Insert this data into mysql Db in table in same fashion as it is in property file

Regards,
Rajesh Kumar
Twitt me @ twitter.com/RajeshKumarIn

rajeshkumar replied the topic: Re: Creating file system info and put into mysql db

Hi Tushar,

I could make it for reading directory and displaying files in such a given format…

My example program is

$DIR = “/home/rajesh”;

@dirlist = `ls -l $DIR | tr -s ” ” ” “| cut -d ” ” -f5,9`;
foreach (@dirlist)
{
print “$_ \n”;
}

Regards,
Rajesh Kumar
Twitt me @ twitter.com/RajeshKumarIn

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.