Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [database]

Database is an organized collection of data.

203 questions
27
votes
3 answers

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 database update. There are many kinds of databases…
Tim
  • 98,580
  • 191
  • 570
  • 977
22
votes
6 answers

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 operations: $ tool -f datastore.db put "KEY" "VALUE" $…
Pierre
  • 1,713
  • 3
  • 15
  • 21
22
votes
3 answers

What network protocols does a Postgres database server use?

I have a postgres 9.1 server running on the default port 5432 on an Ubuntu 12.04 cloud server. I want to open up the port, so I can make remote queries -- but I have to open the port on IP tables, which requires that I specify a protocol. This doc…
bernie2436
  • 6,505
  • 22
  • 58
  • 69
19
votes
11 answers

Grep huge number of patterns from huge file

I have a file that's growing about 200,000 lines a day, and it is all formed with blocks of three lines as such: 1358726575123 # key Joseph Muller # name carpenter # job 9973834728345 Andres Smith student 7836472098652 …
admirabilis
  • 4,642
  • 9
  • 41
  • 57
19
votes
4 answers

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: /var/lib/mysql/db_test# ls cars.frm cars.MYD…
Mellon
  • 1,029
  • 7
  • 19
  • 24
13
votes
2 answers

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, Redis, Hadoop, and more. For examples: Peter Zaitsev…
James H
  • 131
  • 4
13
votes
4 answers

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 Month Month Day of Week Command …
pbaldauf
  • 265
  • 1
  • 4
  • 8
9
votes
1 answer

Does quiesce exist for Linux?

Quiescing a file system allows you to make a backup of the database while it is still running and other programs and their data as well. The application generally needs to be notified of the quiesce backup operation because all the buffers need to…
leeand00
  • 4,443
  • 10
  • 51
  • 78
9
votes
2 answers

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 ran redis-cli KEYS* Which returns all of the keys,…
Muji Sayed
  • 91
  • 1
  • 1
  • 3
6
votes
2 answers

Databases for embedded Linux?

I need to choose a database for an application on an embedded linux platform.
Radha Krishna. S.
  • 91
  • 3
6
votes
6 answers

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 try to query for my username and password of a…
Tim
  • 98,580
  • 191
  • 570
  • 977
5
votes
2 answers

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 Document Storage' file. I'm running elementaryOS…
schtocker
  • 67
  • 1
  • 1
  • 7
5
votes
3 answers

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, namely: termsql - which takes stdin or a file…
JoséNunoFerreira
  • 183
  • 1
  • 7
5
votes
1 answer

Copy csv data while simultaneously filling serial column

I've created my first postgres table and i'm trying to work out how to copy a .csv file into the table, whilst simultaneously generating a serial number number in column 1 (ID) which starts at number 1 and counts upwards (i.e. 1, 2 ,3 etc) for each…
neilH
  • 433
  • 1
  • 8
  • 19
4
votes
2 answers

Data extraction of entire DB on SCO Openserver 6

Firstly apologies if this question seems like a wall of text, I can't think of a way to format it. I have a machine with valuable data on (circa 1995), the machine is running UNIX (SCO OpenServer 6) with an unknown database stored on it. The data is…
bendataclear
  • 151
  • 4
1
2 3
…
13 14