Database is an organized collection of data.

learn more… | top users | synonyms

1
vote
0answers
39 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
8 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
29 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
5 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
11 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
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
4k 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 ...
10
votes
1answer
120 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, ...
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 ...
2
votes
2answers
536 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 ...
3
votes
1answer
33 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
446 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 ...
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
2answers
195 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 ...
1
vote
1answer
63 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
1answer
116 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
54 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
1answer
329 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 ...
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
31 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. ...
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 ...
0
votes
0answers
315 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
140 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
399 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
25 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
60 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 ...
1
vote
2answers
254 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
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 ...
0
votes
1answer
50 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
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 ...
2
votes
1answer
241 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
97 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
105 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
70 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
137 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
947 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 ...
2
votes
3answers
263 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 ...
1
vote
4answers
2k 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 ...
0
votes
0answers
77 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
301 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 ...
2
votes
1answer
209 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
202 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) ...
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 ...