Questions tagged [database]

A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

Filter by
Sorted by
Tagged with
92 votes
8 answers
142k views

"FATAL: lock file "postmaster.pid" already exists"

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
AdamT's user avatar
  • 1,083
39 votes
4 answers
94k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
fazpas's user avatar
  • 1,603
29 votes
2 answers
46k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
chrisjlee's user avatar
  • 4,010
26 votes
4 answers
85k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
vonhogen's user avatar
  • 2,379
23 votes
2 answers
69k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
Shaz's user avatar
  • 651
21 votes
5 answers
3k views

What happened to WinFS?

The most interesting feature that was ever connected to what eventually became Vista was WinFS, a revolutionary (so it seemed, at least back then) new way of storing and accessing information on a ...
20 votes
5 answers
58k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
emeraldhieu's user avatar
20 votes
4 answers
57k views

Setup a Docker container to work with a local database

I'm trying to setup a Docker container to work with a local database. The image is this one https://hub.docker.com/r/tuxgasy/dolibarr/ and it suggests to also create a mariadb container, and link it ...
Sekhemty's user avatar
  • 9,396
19 votes
5 answers
32k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
Bobby's user avatar
  • 8,974
17 votes
1 answer
17k views

Cleared vs. Unformatted partition in GParted

I am running a database-like application that writes and reads data directly to and from a raw block device. I would like to create a new partition for this purpose, and I am using GParted. I've ...
nday's user avatar
  • 339
14 votes
4 answers
20k views

What FLOSS DB design tool for Linux would you recommend? [closed]

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
14 votes
4 answers
6k views

Is there a Internet PC Parts database? Like IMDB except it's about PC parts: motherboards, CPUs, Power supplies etc etc [closed]

I would love to have a central place where information about all PC parts are kept. Even better if the whole database can be downloaded as CSV and analysed using R or SAS.
xiaodai's user avatar
  • 1,223
13 votes
2 answers
695 views

Can a file system's logical structure (including symlink targets) be represented in a single lightweight file (non-binary)?

After playing with multiple SQL and NoSQL databases over the years I feel the best way for me to ensure portability in my personal apps that are data-centric is to avoid all bonafide databases ...
Sridhar Sarnobat's user avatar
12 votes
2 answers
38k views

What is a DDL script in the context of databases? [closed]

What is a DDL script in the context of databases?
user avatar
10 votes
7 answers
2k views

School Management System [closed]

I am looking for a school management system to replace a homegrown Access db. It should be able handle the following for both a Primary and Secondary school Scheduling classes Student ...
Paul's user avatar
  • 436
10 votes
4 answers
13k views

Linux GUI Database Manager [closed]

Does anyone Know any KDE application for working with databases in a unified way? It must support several DBs (sqlite, MySQL, Oracle). GTK apps are also welcome :)
kolypto's user avatar
  • 3,081
10 votes
3 answers
9k views

What file format/database format does Picasa use?

I am trying to figure out what file format the .db file and .pmp files are. I tried using db_dump (Berkeley DB) for the .db files, but it seems that they are not Berkeley DB, or of an older version. I ...
Raymond's user avatar
  • 2,600
10 votes
2 answers
8k views

PowerShell zip file synchronously

In a PowerShell script, I want to zip a folder before deleting the folder. I run the following (I don't remember where I found the snippet): function Compress-ToZip { param([string]$zipfilename) ...
Steve B's user avatar
  • 2,212
9 votes
5 answers
17k views

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. ...
user18352's user avatar
  • 213
9 votes
2 answers
12k views

How to connect to Oracle DB via ODBC

I am attempting to connect to a remote Oracle DB via ODBC. I am totally inexperienced and fail to connect. What I have installed: Oracle 'ODBC Driver for RDB' A program I want to connect from (...
Topocalma's user avatar
  • 113
8 votes
2 answers
6k views

What embedded database format is used by this Chrome extension?

Chrome extension F.B. Purity writes its data at ~/.config/chromium/Default/Local Extension Settings/ncdlagniojmheiklojdcpdaeepochckl/000003.log (not a log file despite its name). This file is a kind ...
Nicolas Raoul's user avatar
8 votes
2 answers
52k views

Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
Griffin's user avatar
  • 93
8 votes
2 answers
15k views

Creating a SQL Server Compact Edition database file in Microsoft Visual Studio 2017

I'm following a tutorial for using C# in Microsoft Visual Studio 2017 Community edition. I'm supposed to add a new SQL Database to my project and give it the extension .sdf. In the tutorial they ...
Daniel's user avatar
  • 233
8 votes
3 answers
33k views

InfluxDB failed to start as a service

I'm trying to configure InfluxDB for Automatic start-up on a RHEL7 machine. if I do: sudo systemctl start influxdb the service fails [dadmin@localhost dashboard]$ sudo systemctl start influxdb [...
Davide's user avatar
  • 131
8 votes
2 answers
18k views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
Angelo's user avatar
  • 1,073
8 votes
1 answer
4k views

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
maurox's user avatar
  • 181
7 votes
2 answers
29k views

How can I create a database in PostgreSQL on Windows 7?

I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database. I tried with createdb mydatabase but I got this error message: createdb: could not ...
Jonas's user avatar
  • 27.5k
7 votes
5 answers
3k views

Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm

I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am According to this article it seems it should ...
purefusion's user avatar
7 votes
2 answers
1k views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
RossFabricant's user avatar
7 votes
4 answers
762 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
littlejim84's user avatar
6 votes
2 answers
6k views

Is the format/schema of the Apple Music “Library.musicdb” used in macOS Catalina documented anywhere? [closed]

As folks know, Apple abandoned iTunes with macOS Catalina. I use Logitech Music Server to drive my Transporter (a networked music player) for my home music system. Logitech Music Server has a Python ...
Dylan McNamee's user avatar
6 votes
3 answers
10k views

How to read key3.db and logins.json in plain-text?

How do I get key3.db and/or logins.json to print in plain-text using commandline? $ cat /home/*/.mozilla/firefox/*.default/key3.db $ cat /home/*/.mozilla/firefox/*.default/logins.json
user737988's user avatar
6 votes
1 answer
2k views

Where does the Lazarus Chrome extension store its database?

Lazarus' website is down, so I can't look this up. Where in Linux should I look to find its SQLite database of saved forms?
isomorphismes's user avatar
6 votes
3 answers
3k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...
Léo Léopold Hertz 준영's user avatar
6 votes
1 answer
491 views

How an unprivileged user could kill a process she didn't start?

I stumbled upon something very surprising which I cannot understand on a Red Hat EL 5.6 box : the user hri (which is in the group dba) is able to kill processes owned by user oracle (which is also in ...
Mathieu MD's user avatar
5 votes
5 answers
14k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
Jeremy T's user avatar
  • 159
5 votes
2 answers
26k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
GiddyUpHorsey's user avatar
5 votes
1 answer
93k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
B-Ballerl's user avatar
  • 256
5 votes
1 answer
23k views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
Utf8's user avatar
  • 51
5 votes
3 answers
7k views

How does geolocation based on IP address work?

As all Internet users, I've visited web sites which appear to know in which country and city I'm located. I understand that these web sites typically look up my IP address in a database which maps IP ...
Martin's user avatar
  • 105
5 votes
1 answer
8k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = 'kslap208'...
Alex Gordon's user avatar
5 votes
5 answers
18k views

How do I synchronize multiple Access Databases together?

I'm conducting a study, where we will be collecting data using Access. Since there will be multiple persons conducting these studies using the same structured Access DB we need to figure a way to ...
James Mertz's user avatar
  • 26.3k
5 votes
2 answers
6k views

How to view photos in "Photos Library.photoslibrary" created by Mac OS Catalina in Linux & Windows

I have a Mac. I also have a NAS. I sync files by using rsync(in the right way). After synchronization, I can see the "Photos Library.photoslibrary" is recognized by Linux as a folder. [i@one ...
user avatar
5 votes
1 answer
3k views

How to recover Chrome extension settings from LevelDB

I have failure when Chrome eat too much RAM and I get out or RAM, when that happen in Chrome crashed addon Tabs Outliner which I use to store and unload many tabs, writing notes, e.t.c. When that ...
XCanG's user avatar
  • 153
5 votes
0 answers
465 views

Optimizing Firefox I/O regarding storage-sync-v2.sqlite-wal file (storage-sync-v2.sqlite database write ahead log file)

In my experience, Firefox creates a storage-sync-v2.sqlite database in each of its profile folders. This appears to happen even if profile syncing is disabled (and has never been enabled). What's odd ...
End Anti-Semitic Hate's user avatar
4 votes
4 answers
19k views

What's the equivalent of Microsoft Access on the Mac?

I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to ...
user avatar
4 votes
3 answers
2k views

How are sites like Pinterest able to hold all those pictures?

Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
user avatar
4 votes
4 answers
7k views

Is there a GUI interface for sqlite? [closed]

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
Keltari's user avatar
  • 73.2k
4 votes
1 answer
5k views

locate command does not work on mac terminal

I'm working on Mac (Catalina, 10.15.7) and want to use the locate <...>-command. After typing locate ... it suggested me the following, which I did. WARNING: The locate database (/var/db/locate....
NilsK's user avatar
  • 145
4 votes
2 answers
6k views

Find out database type from files

How can I find out database type in order to examine data when all I have is the database. By database I mean the database folder under program root folder with bunch of files around database.db file? ...
Miki's user avatar
  • 161

1
2 3 4 5
18