How to export data file from Unix


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to export data file from Unix
# 15  
Old 03-02-2005
Quote:
Originally Posted by whatisthis
vgersh99,
Should the below code work? (it's not working now)
ftp -n sver1 < file1
======= file1 ================
user yourusername yourpassword
cd /usr1/data/SQL
put 02252005.log
bye
============================
it should.
if you do the same in the interactive ftp, what happens?
are you in the same directory that '02252005.log' resides in?
# 16  
Old 03-02-2005
Power It worked after I changed the path name

After I ftp to the server, the default path is /usr1/data.
If I use the full path name like /usr1/data/SQL, the program will not find the file.
But if I only use part of the path name: SQL. It will work.


Why?
# 17  
Old 03-02-2005
Quote:
Originally Posted by whatisthis
After I ftp to the server, the default path is /usr1/data.
If I use the full path name like /usr1/data/SQL, the program will not find the file.
But if I only use part of the path name: SQL. It will work.


Why?
this is NOT I asked.
I asked about the '02252005.log' file.
Does it reside in your working directory from where you run your script?
It might be a good idea not to assume that and put an absolute path to that file in your script.
This is just an idea.
# 18  
Old 03-02-2005
Hammer & Screwdriver absolute path will not work in ftp

vgersh99,
To answer your question: yes.it reside in my working directory from where I run my script.

if the file were not in the same directory, the program would still not be working after I changed the path name.

I hope someone can explain to me why I have to put relative path instead of absolute path.

If someone sees this message and know the answer, please let me know.

Thanks!

Last edited by whatisthis; 03-02-2005 at 12:58 PM.. Reason: typo
# 19  
Old 03-02-2005
peobably 'cause your ftp-user does NOT have the permission to navigate/cd from the TOP of the tree - but rather ONLY from the ftp-user's 'HOME' directory down.
# 20  
Old 03-02-2005
Lightbulb how to have permission to navigate

vgersh99,
Thank you very much for your reply.
If the server is Lynix or Unix server, how can I set it up so that I can ftp to the top of the tree from home directory?
I have root access to the server.

Smilie


ftp-user does NOT have the permission to navigate/cd from the TOP of the tree - but rather ONLY from the ftp-user's 'HOME' directory down.
# 21  
Old 03-03-2005
Hammer & Screwdriver wu-ftp server on Linux

FYI
We use wu-ftp server on our Linux machine.
I add one line within /etc/ftpaccess file
# realuser user1,user2
realuser usrname

This will allow usrname to browse to different directory other than home directory.


Have a great day!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to Gather data from logs and export to a CSV file

Greetings, After a few hours of trial and error, I decide to ask for some help. I am new to AWK and shell script, so please don't laugh :p I made the below script, to gather data from some logs and have the output into a CSV file : #!/bin/sh #Script to collect Errors ... (9 Replies)
Discussion started by: Yagami_Sama
9 Replies

2. Linux

Parsing - export html table data as .csv file?

Hi all, Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table. Please see the attached html and PNG of what it looks like. ... (7 Replies)
Discussion started by: lxdorney
7 Replies

3. Shell Programming and Scripting

How to export hive table data to a file on local UNIX?

Hi All , I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception . hive -e "select * from test " > /home/user/test.txt ; ... (1 Reply)
Discussion started by: STCET22
1 Replies

4. Shell Programming and Scripting

Data export UNIX shell script

Hi, I want to write a shell script which connect to my database with the following credentials : User name : user PWD : rap_user_1 Hostname : app.Unix.Gsm1900.Org Port : 7862 SID : PTNC1 Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies

5. AIX

wtmp file - is there a patch to export the data another file each day?

sorry for being a noob, i am trying to find which user accessed the server at what time and there ip address at first i used who command but the output didn't contain the ip address then i used the last command which provided me with the ip of the users but when i searched i searched and found that... (1 Reply)
Discussion started by: hercules_1010
1 Replies

6. Shell Programming and Scripting

Run script to export the data to ixf file in loop

Hi, I am trying to export the data to an .ixf file. I have read the table names from a .dat file and those table name should be passed to the select * from schema.TABLENAME query . I am trying the below loop while read TABLE; do db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES... (5 Replies)
Discussion started by: vikyalex4
5 Replies

7. Shell Programming and Scripting

find string(s) in text file and nearby data, export to list help

Hi, So I'm kinda new to shell scripts and the like. I've picked up quite a bit of use from browsing the forums here but ran into a new one that I can't seem to find an answer for. I'm looking to parse/find a string AND the next 15 or so charachters that follow the string within a text file... (1 Reply)
Discussion started by: kar23me
1 Replies

8. Shell Programming and Scripting

How to export table data to xml file?

Hi , I would like to get some suggestion from the experts. My requirement is to export oracle table data as an xml file. Any unix/linux tools, scripts available? Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies

9. Shell Programming and Scripting

Export data from DB2 table to .txt file(space delimited)

Hi I need help on this. Its very urgent for me.. please try to help me out.. I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies

10. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
Login or Register to Ask a Question