Bash script Linux CentOS -- 2

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:




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

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

Daha fazlasını gör: linux script append string, health check linux script bash, linux script move file, linux script import file, linux script part string, linux script parse file, linux script copy file ftp, linux script add string file, linux script bash, linux script check file contains line add, linux script latest file, linux script delete file list, linux script exclude string, linux script change string file, linux script add file, linux script shell replace string, linux script copy file using ftp, linux script check string, linux script replace string variable, linux script replace string, linux ftp upload script bash, linux script write file, linux script delete file, linux mysql bash insert values, linux script remove file

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

Proje NO: #14078329



Hello Sir, We read that you need a bash script but the description of project seems to require a most complex script (like in python). It is necessary that all the part that you described is implemented by bash?

%selectedBids___i_period_sub_7% gün içinde 35%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)

Bu iş için 12 freelancer ortalamada $38 teklif veriyor


Hello, my name is Nikos and I'm working on the Linux server administration field for the past 5 years. Over these years I was responsible for two web hosting companies, managing at full their servers and providing cust Daha Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(80 Değerlendirme)

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 Daha Fazla

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

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.

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

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

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

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 Daha Fazla

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

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Daha Fazla

in %bids___i_period_sub_35% gün içinde28%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

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

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 Daha Fazla

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

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 Daha Fazla

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