Bash script Linux CentOS -- 2

In Progress Posted 6 years ago Paid on delivery
In Progress Paid on delivery

The script needs:

1 - Check a folder and verify if the SOURCE file is newer

2 - If the SOURCE file is the same, just send an email. If it is newer, the flow will be:

3 - read the file and extract the numbers from the file. These numbers will build a MYSQL REPLACE command into a pinsets table.

The source file has these informations:

0123=000111=BLABLABALABLA=A

0987=233901=TTTTTTTAAA=A

8765=234567=YYYYYAKAA=A

I will need a MYSQL STRING like this:

REPLACE into pinsets VALUES ('1','000111\n233901\n234567','pinsetname-2','1','');

So, the script needs to analyse the SOURCE FILE, create a MYSQL REPLACE (and run it!), or, if the source file has not change... just send an email.

We will discard all other informations about the SOURCE file. The first number sequence, and the text after the second number sequence. I really need the SECOND number sequence.

And, in MYSQL REPLACE, the numbers need to have \n between all of them because they will be in the same cell.

The source file has around 900 thousand lines.

I want to run this script for all time with one hour intervals (cron), ok!?

Linux MySQL Script Install Software Architecture

Project ID: #14078329

About the project

10 proposals Remote project Active 6 years ago

10 freelancers are bidding on average $34 for this job

mastor31

Hi, I am good in bash script and writing daemon script. Please share me a sample file and db dump to proceed further. Regards, Mastor

$50 USD in 1 day
(12 Reviews)
4.5
victorxian

Hi my name is Victor and I am based in Melbourne Australia. I work as a Linux System Engineer with 8 years experience in supporting enterprise Linux environment. I have strong hands-on experience in deployment and ma More

$35 USD in 1 day
(7 Reviews)
4.1
lxqcad

I can send you the script in a couple of hours after you award me the project. You can check it and then pay me the milestone. Hassle-free.

$50 USD in 1 day
(9 Reviews)
4.4
DevoirTechsoft

Dear Client, Warm greetings, We have done big and complex projects with quality and most of our business comes with repeat hires because of that, so looking forward to build a long term working relationship with yo More

$35 USD in 1 day
(7 Reviews)
3.8
jeevansai502

I am a coder and can finish your task provided you give me sufficient details about the project .Thank you.

$10 USD in 1 day
(3 Reviews)
2.0
shaliniramadass

Hi, we are a 1000 + employee firm. Charging 6$ an hour. Can start any technology immediately. Direct access to developers via Skype, G talk and hotline – 24/7 availability for all 1000+ resource. We can bet you that no More

$25 USD in 1 day
(1 Review)
1.1
mulyananana

i have been working as system administrator since 2009 and familiar with bash script ever since. I already have an idea of what method will be used for the bash script you need. Comparing hash and time meta data file More

$30 USD in 1 day
(0 Reviews)
0.0