Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

Database is an organized collection of data.

0
votes
2answers
351 views

stop scheduled cron jobs while database is creating

we have a multi cron jobs runing everyday on different hours. In sometime script is running too long and block database in time where we set up a new one. The problem is that, a new database is no ...
-1
votes
2answers
201 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.
3
votes
1answer
498 views

OOM Killer keeps killing mysqld

I run a CentOS vps to host a few websites with cPanel/WHM but every now and then, my websites stop working because it can't establish a connection to the mysql database. Looking at the messages log, ...
2
votes
1answer
40 views

Kernel Support | Processors List

Where can I find the supported Processors for each Kernel Version? For example (KBL Processors) is only supported for Kernel Kernel 4.5
2
votes
1answer
177 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 csv....
1
vote
1answer
147 views

Bash script to install website

First of all, excuse me if this is the wrong place to ask this question. I made a Bash script which installs a DirectAdmin backup into Apache. The steps are working but in the end I get a 500 error ...
1
vote
1answer
1k 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 ...
1
vote
1answer
116 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
2k views

Upgrading Berkeley DB rpm in a Centos OS

I have a software which needs 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 db4-4.3.29-10....
1
vote
1answer
537 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) host("...
0
votes
1answer
23 views

Error: 17113, Severity: 16, State: 1. & Error 87(The parameter is incorrect.)

I have been installing SQL Server 2017 on CentOS7 and wanted to config it with this command sudo /opt/mssql/bin/mssql-conf setup the password & confirm password are ok. after that it gives me ...
0
votes
1answer
376 views

Data getting overwritten with same timestamp in InfluxDB

There are some data in a csv file and it is getting overwritten if the timestamp is similar, for example: ip,time,name 1.1.1.1,2018-08-31 11:12:32,python 1.2.1.2,2018-08-31 11:05:28,oracle 1.3.1.3,...
0
votes
1answer
13 views

How to measure daily number of metrics which is written to the single MongoDB instance?

Please suggest a commands to measure daily number of metrics which is written to the single MongoDB instance?
0
votes
1answer
1k views

Glassfish 4.1 on OpenJDK 8? (Netbeans)

Netbeans installed Glassfish, and shows Glassfish as running: Running the create-domain subcommand Using default port 4848 for Admin. Using default port 8080 for HTTP Instance. Using default port ...
0
votes
1answer
68 views

Best way to migrate many SQL databases

So I'm switching VPSs, and have already done a backup of all the data files and moved them over. However I still need to move all the old databases over. I've been searching the internet for the best ...
0
votes
1answer
658 views

No space left on disk (PostgreSQL)

I was trying to write a 55GB SQL file to my database. It used to crash each time. I removed logs and did some cleaning to get the server running, but the transaction never used to complete. Latter, I ...
0
votes
1answer
150 views

Unable to start database in glassfish in CentOS7

Environment: VPS, CentOS7, glassfish3, server is running. Tried: both in root and glassfish user. a comamnd: "startNetworkServer" and sudo netstat -lntp | grep 1527 nothing happened so it seems port ...
0
votes
1answer
24 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 ...
-1
votes
1answer
46 views

Risk of keep mysql data folder into linux cache

Is there a risk of doing: vmtouch -dl /mysql-data-folder On a production server with 192GB RAM and mysql data folder of 50GB. What is vmtouch? man vmtouch vmtouch opens every file provided ...
3
votes
0answers
247 views

VoIP dialer for SIP

I have some Java, so am biased in that direction, but not overly so. None of the Java suggestions: https://stackoverflow.com/questions/16471795/sip-client-for-java https://stackoverflow.com/...
2
votes
0answers
149 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
0answers
731 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
39 views

A simple utility to backup of both database (MySQL) and document root into one file

In Ubuntu-LAMP with Bash I host a few personal websites. All websites are under document root (/var/www/html). This is how I currently create immediate backups on maximally-self-managed cloud ...
1
vote
0answers
30 views

What's a good and free ER diagramming tool for Linux that is approachable via a web interface?

A web based ER diagramming tool. One that you can install on Linux and afterwards approach it via a web interface. Preferably Open source. Optional: connectivity with the database.
1
vote
0answers
20 views

Installer Oracle Server not allows to enter a value in the field

I set up a server for home testing on Virtual Box. I can't enter the letters in the field "email", only numbers, how do I fix it? Thanks for any help.
1
vote
0answers
24 views

Installing MySQL in CentOS without permissions

I need to install a MySQL that doesn't need root. The reason for this is that I'm a user in a cluster, so I don't want to mess other people work. Said that, is there a way to have a "portable" MySQL ...
1
vote
0answers
29 views

How to undertand the GPLI code, structure and database?

Where can I get the conception and database structure of the GLPI ? I didn't find any documentation in the Internet. "how to create a plugin in GPLI" in Github doesn't help me very much.
1
vote
0answers
382 views

Database client version mismatch in PhpMyAdmin

I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this: Database client version: libmysql - 5.5.50 But when I do this in the terminal: mysql -V I get ver. 5.5.52 Also in Synaptic Package ...
1
vote
0answers
58 views

Send new login & logout logs to a database

I want to know how to send new login and logout logs to a database. I know that last command outputs the "lasts" login info. But, I found the following problems: How to filter to only get new logs? ...
1
vote
0answers
229 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
32 views

Recommended recordsize for a zfs dataset hosting a Netatalk CNID backend database? (.AppleDB)

Which is the recommended record size for a zfs dataset hosting a Netatalk CNID backend database?? (.AppleDB) The plan is to use a zfs dataset exclusively for the Netatalk CNID backend, and configure ...
0
votes
0answers
101 views

Cron job fails: Could not retrieve file stat (script works when not run from cron)

I have a database backup script that works fine when I run it manually, but if I run it via cron it doesn't work and I get this in the log: Mar 11 11:58:02 ip-172-XX-Y-ZZ mysqldump: Could not ...
0
votes
0answers
70 views

Performance of FS directory structures

Given a large (hundreds of thousands objects) fs-based database of uniquely identified objects with potentially a large number of long prefixes with many objects sharing the same prefix are treeish ...
0
votes
0answers
196 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 ...