Database is an organized collection of data.
1
vote
0answers
18 views
Vacuuming database termination for postgreSQL [migrated]
I was doing database vacuuming to free up disk space for postgreSQL database. The corresponding table size was large and it was taking long time for vacuuming to get complete. But unfortunately ...
1
vote
0answers
33 views
Can data be “clustered” on disk? If so, how?
Can linux be set to "automatically" cluster data in the way a clustered index does on SQL Server/MySQL or Postgres but a little better?
websocket++ allows for fully persistent and shared memory ...
2
votes
1answer
66 views
How to extract single value from single line tuples?
I have a dump file of a database in the following form
('value1','value2',value3','value4'),('value1','value2',value3','value4'),...
I want first to have each tuple in a single line and next i ...
1
vote
1answer
86 views
why csv is consuming more file size in my unix script?
I'm using this unix script which it is fetching records in the form of csv. I have a SQL query used for this purpose. It contains below information
SET PAGESIZE 5000
SET COLSEP ","
SET LINESIZE 2000
...
0
votes
0answers
26 views
How to do a “select” in DB2 to have an output with given delimiter?
If I do a:
db2 "EXPORT TO output.csv OF DEL MODIFIED BY NOCHARDEL select NUM,DESCRIPTION,STATUS from foo.CHANGE where DESCRIPTION LIKE '%something%'"
then this output comes:
ASDF123,this is a, ...
0
votes
2answers
67 views
How to remove the last character from every line in a text file [duplicate]
I have a tonne of data to analyse, but all the data was Thai. Google translate added a "." to every line after translation.
How can I remove this dot from every line?
Example from output:
DB00301.
...
0
votes
1answer
286 views
How to open OLE2 Compound Document Storage database?
I have file called Thumbs.db that I seem unable to open with anything. SQLite Database Browser can't do it, nor can LibreOffice Base. Opening up the file properties tells me it's an 'OLE2 Compound ...
0
votes
3answers
156 views
Brand new to Linux - running a web server/database server, need to connect to my servers- how?
I am brand new to Linux. I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. I am very familiar with Windows and ...
-3
votes
3answers
272 views
What mysql command can show me the tables in a database and how many rows there are? [closed]
is there a mysql command that will show me the tables and how many rows they have in them?
0
votes
0answers
36 views
How to run Oracle10g forms in browser in Linux
How i can run Oracle Database 10g forms in browser in Linux?
I want a complete tutorial for this.
0
votes
1answer
168 views
No monetdbd installed on linux64 (opensuse 12.2)
I have installed monetdb from MonetDB-11.15.7.zip on a linux64 box following the instruction in the HowToStart.rst file. The Download is available here.
According to the Monetdb's quick start page I ...
2
votes
3answers
190 views
Any programs suitable for making a database over disk-content?
I have quite a lot of external hard-drives, and often have a hard time finding what I'm looking for - not to mention not storing the same file several times on different drives or finding free space ...
0
votes
1answer
641 views
How to remove Oracle Wallet using orapki?
Hi i'm on Centos using oracle 11g
And i've created a wallet using :
$ orapki wallet create -wallet /u01/app/oracle/admin/DB11G/wallet -pwd WalletPasswd123 -auto_login
Now i want to remove it to ...
-1
votes
2answers
138 views
Copyed mysql files from previous system now error while connect, what to do?
Fist of all I have the files but the old system is gone.
I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...
0
votes
1answer
22 views
Only value required using mysql command
I created following command to get value of Innodb_data_writes using command show status in mysql database.
mysql -u root -p**** -e "show status" | grep Innodb_data_writes
Current Output: ...
1
vote
0answers
147 views
how to create a script to backup MySQL databases on separate files?
I need to create a script so to automate the backup process for my database server. Today there are 19 databases on the server and to prevent some schema is created and not contemplated by the script, ...
1
vote
1answer
77 views
syslog-ng ignores MSSQL database name
syslog-ng ignores the database defined in syslog-ng.conf and instead uses the default database of the user when logging to MSSQL destination.
destination d_mssql {
sql(type(mssql)
...
4
votes
2answers
213 views
Data extraction of entire DB on SCO Openserver 6
Firstly apologies if this question seems like a wall of text, I can't think of a way to format it.
I have a machine with valuable data on (circa 1995), the machine is running UNIX (SCO OpenServer 6) ...
4
votes
1answer
590 views
Does quiesce exist for Linux?
Quiescing a file system allows you to make a backup of the database while it is still running and other programs and their data as well.
The application generally needs to be notified of the quiesce ...
1
vote
2answers
377 views
Import single rows from SQLite to MySQL?
I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
4
votes
1answer
170 views
unixODBC documentation / manpage?
Just wondering if there is any official documentation for unixODBC, e.g. how the configuration files have to look like and what parameters they expect? (I am using only a shell, no GUI) Even ...
3
votes
2answers
85 views
Technology / program selection for picture viewing software
I want to learn some Binux usage and/or programming skills and provide an easy to use browser based picture gallery on my local home network. My idea is to have a server machine, that is the Linux ...
1
vote
0answers
86 views
Installing rpm & dependencies
I am trying to install an rpm, namely the Oracle 10g database for CentOS 6 for testing an app.
The problem is that the machine the OS is installed on does not have access to the internet and there ...
1
vote
1answer
27 views
How reliable of using “nameofmychoice=”anyname“”
For backup MySQL MyISAM database, I'm using:
backupdb=siteone
mysqldump -u root -pthepass --lock-tables --add-locks --disable-keys --skip-extended-insert --quick $backupdb > /var/www/html/db2.sql
...
2
votes
0answers
329 views
Automatically update MPD database upon external storage insertion
I have an Alix board in my living room running Voyage MPD edition and acting as jukebox.
In order to play "guest" music, I would like that MPD automatically updates its database with the content of ...
2
votes
1answer
147 views
How to solve “/usr/bin/ld: cannot -lodbcinst” problem during FreeTDS installation
I have installed unixodbc for Microsoft SQL Server support in Linux. I want to connect PHP on Linux to a MS SQL server. I tried to install FreeTDS opensource , but it gives me following error.
...
11
votes
11answers
8k views
Grep huge number of patterns from huge file
I have a file that's growing about 200,000 lines a day, and it is all formed with blocks of three lines as such:
1358726575123 # key
Joseph Brunner # name
carpenter # job
...
2
votes
1answer
96 views
MSSQL database server on UNIX
I have heard rumors, but did not manage to find anything more, about some sort of MSSQL serving on UNIX machine, or MSSQL/MySQL server, that can handle MSSQL storage.
I would like to know, if it is ...
0
votes
1answer
486 views
Gracenote database
I use GRIP to convert compact discs to a format that can be copied to an IPOD using AMAROK. By default, GRIP connects to freedb to get disc and track information. I've been told that the Gracenote ...
1
vote
3answers
764 views
Error dropping database in MySQL 5.1 on Ubuntu
I am using MySQL v5.1 on Ubuntu machine.
I have a database named my_db which I would like to drop it, so I execute command:
mysql> drop database my_db;
ERROR 1010 (HY000): Error dropping ...
1
vote
4answers
906 views
Restart MySQL server
I am using MySQL v5.1 on Ubuntu machine.
MySQL on my machine used to work. (Running mysql -u root gave me the MySQL command line.)
This afternoon, I did the following thing:
1. check active process ...
1
vote
2answers
2k views
MySql: LOAD DATA INFILE
I am using MySQL v5.1 on Ubuntu machine.
MySQL data directory is /var/lib/mysql/
I have a test.dat file located on /var/lib/mysql/tmp/test.dat
I would like to load data from the test.dat file into ...
1
vote
1answer
61 views
dump out some tables of the database
I am using MySQL v5.1 on Ubuntu machine.
I have a database named db_test which contain tables like cars, customers, departments, prices , and so on.
I know I can use the following commands to dump ...
2
votes
2answers
3k views
Can I copy a MySQL database by copying the files? What do the files contain exactly?
I am using MySQL database and using an Ubuntu Linux machine.
My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following:
...
3
votes
2answers
440 views
Simple shell script needed to move database files
I am using MySQL on Ubuntu machine.
I need to physically move around the database files under /var/lib/mysql/ (this is where all the databases directories are located).
Say I have two databases, ...
10
votes
4answers
526 views
Standard key/value datastore for unix
I know about the key/value libraries for unix (berkeleydb, gdbm, redis... ). But before I start coding, I wonder if there is a standard tool for unix that would allow me to perform the following ...
3
votes
2answers
266 views
Databases for embedded Linux?
I need to choose a database for an application on an embedded linux platform.
Any suggestions on which databases are typically used with embedded linux?
Please let me know.
Regards
Radha.
