bash script - linux

Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Hourly Job

Hours to be determined
Less than 1 week

Details

Simple bash code to insert the verbose output of lftp into mysql.


lftp
http://lftp.yar.ru/lftp-man.html

#!/bin/bash
lftp -u username,password ftphost << EOF
mirror -Re --use-cache /home/ /backup/
mirror -Re --use-cache /etc/ /backup/
mirror -Re --use-cache /var/www/ /backup/
quit 0
EOF

Using shell script to insert data into remote MYSQL database
http://stackoverflow.com/questions/3900496/using-shell-script-to-insert-data-into-remote-mysql-database

mysql --host=randomhost --user=randomuser --password=randompass randomdb
insert into table (field1,field2,field3) values('http://www.site.com/$hash','$file','$size');

Couple of other things;

- script needs to run every X minutes, however, should not run if already running
- perhaps mysql batch insert?
- ideally some knowledge/experience of lftp commands would be very useful

Thank you.

---
Skills: server-administration, linux

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Applicants: 18

Hired: 1


About the Client

(5.00) 21 reviews

Canada
St Johns 01:28 PM

55 Jobs Posted
57% Hire Rate, 1 Open Job

Over $10,000 Total Spent
34 Hires, 2 Active

$10.15/hr Avg Hourly Rate Paid
686 Hours

Member Since Jan 28, 2011