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.
860
questions
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 ...
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.
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 ...
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 ...
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?
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?
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 ...
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 ...
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 ...
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.
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 ...
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?
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 ...
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 :)
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 ...
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)
...
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. ...
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 (...
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 ...
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), ...
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 ...
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
[...
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 ...
8
votes
1
answer
4k
views
Does SQLite come with Mac OS X?
Is SQLite pre-installed on Mac OS X or not?
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 ...
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 ...
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 ...
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 ...
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 ...
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
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?
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 ...
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 ...
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, ...
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 ...
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 ...
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.
...
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 ...
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'...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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....
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?
...