Database is an organized collection of data.

learn more… | top users | synonyms

0
votes
2answers
150 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
49 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 ...
1
vote
1answer
322 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
26 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. ...
1
vote
1answer
195 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) ...
0
votes
1answer
9 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
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
23 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? ...
0
votes
1answer
313 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
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 ...
2
votes
0answers
100 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
0answers
483 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 ...
1
vote
0answers
935 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 ...
1
vote
0answers
271 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
0answers
110 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 ...
0
votes
0answers
10 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 ...
0
votes
0answers
36 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 ...
0
votes
0answers
251 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 ...
0
votes
0answers
56 views

PGPool not responding even though it is running

Last night our application stopped serving requests because PGPooler was not responding anymore. I logged into the pooler box and the service was up and running. I looked into the logs and the ...
0
votes
0answers
48 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
0answers
89 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 ...
0
votes
0answers
65 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 ...