sftp and scp are ssh under the covers. Go over there, find the most recently modified file, and send it down the socket to gunzip, make the flat file copy you desire and send the data on to mysql for import real time:
If mysql still does not allow import from stdin pipe, you might be able to use a named pipe, aka FIFO, named for the target table. You might want to use a staging table, in case you need to rerun. Pipes kill latency.
Last edited by DGPickett; 04-20-2011 at 02:40 PM..
I need a script that checks to see if ypserv is running, and if not it will restart yp.
I have a ypslave that is running Sol9, and the ypsrv daemon is dieing, I want to create a cron job that periodicly checks to see if it's running, and if it see's that it isn't, it will re-start the daemon (1 Reply)
Here is the script that i am trying to run. I get an error and i can't figure out what is the problem.
#!/bin/bash
echo "What is your name"
read NAME
if ; then
echo "My name is the same"
esle
echo "You have a nice name"
fi (11 Replies)
I am trying to print my script arguments, but i am stuck at the arrow pointed lines..please help
#!/bin/bash
echo "Number of arguments $#"
count=1
while
do
echo ${$count} <========================
count = $(expr $count +1) <==================
done (4 Replies)
I have a script that will check for integer line by line and if it encounter any blank space will echo it:
Below the script:
#!/bin/ksh
while read i
do
echo "Value is $i"
count=`expr substr "$i" 1 3`
echo $count
if &&
then
echo "Matched"
else
echo "Blank Space Found"
fi (3 Replies)
I have a file that contains these lines
User ID Username
-------- ----------
7738626,zrazak
7783535,jvincigu
7805567,ldrennan
7805583,mtsakama
I need to sort the names alphabetically
How can I sort the lines based on the user names ?
I would appreciate a quick reply anyone
... (1 Reply)
Hello all!
This is my first post and I'm very new to programming. I would like help creating a simple perl or bash script that I will be using in my work as a junior bioinformatician.
Essentially, I would like to take a tab-delimted or .csv text with 3 columns and write them to a "3D" matrix:
... (16 Replies)
Hi team,
I have two select statements and need to run them using SYSDBA user
select * from temp_temp_seg_usage;
select segment_name, tablespace_name, bytes/ (1024*1024) UsedMb from
dba_segments where segment_name='TEMP_TEMP_SEG_USAGE';
Need to run this using a shell script say named... (1 Reply)
Hi,
new to unix and scripting, and i'm trying to set up a simple "if" script to create a seperate flag file dependant on success.
So far i have the following ($5 is a variable passed to the script from the backup job)
if
then
touch /u03/backups/backup_ended.flag
else
touch... (13 Replies)
I have to pull files from a customers cloud directory to our cloud directory periodically, the customer has the files in the new-version(nver) folder; which I am pulling via a python script. (python nver.py)
customers cloud location:
s3://custbucket/$nver/files
Our cloud location:... (0 Replies)