Database is an organized collection of data.

learn more… | top users | synonyms

1
vote
0answers
45 views

Convert / import flat file with multiple records, one variable per line

I am searching for an efficient way using (UNIX) command line tools to read a flat file into a(ny) database, perhaps after first converting to an intermediate structured format, for example XML or ...
0
votes
2answers
10 views

Simulate PostgreSQL query timeout

I would like to test the behaviour of a program which executes queries to a PostgreSQL server in case of a query timeout. How could I simulate that?
1
vote
1answer
30 views

How to get the structure of a GDBM database

Modem Manager GUI creates a database named sms.gdbm to store all the SMS details. Currently Modem Manager GUI is not providing a feature to simply delete all received/sent messages. So I'm trying ...
0
votes
1answer
21 views

Are there CLI programs or commands to manipulate *.gdbm files

Modem-manager-gui stores it's all the messages to a *.gdbm file. Deleting sms.gdbm file removes all the messages but I'm trying to do a shell program to delete received and sent separately. I tried ...
0
votes
0answers
6 views

How to make roundcube work with pgsql?

roundcube & pgsql are running on different containers docker run --name to-postgres --expose 5342 -e POSTGRES_USER=roundcube -e POSTGRES_PASSWORD=roundcube -d postgres Now how shall I install ...
2
votes
1answer
19 views

Can the vacation e-mail auto-responder cope with Berkeley DB version skew?

We have a typical account domain with NFS home directories, accessible by the mail server as well as various user workstations. Do the versions of the vacation package installed on the mail server ...
0
votes
1answer
12 views

Transfer Schema and Rebuild Databse on Another Server

I have made a number of changes to the database schema on my development including the addition of new tables and changes to others. Is there an easy way to transfer this schema to the server, build ...
0
votes
1answer
19 views

How to determine which Berkeley DB version is used for RPM's database?

I am attempting to read and write the RPM database located in /var/lib/rpm under CentOS 5, and eventually other system types (CentOS 6, RHEL, etc.) The problem is that I don't know what version of ...
0
votes
0answers
11 views

Share Oracle Database Connection from one system to another in same network

I have installed Oracle 11g XE in one machine, which has cent os 6.5 installed in it. Now i want to connect to this machine's oracle database from an another machine. Both are connected to the same ...
10
votes
1answer
124 views

Does anyone actually use and benefit from transparent huge pages?

I've been struggling with transparent huge pages performance issues of late, and noticed many database systems recommend turning it off. I am talking Oracle, Postgresql, MySQL, Cassandra, NuoDB, ...
3
votes
1answer
34 views

centralized Address/phone book able to sync with thunderbird

In my office we are looking for a service able to store and manage all the phone numbers and adresses we have and capable of synchronize the database with clients (e.g. thunderbird) on personal ...
1
vote
1answer
66 views

delete redis keys that have been inactive for 30 days

I've installed a web app called scrumblr which uses redis as a database. What I am attempting to do is delete all keys that have been inactive for 30 days, or have not been accessed in 30 days. I ...
0
votes
2answers
204 views

import .sql file into a remote server from a local machine

I've created a database in the remote machine. Currently, the database is empty and I need to import using a backup(.sql) file. The backup file is in my local machine, it is a 40gb file. And the ...
0
votes
1answer
123 views

How to move mysql database and mysql server to another machine

I am having Ubuntu 14.04 desktop in which i develop software. Due to some reasons my hard disk has developed many bad sectors. I want to move my mysql server software and all the databases to a new ...
2
votes
1answer
55 views

Option --skip-slave-start Not Working with Systemctl

I just started with centos 7. I'm trying to get replication working and am attempting to start mysql without starting the slave (so that I can set the pointers as to where it's supposed to resume ...
0
votes
0answers
37 views

Is there a `find` command that uses a database, like `locate`?

locate is simple yet quick because it's database based. find offers much more options but it's slower because it actually browses the filesystem each time it's invoked. So.. find using a database ...
1
vote
1answer
471 views

How do I run a service with numactl

I need to do something like this to run MongoDB $numactl --interleave=all /usr/bin/mongod --config /etc/mongod.conf & What should I change to be able to run the mongo daemon with the options ...
1
vote
1answer
33 views

Changing redis filesystem writing behaviour

The filesystem usage of redis is peaking every 20 minutes at the moment on my server. Sometimes from 63.1% to over 90.9%! This causes my monitoring to send me alerts if its over a longer time-frame. ...
0
votes
0answers
323 views

upgrading Berkeley DB rpm in a Centos OS

I have a software which need Berkeley DB 4.5 or above. But in my CENTOS 5.11 x86_64 Server I have Package db4-4.3.29-10.el5_5.2.x86_64 already installed and latest version Package ...
1
vote
2answers
146 views

Databases backup with cron

I'm trying to set up a cron job in order to backup my databases daily. Here's what I wrote in my crontab file : 25 18 * * * root mysqldump -u root -p myPassWord --all-databases | gzip > ...
0
votes
1answer
1k views

Centos 6.6 can't install couchdb from EPEL repository

the issue is about unavailability of couchdb package in EPEL. Has somebody faces the same issue? yum repolist gets Loaded plugins: fastestmirror, priorities Loading mirror speeds from cached ...
0
votes
1answer
408 views

How to use grep and cut together?

Lets say I'm doing a database for fruits. Using a text file for it, inside contains, in this format, (Fruit:Quantity:Cost) Apple:10:1 Orange:20:2 Pears:10:3 Banana:20:4 10 Apples at $1 each. 20 ...
0
votes
1answer
26 views

Does mysql user exist in MySQL database system

I searched mysql.user table and did not find any user named as mysql. root is the default username. I am curious to know whether mysql user exist or not? If yes, what is the purpose of this user? ...
2
votes
1answer
51 views

Ways to store data for command line API

I am developing an API in Unix environment for virtual machines. I have to store some information in a table about virtual machines. Currently I am using python dictionary of virtual machine objects ...
2
votes
2answers
62 views

What is best and secure way to save application settings?

Let's say I have an application which has plugins, daemons, etc. Now It has to save its settings and plugins settings as well as too. Most of all applications use users home folder for it but it is ...
0
votes
1answer
2k views

After upgrade MongoDB it does not start and log is empty

Can you help me with this problem please? I have updated (apt-get upgrade) my system Debian GNU/Linux 7.6 (wheezy) but for problem with disk space operation failed. After I have released disk space, ...
0
votes
0answers
49 views

PgPool - Host Based Routing

I'm using pgpool to distribute my connections between my master and slave postgresql databases. What I would like to know is if there is a feature where I can tell pgpooler to route connections ...
2
votes
3answers
3k views

Query Firefox password database

Braiam said that Firefox stores the password data for login websites in ~/.mozilla/firefox/key3.db and ~/.mozilla/firefox/signons.sqlite files. These files can be read with some sqlite editor. I ...
-2
votes
1answer
49 views

unix oracle connectivity [closed]

Operating system : Windows8.1 i use Linux ubuntu using vmware Today i have installed oracle database 11g release 2 in particular drive i want to access database via linux/ubuntu i able to ...
0
votes
1answer
38 views

similar content Project access from a single file [closed]

I create three different project which are access different three different database. Except that all project files are same. so, I want that in a project folder all project files and in other two ...
0
votes
1answer
335 views

How to install IBM DB2 Database Driver on Ubuntu for Node.js

I need assistance installing IBM DB2 drivers onto Ubuntu. Using Ubuntu 14.04, I'm attempting to create a simple web page that gets served by the node.js server-side framework. A ...
2
votes
1answer
245 views

mysql restoration process takes longer time

I have a Ubuntu 8.04 machine which has around 300 GB size mysql databases. I have dumped all the databases using the mysqldump command as below. mysqldump -u root -p --all-databases > file.sql ...
0
votes
0answers
99 views

Storage Formats for Flat File DB

Currently I use a flat file database with find -type f -ls to store information for about 400GB of files. I'd like to store also the md5sum/sha[1|256]sum of the files. Because the files are often ...
2
votes
0answers
106 views

VoIP dialer for SIP

I have some Java, so am biased in that direction, but not overly so. None of the Java suggestions: http://stackoverflow.com/questions/16471795/sip-client-for-java ...
2
votes
1answer
75 views

XML command line tool postgres

I have an XML files to read and load into database daily at night (cron) So i planed to do this in a batch. Is there any command line tool to : 1. Create a postgres schema using an XSD file? 2. ...
1
vote
1answer
139 views

I'm looking for a free database package for Ubuntu

I need to operate a database for personal use. Now I'm using Ubuntu 14.04 LTS, as opposed to Windows operating system, I'm wondering if there's a dBase, Lotus123 or Access equivalent for Linux? ...
1
vote
0answers
951 views

How to set up Active Directory authentication on CentOS 6.5?

I have: 1. A CentOS machine to which I have SSH and STFP access. 2. The machine is on network where there is a MS SQL Server database and Windows shared drives. 3. All authentication seems to be with ...
3
votes
2answers
6k views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
1
vote
2answers
258 views

What network protocols do database servers use?

I have a postgres 9.1 server running on the default port 5432 on an ubuntu 12.04 cloud server. I want to open up the port so I can make remote queries -- but I have to open the port on IP tables, ...
0
votes
0answers
78 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
1
vote
2answers
306 views

Is it possible for a OpenVZ container to interact with a MySQL database on the host?

Say every container and the host itself has its own dedicated, external IP. Is it possible to do this without any problems? And is this really a good plan? Instead of hosting a database per ...
3
votes
1answer
9k views

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a ...
0
votes
1answer
51 views

Lock on IBM DB2 database on Linux server [closed]

My db2 database is running on Linux server, Some time database table got lock by some of db user due to uncommiting the session. My question is that how we can find out through which ...
2
votes
1answer
210 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
178 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
2answers
805 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
2k 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
329 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 ...
0
votes
3answers
8k 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
1answer
479 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 ...