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

learn more… | top users | synonyms

25
votes
2answers
50k 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 ...
0
votes
0answers
12 views

Databases and Oracle SQL Developer

First off, I'm practically a total noob at using Ubuntu. I came across a "teach yourself SQL" book, so I decided to try to learn SQL. I managed to install the Oracle SQL Developer (thanks to this ...
1
vote
0answers
44 views

Sqlite, DB clients & BLOB's: Practical DB Use

I'm looking for a client that helps me to make practical use of a DB. I'm looking at SQLite since it's simple, embedded (stored in a file rather than accessed via a server) and has a shell interface ...
4
votes
1answer
154 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
37 views

libreoffice base - cli insertion of records?

I need to script the insertion of records into a database. For this project (my first such), I'm using libreoffice Base with, for no particular reason, an HSQLDB back-end. Is there a cli interface ...
1
vote
1answer
22 views

Managing Information: voicemail-mp3's/transcripts/notes + txt msgs. Do I need a database?

I'm looking to manage a large collection of recorded voicemail messages, which come along with machine generated transcripts and to which I have added my notes. I also have text messages and letters ...
0
votes
0answers
108 views

“error establishing a database connection” - on my WordPress website - with indexes problems?

I keep getting this: error establishing a database connection and this is never ending. This is /var/log/apache2/error.log: [Thu Mar 31 11:38:45.865505 2016] [autoindex:error] [pid 22782] ...
0
votes
0answers
24 views

gtk and MySQL connection

can I use this code http://www.mono-project.com/docs/database-access/providers/mysql/ in gtk application ? else what I do for connect gtk application with Data Base in monodevelop ?
0
votes
2answers
49 views

Problem with C# MySQL Connection

Hello everybody i have a MySQL connection problem in C#. This is my problem in the picture. thanks for help me.
0
votes
1answer
68 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 ...
3
votes
4answers
109 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 ...
0
votes
0answers
17 views

Insatallation of oracle 11g database in ubuntu 15.10 [duplicate]

I am using ubuntu 15.10.I have downloaded oracle 11gR2_database.I dont know how to install it.Kindly help me
0
votes
0answers
60 views

Has anyone try MS SQL 2016 on Ubuntu yet?

With Microsoft now supporting MS SQL on Ubuntu I want to see if anyone has try it and what was their experience. Microsoft Supporting SQL on Ubuntu ...
-1
votes
1answer
22 views

Installing mysql server with postgresql

I'm using backbox 4.4 which it was built-in with postgresql. Yesterday i think about "can i installing mysql database along side postgresql database ? ", i want to learn database connection but i so ...
36
votes
12answers
77k 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 ...
0
votes
0answers
20 views

Ubuntu for SQL database and windows clients?

I am currently running my small business with an Ubuntu 12.04 file server which houses an MDB (access) database for our ERP software (E2 ShopTech) along with various CAD/CAM files. We need to upgrade ...
1
vote
1answer
6k views

How to create a Table Search in LibreOffice Calc?

A lot of our members staff have trouble finding which counties various cities and towns are in. Our work involves writing and sending letters, of which the county is a mandatory field. I want to ...
0
votes
2answers
51 views

Server kernel upgrade

What are the implications of a database server that hasn't been restarted for a while. The last restart was in July, and am I being over cautious that something will break when I restart it? We do not ...
0
votes
0answers
109 views

Installing Oracle Database On my Ubuntu 15.10

I am learning DBMS through online courses which teaches me Query language using Oracle. I need to download Oracle Database on my pc. Please Help.
0
votes
0answers
21 views

UML class diagrams and databases

I have a database set up that includes foreign keys in different tables. I am trying to work the cardinality out but am getting confused. Can someone explain how I can work out the cardinality and ...
2
votes
2answers
334 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 ...
0
votes
0answers
117 views

Wordpress wp-config.php installation error in Ubuntu

The following problem didn't happen to me in Win10 and from a quick search there isn't much data on this problem with Mac. Maybe someone encountered it and could detail solution: I am trying to ...
0
votes
1answer
25 views

Need help troubleshooting virtual host

Good day, I maintain system for a non-profit and I'm having difficulty with one of our virtual hosts. I'm stumped as to where the issue is. The server is running Ubuntu 12.04 LTS, it's reasonably ...
2
votes
2answers
70 views

Can i put everything back after accidentally doing “apt-get remove mysql-server”?

I have accidentally typed in webserver terminal following command: sudo apt-get remove apache2 php* mysql* -y Can i rescue my database tables, without a backup? I know that, for instance, apache ...
0
votes
1answer
365 views

How to install dbvisuallize on Ubuntu 14.04.3 LTS (GNU/Linux 3.13.0-57-generic x86_64) server

I want to get data from h2 database which my server is using. After some google i found that Dbvisullizer may help to read data from a h2 database .mv file but could not find a way to install it on ...
0
votes
4answers
1k views

How do you use the ROWNUM fuction (or similar) in LibreOffice Base query?

I am trying to help someone who wants to put data into alphabetical order with a row number. I thought I could do a query like this select "name", ROWNUM() as "Row" from "data" order by "name" But ...
0
votes
1answer
40 views

commands to upload database file to database

There is a database file in this path : /var/www/db.sql in server. Our database size is about 800mb. we have to upload this sql file to the database : "age" username : root, password : pass, ...
1
vote
1answer
128 views

How to install PostGIS on Ubuntu 14.04?

I tried: gsamaras@gsamaras:~$ sudo apt-get install postgresql-9.1-postgis Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
11
votes
4answers
12k 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 ...
1
vote
1answer
369 views

Error while installing DBeaver On Ubuntu 14.04

I am trying to install Dbeaver 3.5.6 on Ubuntu 14.04, but it shows some Java run-time missing error even though I've Java7 installed on my system. Here's how I tried to install ...
0
votes
0answers
31 views

Ubuntu phone app

I am trying to develop an app for Ubuntu phone and I have some questions. Am I able to access a database using HTML5 app? Is it posible to read/ write to file using HTML5 app?
0
votes
2answers
32 views

phpMyAdmin on Linux takes too long to load

Why does it take too long to load the database that I had just created? Other actions like executing a sql statement works. Btw, I'm running a Linux OS in my flash drive. Does this happen because I'm ...
0
votes
1answer
33 views

Why do all my music tracks appear twice in Clementine?

Using Clementine 1.2.3, Kubuntu 12.04. Clementine shows each track in my collection twice, even though only one file exists. Any idea why? Further info by asking informally. Collection Folders are ...
0
votes
0answers
58 views

Physical Backup of Maria DB as a snapshot using LVM

I have a SQL database which I want to backup as a snapshot. I want to use LVM to do so, but I am not able to do it. Also my database is not stored in a LVM partition but its located in my /dev/sda2 ...
0
votes
1answer
93 views

squidGuard: error while loading shared libraries

I am using ubuntu server 14.04.3 and i am trying to use a blacklist in Squid with SquidGuard. When i execute the command to create the data base blacklist (being root): squidGuard -C all I ...
0
votes
0answers
33 views

How to connect a MSSQL database from Ubuntu 14.04? [duplicate]

I am trying to connect a MSSQL database from a Ubuntu 14.04 machine. I am using FreeTDS to connect, by following this tutorial ...
0
votes
1answer
364 views

how to fix Error: Port conflict: another instance is already running

I fired two command sudo apt-get update sudo apt-get upgrade It will give me error after upgrade(after press "Y") Setting up postgresql-9.1 (9.1.19-0ubuntu0.12.04) ... * Starting ...
0
votes
0answers
203 views

PostgreSQL move data directory to home folder

i have a problem with the moving of my data directory of postgresql. I found many different ways, but none worked. The most sensible way for me was: stop postgresql copy data from old folder to new ...
7
votes
2answers
4k 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?
1
vote
2answers
315 views

Database create in mysql database

I am using Ubuntu 12.10 and recently I install XAMPP 1.8.1. My problem I can not create new database using both sql command and phpmyadmin. In phpmyadmin database creation input box is not shown and ...
10
votes
1answer
30k 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 ...
1
vote
1answer
74 views

Connecting to an oracle ebs system

I am interning at a company that uses oracle's ebs that I'm supposed to connect to. Everyone else here uses windows and use toad to connect to the company's database; everyone but me that is... I use ...
22
votes
4answers
69k 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
146 views

MySQL Job cannot start - Can't find error, need database

I'm in the progress of migrating my linux server as my old one is quite thoroughly screwed. Not only are all the permissions screwed up, but my mysql server won't even start. At first the error (what ...
0
votes
1answer
144 views

running sqlite from php5-sqlite install

I have installed php5 and sqlite3 by using: sudo apt-get install -y php5 php5-sqlite unzip But when I run sqlite (or sqlite3) in the terminal, it says that I need to install it using apt-get. I ...
1
vote
1answer
2k 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 ...
0
votes
0answers
44 views

How do I get the database files using LFTP from the remote server to the local server

I want to connect to the database of a dedicated server remotely from a Linux server and the store the SQL file onto the local Linux server. What command would I need to use, using LFTP?
0
votes
0answers
29 views

Access-like file DB

What are some recommendations for Access-like file DBs that have a nice query GUI. I am familiar with SQLite but that doesn't keep together all the data and queries in the same file like Access. I ...
3
votes
1answer
9k 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 ...
0
votes
2answers
85 views

Setting up postgresql on another SDD

I am new to the server part of ubuntu. I am setting up a server with ubuntu 14.04 LTS OS installed. I have two 1TB sata disks and two 2TB sata disks(configured with RAID 1 for both). I am using the ...