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
0answers
21 views

What is the lightest linux distro for database work [on hold]

I need help finding a Linux distro that is good for running postgreSQL, I need it to be stable and as light as possible. Anyone has some sugestions?
-1
votes
0answers
38 views

Is there any tools to handle problems automatically? [on hold]

I have about 58 machines(Linux) and 165 databases(relational and nosql) that i need to make sure they are working well and services are running without problems. i have a monitoring tool that monitor ...
0
votes
0answers
21 views

calling awk programs from python script [migrated]

I am working on a script. I have bits and pieces what I am trying to bring them together, however....the script handling the login into devices and collecting the data is written in python. #!/usr/...
0
votes
0answers
31 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 ...
2
votes
1answer
36 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
0
votes
1answer
47 views

LAMP DB-agnostic way to create a DB stack

Is there a LAMP-MySQL (or equivalent) agnostic way to create a DB stack that includes: DB-user and a relative password DB with the same name as of the user Setting a host for the DB (say, localhost) ...
0
votes
1answer
88 views

How to compile a “.pc” file on Debian 9?

I need to compile a Pro*C - .pc file on Ubuntu. So far what I have realised is that I need a Pro*C compiler to translate the Pro*C - .pc file into pure / standard C code.  But I need to have Oracle ...
-1
votes
3answers
177 views

Grep content for multiple files

My OS is Sun Solaris. SunOS sintscdldmu001 5.11 11.3 sun4v sparc sun4v I gave the command alter database backup controlfile to trace; and happened to forget it. When i needed the contents of the ...
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
1answer
54 views

mysqldump on mariadb 10 extremely slow [closed]

I'm running a MariaDB 10.1.34 instance on AWS RDS. Instance specs are as follows: Instance Class: db.t2.large Storage: 100GiB gp2 DB Size: 1.2 GiB I'm trying to create a mysqdump from an EC2 ...
1
vote
1answer
155 views

sh script for executing mysql script with entering pass [closed]

I'd like to execute a mysql script where user is asked to enter the password dynamically from the command line. If possible with a message Enter your $root password However it doesn't work as expected ...
0
votes
1answer
338 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,...
-1
votes
1answer
44 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 ...
-2
votes
1answer
518 views

How to create a new database and collection using pymongo?

I want to create a database and collection using python script so that I used pymongo driver. But I am unable to create database. Steps I followed: from pymongo import MongoClient con = MongoClient('...
-2
votes
1answer
174 views

CentOS : Is the port-5432 for me not accessible via internet?

We installed a new CentOS server for testing and the configuration was a bit different as compared to debian. I am unsure at this moment if the port-5432 is secure for us. If not, how can I secure ...
0
votes
0answers
94 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
2answers
577 views

SQLite3 Query storing IP address syntax error

I'm trying to run a sqlite3 query against a small DB to update a table. While the script is more complicated, for testing I set the following variables: DN=123 UP=123 downlocalip=10.1.2.3 ...
0
votes
1answer
545 views

DROP USER IF EXISTS syntax error in MySQL CLI

I use Ubuntu 16.04 with Bash and MySQL Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper. I try to create a DB stack for a webapp (WordPress) directly from command line and I share ...
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?
2
votes
1answer
90 views

Using a single command-line command, how would I search every text file in a database to find the 10 most used words?

This answered question explains how to search and sort a specific filename, but how would you accomplish this for an entire directory? I have 1 million text files I need to to search for the ten most ...
1
vote
0answers
90 views

Mysterious problem: Deleting massive amount of files doesn't free up disk space [duplicate]

I have a disk that is 100% used, 400 GB of 400 GB, however I have moved more than 44 GB of files from it, but no extra space got available, the usage is still 400GB of 400GB. Filesystem ...
-1
votes
1answer
217 views

Shortening of DB and WordPress instance creation script

How could I further shorten the following script who's purpose is to create a database && WordPress instance and then change permissions per the domain given and restart the server? ${domain} ...
0
votes
1answer
800 views

How to change adminer's default port?

My Adminer (Database management in a single PHP file) runs on a Debian Server, and I want to move my database management web login screen from port 80 to port 50001. How can I do it ?
2
votes
1answer
77 views

Is there any database solution that can do master-master replication by default on OpenBSD?

There are many "built-in" softwares for OpenBSD, ex.: NTP, LDAP, RADIUS, etc., see all (?): https://github.com/openbsd/src/blob/master/etc/rc.conf in the rc.conf file. The question: Currently, ...
-1
votes
1answer
519 views

Variable won't get expanded when INSIDE mysql shell

Before creating a new mysql user and DB, I did: read sps -s # Inputing and saving the sps (password) value. echo ${sps} # sps password value echoed. mysql -u root -p[PASSWORD] mysql>...
1
vote
1answer
84 views

Exporting and importing a mysqldump from within a mysql CLI heredocument

The following code drops a DB user and a DB instance by the name of test, if both exists, then creates an authorized, all privileged DB user and a DB instance with the same name (also test). mysql -u ...
0
votes
2answers
182 views

how to import customers to dolibarr

I have a rough and ready table as: mysql> mysql> show tables; +----------------------+ | Tables_in_businesses | +----------------------+ | 2017july | +----------------------+ 1 row ...
0
votes
2answers
28 views

Program to instantly host a mysql database from a dump file [closed]

I'm looking for a utility program which can take a dump of a mysql database and basically host a "fake" or minimal mysql server with that data for testing another program which requires it. Has ...
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
237 views

Clear OS-level cache

I have Red Hat Enterprise Linux 6 with Oracle 12c database. I am doing performance benchmarking but there seems to be an OS level cache causing only 1st time read to take significant time. How can I ...
3
votes
1answer
348 views

How can I calculate the average of multiple columns with the same value for the first two columns?

I have a file of about 13 million lines like: Lat Long air_temp sst wind_speed wave_height wave_period 65.3 7.3 4.3 8.8 7.7 4 8 61.6 1.3 -9.99 8.8 9.8 4 7 61.2 1.1 -9.99 8.8 7....
1
vote
2answers
87 views

Searchable database of Linux commands [duplicate]

Is there a searchable database of Linux commands? I'm new to the sport, and alot of information here assumes alot of knowledge I (and I'm sure many others) do not possess. However, I learn quickly, if ...
0
votes
1answer
365 views

PostgreSQL Remote Connection on NAS Synology DS216j

This is what I would like to achieve: I have postgreSQL database running on NAS Synology Diskstation DS216j connected to my router. I want to be able to connect and use the database from remote ...
25
votes
3answers
4k views

What kind of database do `updatedb` and `locate` use?

The locate program of findutils scans one or more databases of filenames and displays any matches. This can be used as a very fast find command if the file was present during the last file name ...
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
622 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 ...
3
votes
1answer
2k views

Making a cron-scheduled database backup (dump) without exposing the password in /etc/crontab

I use the following /etc/crontab code to create daily backups of my database in limit of the last 30 days: 0 8 * * * mysqldump -u root -PASSWORD --all-databases > /root/backups/mysql/db.sql 1 ...
0
votes
1answer
821 views

PostgreSQL Failed to startup

I am having trouble with starting PostgreSQL on my CentOS system. Here are my error logs below. Any help will be greatly appreciated. 2017-04-25 03:18:12.553 CDT > LOG: could not bind IPv6 socket:...
-2
votes
1answer
440 views

Start PostgreSQL Service Failed [closed]

When I try to start my postgresql server on CentOS I get a message to say that it has failed to start it. I have made sure to initialise the db using "service postgresql initdb". Does anyone have any ...
1
vote
1answer
708 views

LVM: is it possible to extend an in use partition?

I have a disk in which I store the data of a DB. The disk is full now and I want to add another disk to the machine. I heard that by LVM you can add and extend partitions, so I would like to know if ...
0
votes
2answers
342 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
vote
1answer
146 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 ...
0
votes
2answers
60 views

Wrong syntax in sql

I have a table called sp_en and this table has 2 columns: "no" and "value". I want to change "value" of row with "no": 4433 to 1 so I enter the command below: INSERT INTO sp_en (Say) WHERE no='4433' ...
0
votes
1answer
69 views

Solaris 10 /var/adm/perfdata

The /var partition is 100% full. The partition looks something like this: rpool/ROOT/var 15G 3.4G 25M 100% /var 1.4G /var/adm/perfdata I need to delete files from that folder, but I ...
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 ...
0
votes
1answer
144 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 ...
1
vote
0answers
26 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.
2
votes
3answers
3k views

Does killing a process close all files opened by that process?

I want to kill a process which has an open connection to a database. If I kill the process, can I make sure that the database is unlocked?