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.

-2
votes
0answers
11 views

Which is the easiest LAMP type stack to install that will let me easily set it up? [on hold]

I have configured a LAMP stack for storing and charting live data many times. However I can never remember the intracacies of configuration, and when I do the updates to software since last time ...
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....
2
votes
1answer
21 views

Does 'sudo apt-get purge postgr*' remove database files?

I ran sudo -u postgres psql -c "show data_directory" and it shows /var/lib/postgresql/9.5/main. If I understand correctly, this is the directory that stores the database files. I ran sudo apt-get ...
0
votes
2answers
46 views

Problem with Workbench

I am on Debian stretch, I am using PHP 7.1, Here is the output Info from Workbench. > MySQL Workbench Community (GPL) for Linux/Unix version 6.3.8 CE build 1228 (64 bit) Configuration Directory: /...
0
votes
1answer
24 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 ...
12
votes
4answers
38k 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 ...
2
votes
1answer
5k views

Change column datatypes in Hive database

Can I change the datatype in Hive database? Below is a complete information about the same. I have a database named "test". It has a table "name". Below is a query I had used while creating a column ...
1
vote
1answer
58 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 ...
4
votes
1answer
542 views

unixODBC documentation / manpage?

Just wondering if there is any official documentation for unixODBC, e.g. how the configuration files have to look like and what parameters they expect? (I am using only a shell, no GUI) Even http://...
9
votes
3answers
22k views

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: ...
0
votes
1answer
382 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
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 ...
16
votes
4answers
3k views

Standard key/value datastore for unix

I know about the key/value libraries for unix (berkeleydb, gdbm, redis... ). But before I start coding, I wonder if there is a standard tool for unix that would allow me to perform the following ...
5
votes
2answers
560 views

Databases for embedded Linux?

I need to choose a database for an application on an embedded linux platform.
0
votes
1answer
544 views

Couldn't connect to Larvel homestead database with MYSQL workbench

I am unable to connect to laravel homestead via mysql workbench here is how i connected Homestead Connection http://simple.harry.zone/linux/homestead_connect.png but i am facing the below issue ...
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
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 ...
-2
votes
1answer
553 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('...
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' ...
2
votes
1answer
41 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
109 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 ...
5
votes
5answers
12k 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 ...
1
vote
1answer
736 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
3answers
877 views

Running a web server/database server, need to connect to my servers- how?

I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. How do I connect to my Linux-based servers? Is there something ...
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?
0
votes
1answer
70 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
votes
3answers
217 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
192 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 ...
-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 ...
2
votes
1answer
91 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 ...
-2
votes
1answer
197 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
102 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
610 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
577 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?
1
vote
0answers
92 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
248 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
853 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
82 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
572 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>...
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
85 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 ...
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, ...
0
votes
2answers
190 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 ...
5
votes
3answers
2k views

Nice way to SQL query multiple CSV files?

I was looking for a way to traverse CSV files as relational database tables. I did some research as nothing I found fit my bill of requirements in its entirety. I found several partially good options,...
0
votes
1answer
246 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 ...
1
vote
1answer
6k views

How to open OLE2 Compound Document Storage database?

I have file called Thumbs.db that I seem unable to open with anything. SQLite Database Browser can't do it, nor can LibreOffice Base. Opening up the file properties tells me it's an 'OLE2 Compound ...