cron job to extact lines from files to another file and ftp to new server
i have a text file in this format: which creates a new one everyday in the form of filename _zing__r200_2012_8_10_log.txt
I would like to run a cron job to extract all the lines wich has the pattern Fri Aug 10 07:30:05 EDT 2012, anotheruser(192.168.0.245) to all: to a new file like 2012_8_10_log.txt which I will either scp or ftp to another server.
my ultimate goal is to take that file, use regualr expression such as
to get each line like this
and insert in mysql using |~| as delimiter.
any help, tip or pointer ??
thanx
Moderator's Comments:
Please view this code tag video for how to use code tags when posting code and data.
Last edited by Corona688; 08-10-2012 at 11:10 AM..
Thanks for the all the help last evening on CRON jobs. It's now working.
Is it possible with cron to save a backup of a file to a different server or location? The idea being that if one host goes arse over tit, I'll have a backup of the DB on another server?
Many thanks,
Ed Ludlow (3 Replies)
I am writing a script that will be placed in a crontab, which basically retrieves a file that is overwritten everyday (with current customer data) and then sent to another company. I was wondering what the best way to ensure that ftp was successful and notification of a success or failure message.... (3 Replies)
I am new to cron and am trying to set a cron job that will run everyday at 2 to go out to a server (via ftp with user name and password) and get a file and then bring it back to my sever. Below is what I have but it doesn't seem to be working. Any help would be appreciated.
cron command - will... (4 Replies)
We have a script that we run manually, we want to set it up so that it will run automatically via cron, the problem is during the ftp process nothing is put, the script logs in changes directory fine, but nothing is put to the directory. I have tried it as root, a power user, etc. I have made the... (4 Replies)
Due to downsizing and attrition, I have inherited SysAdmin tasks, but unfortunately not all the required knowledge and skills came to me along with the assignment -> so I appreciate any advice and help ( be patient with my newbie terms and questions).
We moved a central server and changed it's... (1 Reply)
Hello,
Im fairly new to this and am hoping for your help in moving forward.
1. I need to carry out a FTP transfer from SERVER1 to SERVER2 at 3am every morning.
2. The FTP is to work on SERVER1
3. There will be many files to transfer (96 files per day)
4. I want to delete the files... (3 Replies)
Im having a problem with my ftp CRON jobs. I have another related (but not the same question in shell scripting).
My FTP CRON jobs connect to a server and drop some files off, if for some reason it cannot connect to the server (timesout/password wrong etc) instead of stopping, it tries again... (3 Replies)
Despite my best efforts, my media streaming server still dies sometimes and I am in a random place trying to ssh into the server to restart it on my cell phone after customers start calling.... I tried using google to track down a script that would do the following
Every 5 min execute:
sudo... (1 Reply)
Hi all,
I think this could have a simple solution, just I canīt get it so far.
I have the script below that includes several echo commands in order
to show that every part of the script have been executed. A cron job
executes this script and when is completed the output is sent by email.
... (4 Replies)
I wrote a quick little script that will eventually end up as a cron job to export rrd files for my cacti server.
Here is the script:
#!/bin/bash
rm -rf /backup/cacti_xml/*
cd /var/www/html/rra
ls -1 *.rrd | awk '{print "rrdtool dump "$1" > /backup/cacti_xml/"$1".xml"}' | sh -x
Is there... (5 Replies)