Database is an organized collection of data.

learn more… | top users | synonyms

0
votes
0answers
27 views

Installing Ubuntu and PostgreSQL database on different drives

I just received a new root server with the following drives: Disk /dev/sda: 480 Gb Disk /dev/sdb: 480 Gb Disk /dev/sdc: 240 Gb This one: ...
0
votes
1answer
21 views

DBD/DBI: Crashes if a program is forked

The below program works if the $crash parameter is not set: $ perl example mysql://:tange@/tange/mytable dburl mysql://:tange@/tange/mytable databasedriver mysql user password tange host port ...
0
votes
0answers
42 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. Linux CentOS 6 Apache 2.4 PHP 5.5 I've been receiving tons of high 5 ...
0
votes
1answer
153 views

Failed to open the bootstrap file in MySQL

After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
2
votes
0answers
16 views

Migrating data from SCO OpenServer 5.0.6

I've been tasked to migrate data from an old HP NetServer LH3000 running SCO OpenServer 5.0.6 (circa 1998). I've had a good amount of experience dealing with Unix/Linux systems. However, this is ...
2
votes
1answer
26 views

Simplest way to add a data lookup to an HTML website on Ubuntu?

I want to learn how to make the simplest possible data lookup function on a website. I don't want to use any of the usual tools such as MySQL or a CMS or any other heavy framework. I set up an Ubuntu ...
0
votes
1answer
23 views

Linux storage database access methods - Hash and recno

There are plenty of other better file system organization methods but why does linux use these in specific ?
-1
votes
1answer
17 views

Physical Backup of Maria DB as a snapshot using LVM

I have a SQL database which I want to backup as a snapshot. I want to use LVM to do so, but I am not able to do it. Also my database is not stored in a LVM partition but its located in my /dev/sda2 ...
-1
votes
2answers
27 views

putting output into sql table

I am trying to convert the output of ps awux into 11 fields with the headers eliminated and then importing that output into an existing table in SQL.
0
votes
3answers
146 views

Use Command Line Argument and Variable with sed Inside Bash Script

I have a bash script that takes a bunch of command line arguments. The only one that matters in this context is the first, $1, which is a text file. The header is very long, below are examples of ...
0
votes
0answers
14 views

How to monitor system, Database Query Values, and the Existance of Files?

I was looking through an old system today, and it had this monitoring software that could send out email alerts. It's very old, but it still seems interesting and useful. It allowed for monitoring ...
1
vote
1answer
38 views

PostgreSQL Accessible to Web Application

I have a server with PostgreSQL installed and there are scripts that are constantly modifying data in the database. PostgreSQL is running on it's default port 5432. I would like to be able to connect ...
4
votes
1answer
57 views

Making graphs from database with Time/Date field

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part. To explain ...
0
votes
0answers
49 views

“[unixODBC][Driver Manager]Data source name not found, and no default driver specified” When using Teradata ODBC Drivers

I am running a PHP script on a RedHat server using Teradatas ODBC drivers. <?php $conn = odbc_connect("Teradata", "username", "password"); $result = odbc_exec($conn, 'SELECT count(*) FROM ...
0
votes
1answer
263 views

Kali linux starting and initializing the database errors

I have been trying to use Armitage and I have been following this tutorial, and at step 2.2, I get these errors: root@Xeno:~# service postgresql start [....] Starting PostgreSQL 9.1 database ...
1
vote
0answers
86 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 ...
1
vote
2answers
92 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
119 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
72 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
14 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
30 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
16 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
146 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
20 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
224 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
57 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
162 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
2answers
721 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
354 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
180 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
47 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
1k 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
55 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
653 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
246 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
2k 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
652 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
29 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
58 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
89 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
1answer
4k 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, ...
3
votes
3answers
5k 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
57 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
39 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
501 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
333 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
115 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
143 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
106 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
249 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? ...