06-18-2004
It all depends on what you are trying to import.
For example, importing a compress MySQL database dump is easy:
zcat myDatabase.sql.gz | mysql -u username -p databasename
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am trying to import compressed files using a pipe on a server, IBM AIX UNIX 3.4, with very little disk space
The command is:
nohup cat xaa xab xac xad xae xaf xag | uncompress - > imp_pip &
Then the imp_pip file is used in the import statement, files=imp_pip
Does this statement... (0 Replies)
Discussion started by: pengwyn
0 Replies
2. Windows & DOS: Issues & Discussions
Hi,
Is there any way to import data files from Unix system to Windows system?
I have many data files on Unix machine generated every night.
I need to pick certain data from each file and plug them into this windows file on the network share drive.
Anyone has any idea?
Thanks in advance! (8 Replies)
Discussion started by: whatisthis
8 Replies
3. Solaris
I am getting this error when trying to unzip a file.gz . Anyone know how to resolve this ? (3 Replies)
Discussion started by: jxh461
3 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have the file(F1.XL) in Unix Box. it's updating every 1hr.
I would like to import f1.xl to Windows excel sheet, when i need see the reports.
can any one clarify, is there any VB script for importing data from UNIX, like sql connection....
thanks (1 Reply)
Discussion started by: koti_rama
1 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement for creating a Perl Script which will perform Data Import process in an automated way and I am elaborating herewith :
Section 1 )
- use the following command line format :
"./import.pl -h hostname -p port -f datafile.txt"
Section 2)
datafile.txt will... (3 Replies)
Discussion started by: scott_apc
3 Replies
6. Shell Programming and Scripting
Hi,
I have a file that has got compressed data. I would want to uncompress the packed decimal data(not the file). is there a way to do that in ksh? (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies
7. UNIX for Dummies Questions & Answers
I have a large number (50,000) of pretty large compressed files and I need only certain lines of data from them (each relevant line contains a certain key word). Each file contains 300 such lines. The individual file names are indexed by file number (file_name.1, file_name.2, ... ,... (1 Reply)
Discussion started by: Boltzmann
1 Replies
8. Shell Programming and Scripting
Hi all,
Help needed urgently.
I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins).
I guess it takes so long... (1 Reply)
Discussion started by: robot_mas
1 Replies
9. Shell Programming and Scripting
Hi all,
I don't know if this the right place to post my question to get some ideas on how to done this.
I have a text files extracted from OCR that need to have snippets to be import to database as snippet table which have columns "snippet, date, title" I dont know if shell scripts can do it... (11 Replies)
Discussion started by: lxdorney
11 Replies
10. UNIX for Beginners Questions & Answers
HI
I have a dsv file that looks like:
<<BOF>>
record_number|id_number|first name|last name|msisdn|network|points|card number|gender
312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M
313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Discussion started by: tera
4 Replies
LEARN ABOUT DEBIAN
ns_zlib
ns_zlib(3aolserver) AOLserver Zlib Extension ns_zlib(3aolserver)
__________________________________________________________________________________________________________________________________________________
NAME
ns_zlib - Zlib compression support
SYNOPSIS
ns_zlib compress string
ns_zlib gunzip file
ns_zlib gzip string
ns_zlib gzipfile file
ns_zlib uncompress string
_________________________________________________________________
DESCRIPTION
The ns_zlib command enables compressing and uncompressing of strings or files. The command is available if the nszlib.so module is loaded
into AOLserver or the libnszlib.so, nszlib.dll, or libnszlib.dylib dynamic library is loaded using the load command in a suitable tclsh
such as nstclsh.
ns_zlib compress string
This command compresses the given string and returns a Tcl byte array object with the compressed data.
ns_zlib gunzip file
This command uncompresses the contents of the given gzipped file and returns a string as the result.
ns_zlib gzipfile file
This command is similar to the gzip shell routines, compressing the given file into a new file with the .gz extension. If success-
ful, the original uncompressed file is deleted.
ns_zlib uncompress bytearray
This command takes a byte array object which includes compressed data and returns an uncompressed string object.
EXAMPLES
The following examples demonstrate compressing and uncompressing a string;
# Compress Tcl string
set test "This is test string"
set data [ns_zlib compress $test]
set test [ns_zlib uncompress $data]
--> returns "This is test string"
# Compress the string into gzip format
set gzip [ns_zlib gzip $test]
# Save as gzip file
set fd [open /tmp/test.gz w]
fconfigure $fd -translation binary -encoding binary
puts -nonewline $fd $gzip
close $fd
# Uncompress gzipped file
set test [ns_zlib gunzip /tmp/test.gz]
--> returns "This is test string"
SEE ALSO
ns_adp_ctl(n), load(n)
KEYWORDS
GZIP, compress, uncompress
AOLserver 4.5 ns_zlib(3aolserver)