En cours

Bash script Linux CentOS

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.

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

Compétences : Linux, MySQL, Script Install, Architecture Logicielle

Voir plus : health check linux script bash, script bash kill time, adding time bash linux script, linux script ftp download login bash, linux script bash, script linux inventory bash, howto linux ftp bash script, linux varlogmessages bash script hours, bash shell script current time, linux bluetooth bash script broadcast files devices, linux script check time run program, linux ftp upload script bash, ftp script bash linux, linux sed bash script, cgi script bash perl, linux script convert rar zip, linux script find replace, linux script mysql sync

Concernant l'employeur :
( 1 commentaire ) Mogi das Cruzes, Brazil

N° du projet : #14060257

Décerné à :

Pbootly

Already have a bash script similar to this, won't take long. I've a lot of experience writing scripts and handling SQL data with them.

30 $ USD en 1 jour
(1 Commentaire)
1.0

3 freelance font une offre moyenne de $32 pour ce travail

35 $ USD en 1 jour
(48 Commentaires)
5.0
rakeshknehra

Hi there, I can create the required bash script, please contact for further discussion. Thanks and regards!!!

30 $ USD en 1 jour
(16 Commentaires)
3.4