Hi,
Thanks for your help - Here is a part of my script...
datapath would have the valye a/b/c
datapatrn would have the value /*.txt (I tried /\*.txt also)
batchsize would have a number such as 2 for example
the result should go to a file $fileslst
The flaw is if you run inside the directory where a is located it will execute, but if you run script through some other direcotry then it will not be able to find the a/b/c path iteself.
Hello.
Consider the following magic words:
# ls `which adduser`
ls: /usr/sbin/adduser: No such file or directory
#
Hmmm...
Then:
# ls /usr/sbin/adduser
/usr/sbin/adduser
#
Now what?
Unforunately this little sniippet is used in my debian woody server's mysql pre install script.... (2 Replies)
Portion of my script below :
if ; then
NUMBEROFFEILDS=`cat ${BASE_SCRIPT_LOC}/standardfilecleanup.lst|grep -w ${db_file_path}|awk -F: '{print NF}'`
COUNT=4
while ; do
awk_var="$"`echo $COUNT`
file_name1=`cat ${BASE_SCRIPT_LOC}/standardfilecleanup.lst|grep -w... (1 Reply)
I've been trying to figure this out since last night, and I'm just stumped. The last time I did any shell scripting was 8 years ago on a Unix box, and it was never my strong suit. I'm on a Mac running Leopard now. Here's my dilemma - hopefully someone can point me in the right direction.
I'm... (10 Replies)
Hi,
I need to write a Linux shell script which will perform an FTP operation to another server.
main.sh will contain -
ftp -nd Dest.IP.address < ftpScript.sh
Contents of ftpScript.sh is given below -
user userid passwd
prompt
lcd /vidya/Input
cd vidya/Output
mput *.*
close
... (1 Reply)
I need to sort through a volume that contains video files by access time and delete files that have not been accessed over x days. I have to use the access time as video files are originals that do not get modified, just read
Testing commands on a local test folder...
$ date
Wed Sep 28... (10 Replies)
for i in `cat /export/home/afahmed/Arrvial_time.txt`
do
echo $i
echo $i | awk '$3 < $D { print $4 }' >> dynamic_DF.txt;
done
When i echo, its echo as
Nov
15
02:24
/export/home/pp_adm/inbound//wwallet_20111115.txt where i expect it to be Nov 15 02:24... (7 Replies)
Hi. I am trying to start a script on my router that will execute even if i log off. To execute the script I write:
nohup ./dslconnection > dslstat.out 2>&1 &
It starts the job:
21968 admin 1604 S /bin/ash ./dslconnection
The problem is that when I log back in the job has been... (6 Replies)
Hi,
I have prepared a script and trying to execute it but not getting expected output. Could you please help and advise what is going wrong.
"If else" part in below script is not working basically.
I am running it on HP-UX.
for i in slpd puma sfmdb
do
echo "******\t$i\t*******"
echo... (10 Replies)
I ran into the following and still do not understand entirely the rationale behind this. If someone could explain why things are as they are I'd be thankful.
The following was tested on AIX 7.1 with ksh88, but i suspect that to be ubiquitous. In an installation routine i had to create a set of... (6 Replies)
Discussion started by: bakunin
6 Replies
LEARN ABOUT DEBIAN
datacopy
datacopy(1) FreeTDS Utilities datacopy(1)NAME
datacopy - move table data between two servers
SYNOPSIS
datacopy { -t | -a | -c owner } [-b batchsize] [-p packetsize] [-v] [-d]
[-S server/username/password/database/table_or_view]
[-D server/username/password/database/table]
DESCRIPTION
datacopy is a utility distributed with FreeTDS. datacopy will move table data from one server to another without the need for intermediate
files. datacopy is much faster and more efficient than is freebcp out/in.
datacopy makes use of the db-lib bcp API built into FreeTDS. This API is also available to application developers.
datacopy can be used to migrate data between Sybase ASE and SQL Server or vice versa.
OPTIONS -t Truncate target table before loading data.
-a Append data to target table.
-c owner
Create the target table with the same schema as the source table. datacopy will submit a 'create table' command on the target
server/database using the specified owner in
the command, e.g. CREATE TABLE owner.table (...).
-b batchsize
The number of rows per batch of data copied. Each batch of data is effectively 'committed' to the database. The default is 1000.
-p packetsize
The number of bytes, per network packet, sent to and from the servers. Increased packet size can enhance performance.
-v Produce verbose output, including diagnostic timings.
-d Produce freetds TDSDUMP output. (Serious debug only!)
-S server/username/password/database/table_or_view
The connection information for the source server and the location/name of the table (or view) to be copied. If not specified, data-
copy will prompt the user for the information.
-D server/username/password/database/table
The connection information for the destination server and the location/name of the target table. If not specified, datacopy will
prompt the user for the information.
SEE ALSO freebcp(1), defncopy(1), bsqldb(1), tsql(1), FreeTDS User Guide.
HISTORY
datacopy first appeared in FreeTDS 0.64.
AUTHORS
The datacopy utility was written by Bill Thompson (thompbil@exchange.uk.ml.com).
doc 13 November 2011 datacopy(1)