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

learn more… | top users | synonyms

0
votes
0answers
7 views

Database into a class diagram

I have a database that is a little bit messy. Does anyone know of a decent approach that will allow me to convert a database from sql server into a class diagram. I can't generate a diagram so I ...
2
votes
2answers
309 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
21 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
17 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 ...
25
votes
2answers
45k 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 ...
2
votes
2answers
61 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
111 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
30 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, ...
35
votes
12answers
70k 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 ...
1
vote
1answer
42 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
11k 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
89 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
29 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
25 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
25 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
40 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
65 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
205 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
151 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
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?
1
vote
2answers
297 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
25k 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
58 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 ...
21
votes
4answers
62k 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, ...
0
votes
0answers
37 views

Lost PostgreSQL connections after database package reinstall

I upgraded my home server from 12.04 to 14.04 which came with PostgreSQL 9.3. Unexperienced, I forgot to verify which clusters I was running. I uninstalled 8.4 and 9.1 (Aptitude classified them as ...
2
votes
2answers
101 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
62 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
735 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
35 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
26 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
8k 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
51 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 ...
0
votes
1answer
156 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
0
votes
1answer
1k views

Oracle Database Express 11.2 job for oracle-xe.service failed

Environment: Ubuntu 14.04 Oracle Database Express 11g Release 2 I'm receiving an error by starting service oracle-xe systemctl status oracle-xe.service ● oracle-xe.service - LSB: Oracle 11g ...
0
votes
0answers
12 views
6
votes
3answers
7k 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 ...
0
votes
4answers
10k views

How do I install Oracle Database 12c?

I downloaded Oracle Database 12c but I'm having trouble installing it. Can anyone help me? Imported from the comments below: Then I unzipped it and installed it, but nothing appears the ...
0
votes
1answer
96 views

How could we connect ODBC to ubuntu 14.04

Is there any way to connect to a MS ODBC system to the linux os. Or there any other local database available for linux ? Or should we create database in the terminal itself ?
0
votes
1answer
525 views

Where to find MSSQL ODBC driver .so file?

Ubuntu 14.04.1 LTS From my Ubuntu machine I want to access an MS SQL 2005 server via ODBC. This MSSQL server is on our internal network. I've installed these packages: unixodbc, unixodbc-dev, ...
0
votes
1answer
34 views

Problems with making a lamp database in ubuntu

I'm trying to create a lamp-server database. When I go to localhost in my browser the default apache "It's working" page is displayed. But when I'm trying to see my database with localhost/posts I get ...
1
vote
0answers
26 views

Is there a fix for seeing an access 2013 backend on an ubuntu server?

Personally, what I know about Ubuntu can fill a thimble and leave room for your thumb, but the guy that set up my employer's server has a MS thing, even though every other machine in the place uses ...
0
votes
1answer
635 views

Postgresql server not started in ubuntu 14.04

My problem is after postgresql installed try to configure postgresql database it's show error message like below: dineshlap@ss-laptop:~$ sudo -u postgres psql postgres psql: could not connect to ...
0
votes
0answers
116 views

Two factor authentication with password and USB Device for PostgreSQL server

I'm going to setup 2 factor authentication for my database server. I'm using PostgreSQL 9.4 DBMS on Ubuntu 14.10. I need to force two authentication methods for my database server. The authentication ...
12
votes
4answers
17k views
0
votes
0answers
37 views

On running an application through wine why exception handling error is occuring

I ran a program by this code wine '/home/user/Hardware/hyperterminal/hypertrm.exe' the program starts but stops in between getting message as Unhandled exception: page fault on read access to ...
1
vote
4answers
118 views

Good text editor or other software for storing structured information?

i've long been looking for a solution for storing structured information (such as for example contacts) that is: future safe (saves to a .txt file or other future safe format or can export to a .txt ...
4
votes
3answers
12k 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 ...
2
votes
1answer
2k views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...