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

learn more… | top users | synonyms

23
votes
11answers
36k 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 ...
13
votes
3answers
34k 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
2answers
22k 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 ...
11
votes
4answers
8k views
10
votes
2answers
7k 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
8k 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
5k 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
1answer
3k 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?
7
votes
1answer
258 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
1answer
2k 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?
6
votes
4answers
356 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
483 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
5answers
40k 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 ...
5
votes
2answers
10k 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 ...
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
3k 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 ...
5
votes
1answer
852 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
952 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
4answers
3k 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 ...
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 ...
4
votes
4answers
14k 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?
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
1answer
422 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
4k 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
1answer
2k 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
1answer
2k 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?
3
votes
2answers
445 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
2answers
770 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, ...
3
votes
3answers
515 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
1answer
237 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
13k 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
1k 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
2answers
210 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
104 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
242 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
124 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
3answers
4k 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 ...
2
votes
2answers
4k 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
2answers
182 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
1answer
2k 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
376 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
77 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?
2
votes
1answer
199 views

OSS object oriented alternatives to oracle database

I want to know if oracle style object oriented database code can be written in mysql, postgresql or any OSS database softwares. I don't want to install the massive oracle db on my ubuntu to learn ...
2
votes
2answers
390 views

phpliteadmin cant find sqlite3

I installed sqlite3 using sudo apt-get install sqlite3. I also installed phpliteadmin in the var/www folder. When I go on phpliteadmin, it says it cant find sqlite3 and sqlite3database. How do I fix ...
2
votes
1answer
209 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
2
votes
1answer
4k views

How to connect Ubuntu to a MS SQL server 2005?

I am using Ubuntu 13.04 and I installed Wine 1.6. I am running a dotnet application through Wine, but I am getting the following error message: An error occurred while establishing connection to ...
2
votes
2answers
939 views

how do I install Firebird 2.1 on Ubuntu 13.04

When updating form ubuntu 12 to 13 my firebird 2.1 was uninstalled. Now, when I try to install it, it seems that the package is obsolete. root@ricardo-pc:/# apt-get install firebird2.1-classic ...