12-17-2003
I was looking to view table in one of my databases. I just found it. It's dbdef, simple enough but my mind went blank this morning!
Thanks!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How do I view pdf files on a Solaris 9 environment?
Links and such would be grateful.
"AAAAHHH!! They're everywhere!!!" - Halo Grunt (3 Replies)
Discussion started by: antalexi
3 Replies
2. UNIX for Dummies Questions & Answers
hi all,
how to view crontab entries of user2 logging as user1 (7 Replies)
Discussion started by: matrixmadhan
7 Replies
3. UNIX for Dummies Questions & Answers
I have a file (called CORE) that is a dump created by a crashing process. This file, I believe, is in "binary" form, so when I try to use cat, more, or vi on it, it has a bunch of garbage. Is there anything I can use to "read" or view this file just like I might a non-binary file? I am running... (2 Replies)
Discussion started by: dsimpg1
2 Replies
4. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
5. UNIX for Dummies Questions & Answers
I am having trouble viewing these files from my unix session. vi comes back with line too long. Also an m_dump with the relevant dml comes back with problems.
How can I view this as a text file? Also is there an easy way to view specific records within. Eg I have a policy id (4 Replies)
Discussion started by: trek88
4 Replies
6. Shell Programming and Scripting
Hey,
I know the head and tail function is to view like the top or bottom lines for each file. But lets say I want to view the top/bottom 100 or top/bottom 1000 for a file. whats the command that I use to do this?
thanks (2 Replies)
Discussion started by: kylle345
2 Replies
7. UNIX for Dummies Questions & Answers
Sometime I have to deal with very large log files and I cannot view them for analysis using more or vi. The attempts to open the files error out saying there is not enough memory.
Is there any tool or method with which I can go through huge files? (2 Replies)
Discussion started by: rcchume
2 Replies
8. Shell Programming and Scripting
I have a file name as logfiles_tar.tgz. How can I view the contents of the log files present in logfiles_tar.tgz ? Any help would be really appreciated.
Thanks (3 Replies)
Discussion started by: bobby1015
3 Replies
9. Tips and Tutorials
Hi,
I have a directory, and there is a job running and constantly writes and removes files from and to this directory.
I would like to see somehow these changes without pressing `ls` every second. Kind of `tail -f` command, but for a directory list and not for file content.
I thought maybe kind... (5 Replies)
Discussion started by: ilya_dv
5 Replies
10. Emergency UNIX and Linux Support
Hello All,
I have issues in unix file when I loaded that to database and do select * from table where description like '%'+char(13)+'%' on it I am able to get records. I tried to view the file in unix it is all having blank character which I think is all non ascii which I am not able view.... (11 Replies)
Discussion started by: arunkumar_mca
11 Replies
LEARN ABOUT SUSE
cleanup_digikamdb
cleanup_digikamdb(1) cleanup_digikamdb(1)
NAME
cleanup_digikamdb - Cleanup the digiKam databases to reduce their sizes and increase access speed
SYNOPSIS
cleanup_digikamdb [-t] [-T] [-p] [-h]
OPTIONS
-t Include thumbnail databases.
-T Only cleanup thumbnail databases.
-p path
Specify a different database path. If the specified path is invalid, the entry from the configuration file will be used.
-h Show command line options.
DESCRIPTION
cleanup_digikamdb will cleanup and optimize the digiKam database file. This will, in most cases, lead to a smaller database file size and
an increased access speed, because unneeded elements are removed from the database and data is optimized.
The program will make sure that no instance of digiKam is running, because it is more safe to have no database access during the optimiza-
tion process. It then will read the digiKam configuration file and determine the database location. In a final step the database will be
optimized by invoking the sqlite command 'VACUUM;' on it. If more then one database is found in this location, cleanup_digikamdb will op-
timize every database found in this path and below.
For further explanation, see the following description of the VACUUM command from the sqlite3 website:
When an object (table, index, or trigger) is dropped from the database, it leaves behind empty space. This empty space will be reused the
next time new information is added to the database. But in the meantime, the database file might be larger than strictly necessary. Also,
frequent inserts, updates, and deletes can cause the information in the database to become fragmented - scrattered out all across the data-
base file rather than clustered together in one place.
The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file
from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.
AUTHOR
cleanup_digikamdb was written by Andi Clemens <andi dot clemens at gmx dot net>
cleanup_digikamdb 14 October 2009 cleanup_digikamdb(1)