In Progress

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!?

Beceriler: Linux, MySQL, Betik Yükleme, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 1 değerlendirme ) Mogi das Cruzes, Brazil

Proje NO: #14060257

Seçilen:

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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)
1.0

Bu iş için 3 freelancer ortalamada $32 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(48 Değerlendirme)
5.0
rakeshknehra

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(16 Değerlendirme)
3.4