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

learn more… | top users | synonyms

26
votes
5answers
16k views

How to install MariaDB?

What is the most stable/safest way to install MariaDB?
18
votes
3answers
28k views

Moving MySQL datadir

I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/. The problem I am having is I have tried everything and after I modify the ...
12
votes
10answers
23k 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 ...
10
votes
4answers
6k 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
4k 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
4answers
5k views
8
votes
2answers
5k 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 ...
8
votes
2answers
22k 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, ...
8
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
253 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
352 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
2answers
14k views

Is it possible to open a Office 2010 Access files?

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 ...
6
votes
1answer
466 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
1answer
5k 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
3k 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
704 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
891 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
844 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
2k 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
2k 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
4answers
24k 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 ...
4
votes
1answer
322 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
1answer
2k 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 ...
4
votes
5answers
3k 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
2answers
3k 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
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
4answers
10k 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?
3
votes
3answers
419 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
468 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
1answer
144 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
1answer
9k 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
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
1answer
2k 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
199 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
1answer
279 views

partial key value retrieval data structure python [closed]

I am creating a subclass of shelve allowing for searching for partial keys (e.g., key begins with substring, or key ends with substring), and the way that seems most intuitive is to use the db.keys() ...
2
votes
1answer
898 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?
2
votes
2answers
2k 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
123 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
71 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
1k 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
197 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
193 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
161 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
2k 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
650 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 ...
2
votes
1answer
148 views

How can I get pictures from Shotwell on the notebook to the desktop?

My father has a desktop and a notebook. The desktop is way more powerful and has RAID set up, so he uses it for editing and storing his pictures. But he spends several months a year away from home. So ...
2
votes
1answer
1k 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 ...
2
votes
1answer
174 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 ...