bash script - linux

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


Hours to be determined
Less than 1 week

Start Date

April 23, 2013


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


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

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('$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

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

Other open jobs by this client ({{ jobsCount }})

About the Client

(5.00) 36 reviews

St Johns 03:46 AM

86 Jobs Posted
61% Hire Rate, 1 Open Job

Over $10,000 Total Spent
55 Hires, 1 Active

$10.13/hr Avg Hourly Rate Paid
740 Hours

Member Since Jan 28, 2011