Ask Ubuntu
Ask Ubuntu

Questions tagged [database]

A database is an organized collection of data for one or more purposes, usually in digital form.

The term "database" may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to physical database as data content in computer data storage or to many other database sub-definitions.

The term database is correctly applied to the data and their supporting data structures, and not to the database management system (referred to by the acronym DBMS). The database data collection with DBMS is called a database system.

343 questions
73
votes
13 answers

What is a good MongoDB GUI client?

I've been using Rockmongo on Windows - it's a php based web tool. But on Ubuntu (12.04) it's behaving funny - queries timing out often - and I'm looking for better clients. Does anyone know anything good for MongoDB on Ubuntu?
Eyal
  • 5,075
43
votes
2 answers

Is it possible to open an Access 2010 database file without using Wine or VirtualBox?

I have a .accdb file created with Microsoft Office 2010 and I want to know if it is possible to open it with some native Ubuntu application like LibreOffice or OpenOffice, I know LibreOffice has LibreOffice Base but I can't figure out how to open or…
Jeggy
  • 3,122
  • 16
  • 57
  • 80
39
votes
5 answers

Where is mongo database folder on the filesystem

I'm using Ubuntu 16.04. I have set up a database MongoDB. When I start it (with mongod command) it says that database is located at /data/db (dbpath=/data/db). The database works fine. But in files explorer I cannot find that folder. I've looked in…
croraf
  • 614
37
votes
4 answers

ER diagram software

ER diagram software for Ubuntu?
Vassilis
  • 2,957
28
votes
2 answers

Where is a postgresql 9.1 database stored in ubuntu 12.04?

I installed and created a Postgresql database on ubuntu. I then created the database using the following command: sudo su postgres createdb mydatabase However, I can't figure out where the database was initialized. I would like to be able to edit…
celenius
  • 387
  • 1
  • 3
  • 7
28
votes
4 answers

Connecting MS SQL using freetds and unixodbc: isql - no default driver specified

I am trying to connect to the MS SQL database using freetds and unixodbc. I have read various guides how to do it, but no one works fine for me. When I try to connect to the database using isql tool, I get the following error: $ isql -v TS username…
Dejan
  • 281
26
votes
2 answers

How can I import a database using command line?

I am using Ubuntu 14.04. I want to import my database which is located on the server /var/www/backup.zip. Also I've SSH access using Putty. Noted that MySQL and phpMyadmin are installed on the server. When I run this command mysql -u root -p spy <…
stack
  • 601
24
votes
5 answers

Install postgresql. Why is initdb unavailable?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D /usr/local/pgsql/data Ubuntu tells me that it 'initdb'…
Starkers
  • 3,149
24
votes
4 answers

How to install PostgreSQL 13 in Ubuntu?

How to install PostgreSQL-13 in Ubuntu 20.04?
Thirumal
  • 1,009
  • 5
  • 14
  • 25
22
votes
2 answers

Remove MariaDB (MySQL) Databases

How do I completely remove MariaDB so I can reset the root password?
SteamPunk_Devil
  • 323
  • 1
  • 2
  • 4
21
votes
6 answers

How to connect and create a database in MySQL?

I want to install MySQL and create a database on it using the following code: sudo apt-get install mysql-server mysqladmin -h localhost -u {username} -p create lrs I get the following message after executing the second line: Enter password: …
user543489
  • 435
20
votes
7 answers

Install mysql 5.6 on Ubuntu 18.04 LTS

I'm unable to install mySql 5.6 on my newly installed Ubuntu 18.04. I have tried solution from lots of links ( link1 link2 ... ) but no success at all. I have 5.7 installed, but due to client's requirement, I need to do it anyhow. There are few…
Purushotam Sangroula
  • 323
19
votes
2 answers

Different locations for MySQL databases?

Can I configure MySQL to store a specific database in a separate place on disk? I still want any new databases to go to the default location, but there's a specific database that I'd like to have stored in my Dropbox folder so that it can stay…
Colin
  • 718
16
votes
3 answers

can not install libpq-dev in ubuntu 14.04

I can not install libpq-dev for postgresql, i tried sudo apt-get install libpq-dev and output Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an…
indra bin ridwan
  • 647
16
votes
5 answers

Postgresql server not started in ubuntu 14.04

My problem is after postgresql installed try to configure postgresql database it's show error message like below: dineshlap@ss-laptop:~$ sudo -u postgres psql postgres psql: could not connect to server: No such file or directory Is the server…
Dinesh
  • 281
1
2 3
…
22 23