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.
Questions tagged [database]
860 questions
94
votes
8 answers
"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 user must also own the server process.
The database…
AdamT
- 1,103
41
votes
4 answers
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
- 1,643
29
votes
2 answers
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 database mydatabase;
exit;
chrisl-921fb74d
- 4,030
26
votes
4 answers
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 interface to export it from one, and then I import it into…
vonhogen
- 2,459
23
votes
2 answers
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
- 651
21
votes
5 answers
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
- 777
21
votes
5 answers
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 computer.
This feature was cut despite actually…
Console
- 2,680
20
votes
4 answers
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 to that.
I would like to configure the Dolibarr…
Sekhemty
- 9,916
19
votes
5 answers
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 and errors when executing pragma integrity_check…
Bobby
- 9,032
18
votes
1 answer
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 successfully shrank my regular Linux partition, and I…
nday
- 349
15
votes
4 answers
Is there a Internet PC Parts database? Like IMDB except it's about PC parts: motherboards, CPUs, Power supplies etc etc
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
- 1,253
13
votes
2 answers
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 entirely. I see the file system as a beautiful database…
Sridhar Sarnobat
- 1,552
13
votes
4 answers
What FLOSS DB design tool for Linux would you recommend?
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 Gnome, but KDE tools are interesting too.
codeholic
- 455
12
votes
2 answers
What is a DDL script in the context of databases?
What is a DDL script in the context of databases?
lalala
11
votes
3 answers
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 have no idea what the .PMP files are.
Directory…
Raymond
- 2,850