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

learn more… | top users | synonyms

28
votes
11answers
56k 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 ...
23
votes
2answers
35k 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 ...
18
votes
4answers
51k 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, ...
12
votes
4answers
13k views
11
votes
2answers
9k 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 ...
10
votes
4answers
9k 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 ...
9
votes
2answers
6k 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?
9
votes
2answers
4k 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?
9
votes
2answers
17k 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 ...
7
votes
5answers
57k 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 ...
7
votes
2answers
17k 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 ...
7
votes
1answer
3k 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
1answer
266 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
3answers
10k 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 ...
6
votes
1answer
5k 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 ...
6
votes
4answers
363 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 ...
6
votes
1answer
506 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
4answers
19k 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?
5
votes
1answer
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
1answer
979 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 ...
5
votes
2answers
995 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
1answer
1k 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?
5
votes
2answers
4k 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 ...
5
votes
3answers
6k 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 ...
4
votes
3answers
3k 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 ** ...
4
votes
2answers
1k 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, ...
4
votes
1answer
3k 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
1answer
523 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
5answers
5k views

Software for picture database

I would like to organise my growing collection of pictures into a database, which is searchable by filename or associated words (tags). How would I best accomplish this?
4
votes
3answers
9k 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 ...
4
votes
1answer
3k views

How can I install Sybase ASE 15.5 step by step? [closed]

If anyone has successfully installed Sybase ASE 15.5 on Ubuntu 10.10 or 11.04 please share your installation process step by step. Thanks in advance
3
votes
3answers
579 views

Using /var/log to backup some folders / database contents

I need to backup regularly (daily, using cron) some folders along with MySQL database contents (in sql format). Is it okay to use /var/log (by creating a new folder to be used in it) for storing these ...
3
votes
2answers
1k views

How to make an executable file to update mysql database?

I have an Ubuntu server that is hosting my web application. But due to some security reasons it is not visible through Internet. The customer needs to update the database and update some values in ...
3
votes
1answer
378 views

PostgreSQL data diff

Note: this question is not about syncing database schema/structure Problem In my web application I have a PostgreSQL database server (PGS) and a (separate machine) business logic server (BLS) which ...
3
votes
1answer
325 views

WebSQL and other databases not working with HTML5 apps

I am trying to develop an app for Ubuntu Touch using HTML5 and I need to create a database to store, well, everything in it. But QtWebKit supports neither WebSQL nor IndexedDB. Is there any workaround ...
3
votes
2answers
17k views

How to install Oracle Database 11g Express Edition on Ubuntu 12.10?

I installed the Oracle database following the steps mentioned in this blog. Downloaded 11g express edition Created a new user oracle under the group dba. Following steps are executed using this. ...
3
votes
1answer
3k views

Can't install both libmyodbc and iODBC at the same time on Ubuntu 12.04?

I'm following this tutorial on Adding an ODBC driver to Ubuntu. I installed iODBC and then I went to install libmyodbc and noticed that it uninstalled iODBC, and now I can't follow the rest of the ...
3
votes
2answers
2k views

Running MS Access Programs

I have an old program developed in MS Access and would like to convert it to Kexi somehow. The program on Windows is launched with Access. Is there any way that Kexi can launch this program? I know ...
3
votes
1answer
6k 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 ...
3
votes
2answers
224 views

How do I log in to a database without username and password? [closed]

I want to log in to a database by running a SQL file from a UNIX script without supplying username and password (as root). Any command to do so?
3
votes
0answers
133 views

Robomongo not switching keyboard layouts without reload on Ubuntu

I have installed Robomongo 0.8.4(a mongodb administering tool) on Ubuntu 13.10 with a deb-package downloaded from it's official site. When I switch the keyboard layout it does switch system-wide but ...
3
votes
1answer
533 views

Change Sound Juicer's CD Database

I like sound juicer for ripping CDs, but the cd-database of music brainz is very scrappy compared to freedb.org. I wanted to change the source of the database but unfortunately I didn't find any ...
2
votes
2answers
1k views

parsing JSON data QML

As in topic, I'm trying to parse this json data in to my QML project link: http://www.rad.io/info/menu/valuesofcategory?category=_genre So I have list of 188 elements but don't know how to get ...
2
votes
2answers
1k views

Creating symlink for Postgres

As a developer, I often ssh right into my local database, just to test my application before pushing my code. However, I find that every time I want to access Postgres, I have to type in ...
2
votes
2answers
6k views

Cant see databases of mysql from command prompt in ubuntu 12.04

1) I have installed mysql server and mysql client through apt-get install mysql-server and apt-get install mysql-client 2) when I run sudo netstat -tap | grep mysql, I see following: tcp 0 ...
2
votes
1answer
3k 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 ...
2
votes
2answers
321 views

How to open VDB files under Ubuntu ?

I'm working with a software that uses VDB (VistaDB) to archive log files, while everyone else uses windows and can use the Vistadb software, I'm unable to do so using my Ubuntu OS, does anyone knows ...
2
votes
2answers
434 views

Why do the “iodbc” and “libmyodbc” packages conflict with each other? [closed]

When I install iodbc the libmyodbc package is removed, and I don't understand why. Does anyone have an explanation?
2
votes
2answers
82 views

Need database selection advise

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
2
votes
3answers
2k views

Should I put /var in a separate partition for a database server?

I will be using a Ubuntu server install as a server for a MySQL database. Is there any benefit to having /var in a separate partition from the root file system?