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

learn more… | top users | synonyms

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
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?
0
votes
1answer
841 views

aptitude install apach derby ij

I see a similar question here: Question How do I connect to toursdb of Derby database using ij in Ubuntu How do I connect to toursdb of Derby database using ij in Ubuntu I have Ubuntu , I have ...
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
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 ...
1
vote
2answers
163 views

Do I need to install a database before programming in c++?

I would like to do database programming in C++ connecting to some database on Ubuntu 12.04 LTS. Do I need to install a database before programming in C++ or does any database gets installed with ...
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, ...
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?
0
votes
3answers
3k views

How to sync a folder to Ubuntu One cloud via command line?

I'm writing a shell script to back up my databases and send that backups to my Ubuntu One cloud. Basically, it dumps the databases into a sql file named after current date, putting it in a folder ...
1
vote
1answer
1k 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 ...
0
votes
1answer
420 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
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 ...
1
vote
1answer
330 views

Failed to install Octave's database package on ubuntu [closed]

I'm trying to install octave's database package on my ubuntu machine. I had installed octave3.2-header before I installed the package, but some errors still exist. octave> pkg install ...
0
votes
1answer
79 views

How obtain error message when exporting data from LibreOffice Base to Calc and freezing occurs?

[Ubuntu 12.04] When exporting large (100 MB) data from a table in LibreOffice 3.5.2.2 Base embedded HSQLDB to a Calc spreadsheet using the procedure outlined in LibreOffice Help, LibreOffice Base and ...
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 ...
0
votes
1answer
202 views

I want to learn SQL and PL/SQ, what database should I use?

I am using Ubuntu 11.10 and I want to learn SQL and PL/SQL. Can someone please advice me the most suitable database that I should install?
1
vote
2answers
930 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 ...
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 ...
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 ...
0
votes
2answers
1k views

Why Ubuntu doesn't ask me for password before login?

When I had 11.04, there was an option "ask for password", something like this. I checked it out, and instead of password field I got "login" button. Now, when I got 11.10, I doesn't see that option. ...
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 ...
2
votes
1answer
2k 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 ...
1
vote
2answers
12k views

Get a SQLite3 db in LibreOffice (via ODBC). Using Ubuntu 11.04 (64bit)

I'm stuck with this. I had SQLite working with OpenOffice in the past. But since then i reinstalled my machine and so... Now I can't get it to work. i pretty much followed this guide: ...
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
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
855 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 ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
2
votes
0answers
1k views

Are there any good Mongodb GUI clients? [duplicate]

Possible Duplicate: What is a good MongoDB GUI client? Are there any good Mongodb GUI clients for Ubuntu? (Preferably that will run on Ubuntu 11.04.) I found one (JmongoBrowser) but I'm not ...
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 ** ...
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?
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
1
vote
1answer
2k views

How to I do install DB2 ODBC?

I have been trying, with no success, to install a IBM DB2 ODBC driver so that my PHP server can connect to a database. I've tried installing the db2_connect and get all sorts of problems, I tried ...
5
votes
2answers
953 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 ...
2
votes
0answers
221 views

My .odb database spikes the CPU in OpenOffice and LibreOffice [closed]

my database is in .odb format, and it does not work in 9.1, 10.04, 10.10, openoffice OR 11.04 beta libreoffice but works in xp, w7 and fedora 14 The biggest issue i'm facing is that it takes minutes ...
1
vote
0answers
235 views

GdaBrowser deb? [closed]

Where can I get a GdaBrowser package? It should be somewhere in the repos with libgda packages but it isn't :/
1
vote
3answers
1k views

When will postgres 9 be supported?

When will Ubuntu support postgres 9?
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?
1
vote
1answer
2k views

How to install mysql DB while offline?

I have downloaded mysql-5.5.9-linux2.6-i686.tar.gz file. I don't know how to install it into my Ubuntu os. I don't have an internet connection, I'm posting here from browsing center. I can download ...
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?
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?
0
votes
3answers
263 views

I want to install and get to building a personal MySQL DB

So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file? I've only had brief experience with MSAccess and OOo Base a long time ...
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 ...
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?
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 ...
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 ...
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 ...
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?
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 ...
11
votes
4answers
8k views