Questions tagged [database]
A database is an organized collection of data for one or more purposes, usually in digital form.
340
questions
73
votes
13
answers
188k
views
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 ...
42
votes
2
answers
106k
views
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 ...
37
votes
5
answers
152k
views
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 ...
36
votes
4
answers
67k
views
ER diagram software
ER diagram software for Ubuntu?
28
votes
4
answers
120k
views
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, ...
28
votes
2
answers
65k
views
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 ...
25
votes
2
answers
129k
views
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.
...
23
votes
4
answers
39k
views
How to install PostgreSQL 13 in Ubuntu?
How to install PostgreSQL-13 in Ubuntu 20.04?
22
votes
2
answers
110k
views
Remove MariaDB (MySQL) Databases
How do I completely remove MariaDB so I can reset the root password?
21
votes
5
answers
74k
views
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/...
20
votes
7
answers
57k
views
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 ...
20
votes
6
answers
176k
views
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 ...
19
votes
2
answers
22k
views
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 ...
16
votes
3
answers
42k
views
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. ...
16
votes
5
answers
41k
views
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 ...
13
votes
2
answers
8k
views
Is there a Linux equivalent to LinqPad?
I've recently been finding myself writing more SQL, on Windows with MSSQL and LinqPad and while I want to experiment on Ubuntu to get more of a handle on databases and I have no love lost for MSSQL, I'...
13
votes
4
answers
80k
views
How can I open .db files?
I've imported a .db file from my android device and I wish to open it using Libreoffice Base or something similarly basic with a simple GUI.
How do I achieve this?
13
votes
4
answers
20k
views
SQL modeling and design tools?
I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu.
It would be good if that tool generate SQL scripts, and a plus with those ...
13
votes
3
answers
7k
views
Can I share MySql database files with Windows on dual boot?
I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
13
votes
1
answer
68k
views
Installing Oracle database 12c on Ubuntu 14.04
Is there anyone out there that got Oracle 12c working on Ubuntu 14.04? I tried following this tutorial (which is written for installing Oracle 12c on Ubuntu 12.04):
But in linking faze I encountered ...
12
votes
4
answers
19k
views
Easy database tool (the more gui the better)
So a friend of mine wants to set up a database for managing his investigation data. But he does not know any programming. So i offered a little help but also want to make sure that he could manage his ...
12
votes
1
answer
21k
views
Is it safe to delete preinstalled MySQL databases like INFORMATION_SCHEMA?
I just installed the LAMP server and PHPMyAdmin. Once I logged in I noticed databases already created and within them tons of tables and rows.
My question of course is whether I can just delete them ...
11
votes
4
answers
42k
views
64-bit DB2 10.5 missing 32-bit libpam and 64-bit libaio on Ubuntu 12.04
This happened to me. If it's happening to you, maybe this can save you
a bit of time.
I was installing 64-bit DB2 10.5 server (not sure exactly what product package
-- someone gave it to me) on a ...
10
votes
2
answers
9k
views
How can I install SQLite to be used with OpenOffice?
My GPS uses a SQLite database. I would like to access this data using OpenOffice to look at the relationship between data entries. Is there a way to install SQLite with OpenOffice?
7
votes
4
answers
43k
views
adminer- None of the supported PHP extensions (MySQLi, MySQL, PDO_MySQL) are available
whenever i login to the adminer, it always show:
No Extension
None of the supported PHP extensions (MySQLi, MySQL, PDO_MySQL) are available.
I just installed this a while ago using ...
7
votes
1
answer
22k
views
How to convert Android's contacts2.db to .vcf?
I have extracted my contacts2.db from a nandroid backup. I'd like to convert that to one or many .vcf files so that I can use my contacts in other applications.
I already found an answer that dealt ...
7
votes
2
answers
13k
views
How to view and/or edit a .mdb Jet MS Access database file?
I have a .mdb database file which originated from a MS Access Jet database.
Is the some way to view this database, and even better, a way to edit and export it?
7
votes
1
answer
25k
views
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server
I am not able to run sqlcmd command
My OS (18.04) is
$ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23
18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
$ sqlcmd -S localhost -U ...
7
votes
1
answer
6k
views
SQLite binary file does not work on my Ubuntu,
I'm new to sqlite , I just got the binary of sqlite by using wget http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip, then extract sqlite3 from the zip file, it does not work, it's driving me ...
7
votes
1
answer
5k
views
LibreOffice Base can't find SDBC driver
After installing LibreOffice Base from Ubuntu Software I get the message
No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'
when I attempt any action in LO Base. Base starts but as soon as I ...
7
votes
1
answer
312
views
How do I get a list of all applications that can be executed from Ubuntu Dash Home? Is there is some xml file that stores this information?
I'm building an application and it's very important to me to know how to get this information. In LXDE, there is /usr/share/lubuntu/openbox/menu.xml that lists all the programs that can be executed ...
6
votes
2
answers
24k
views
sqlcmd not available after installing mssql-tools
I'm trying to access sql server database so i need sqlcmd but after following microsoft docs here and here. Running sqlcmd returns:
sqlcmd: command not found
and I do have mssql-tools installed:
...
6
votes
4
answers
6k
views
What standalone databases with GUI are available for Ubuntu?
I have googled for this information and I am simply lost. I just need a simple, standalone and a single table database with GUI. I tried Libraoffice base, but it keeps giving me an error "S1000 java....
6
votes
1
answer
1k
views
How do I export banshee library settings to another machine?
I am trying to downgrade my distro. The thing is, I have spent some few hours organising my music library and I do not want to lose my database. I have checked 'write meta data to files'. And so, my ...
6
votes
4
answers
416
views
Postgresql 8.4 for newbies
Are there any how-to's or tutorials about postgresql 8.4 fro doing following things:
Logging in to postgresql
creating database
getting into database environment
adding or altering the tables
Sorry ...
6
votes
1
answer
2k
views
Database data modeler application
Is there some application for creating database data model diagrams that is able to generate SQL expressions which will create the database schema?
6
votes
1
answer
603
views
Problem in switching from PL/SQL Developer to SQL Developer
I want to become Ubuntu user, but SQL Developer is not comfortable enough for me. Main problem for me is that when I query data with select statemant and the result is displayed it is not possible to ...
5
votes
3
answers
7k
views
How can I restore a corrupted Shotwell db?
While I was importing photos from a SD card in Shotwell, my laptop has crashed (shutdown because of over-heating). Now, I can no longer launch Shotwell:
$ shotwell
**
ERROR:x86_64-linux-gnu/db/...
5
votes
1
answer
30k
views
Remotely access mysql db on vm from windows as host [closed]
I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
5
votes
1
answer
4k
views
LibreOffice Base missing on Ubuntu 11.10
I am an occasional user of Ubuntu & have upgraded to 11.10 (loved the prev 8.04 ) but Libre Office Base (I use databases a lot) is not available in the new Ubuntu from the Launcher.
Does it get ...
5
votes
2
answers
1k
views
Error when starting BitCoin
I just installed Bitcoin and everything seemed to be going well. After a few days the client stopped loading at boot and instead gave this error:
DB_RUNRECOVERY: Fatal error, run
database ...
5
votes
3
answers
9k
views
Is there an Postgres ERD tool (or pgAdmin III plugin)?
Don't hold it against me, but I have a fond memory of MS SQL Server Management Studio. I could very easily generate an ERD diagram from an existing database. Tables, relationships, the works. You ...
5
votes
2
answers
5k
views
MySQL change datadir, problem with mysqld.sock
I tried to change the database directory, datadir, I did the following steps.
My machine: Laptop Ubuntu 11.10 64-bit
Install:
sudo apt-get install mysql-server mysql-client
All Ok, I can create ...
4
votes
4
answers
27k
views
mysqldump a zipped dump
Till now I've created and zipped mysql dumps this way:
mysqldump -u root -p --all-databases > /var/www/html/db-$(date +\%F-\%T).sql
zip /var/www/html/db-$(date +\%F-\%T).zip /var/www/html/db-*.sql
...
4
votes
1
answer
9k
views
Libre Office Base in Ubuntu 16.04
Libre Office Base does not come installed with Ubuntu 16.04 LTS. It is not in the Ubuntu Software repository. The questions on this are all over a year or two old.
I need a database for Ubuntu. ...
4
votes
1
answer
15k
views
How do I copy MySQL databases to another Ubuntu machine?
I installed a LAMP server on my pc and created databases. Now I want to copy it to my friend's computer. How can I do this?
4
votes
1
answer
2k
views
Cannot run Sqlectron
I have installed sqlectron v1.28.0 from the .deb file available here
but I cannot run it. The icon appears in my system. When I click on it nothing happens. I'm running 14.04 btw. Please help.
4
votes
2
answers
1k
views
Any good SQL shell programs?
I want to practice SQL commands on Ubuntu. I would just like to play with different commands and keywords. Where can I find something that helps?
I don't want to install any server. I need a small ...
4
votes
1
answer
8k
views
allow remote mysql access (through webmin or shell)
Spec:
Ubuntu 14.04
webmin/virtualmin 1.791
I am using following code to test remote mysql database connection:
<?php
$db_host = "123.456.789";
$db_name = "database";
$db_user = "user";
$db_pass =...
4
votes
1
answer
6k
views
Missing ODBCConfig for SQLite and LibreOffice Base
I have used OpenOffice Base as a front end for SQlite databases, in 10.04 linked via ODBC.
I am updating to 12.04, so I loaded LibreOffice Base, looks just like OObase. I have 12.04 on one drive and ...