Find Jobs
Hire Freelancers

script help

$10-30 USD

In Progress
Posted almost 9 years ago

$10-30 USD

Paid on delivery
I need this within an hour. Don't bid if you can't help get this within timeframe. I need help on making a shell script work on a linux server that will load multiple files from a specified directory into a mysql database table. Basically loop through all files in a directory. I need it to produce an output file of results. here is a script I found but not sure how to create it and output file. what I have so far and need help on how to create, run and stop it if needed. This is a multiple instance of mysql so to invoke the one I want I have to type this on command line: mysql --socket=/opt/mysql/database/mysql_3306/[login to view URL] -p This should help in the script. for f in /var/lib/mysql/[insert name of database here]/*.csv do mysql -e "LOAD DATA INFILE '"$f"' INTO TABLE [nameoftable] FIELDS TERMINATED BY ',' LINES TERMINATED BY ';'" -u [username] --password= [password] [name of database] echo "Done: '"$f"' at $(date)" done
Project ID: 7626756

About the project

4 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $38 USD for this job
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
4.8 (219 reviews)
6.8
6.8
User Avatar
I have ample experience in Bash programming/scripting having all my own Linux nodes (over 12 of them) for hosting purposes. This shouldn't take long at all once we are into SSH.
$55 USD in 0 day
5.0 (47 reviews)
6.7
6.7
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (18 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.9 (7 reviews)
3.4
3.4

About the client

Flag of UNITED STATES
Conyers, United States
5.0
30
Payment method verified
Member since Nov 12, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.