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

learn more… | top users | synonyms

0
votes
3answers
330 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...
0
votes
0answers
112 views

Connecting to mysql 5.5

I'm trying to manage MySQL 5.5 but in Terminal I get the following Warning after entering the password: Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: ...
0
votes
2answers
301 views

Shutdown does not power off computer with db derby service

I set service db derby by this instructions Fresh Install Ubuntu 12.10 - 17. apache db derby #!/bin/bash # # Startup script for Derby ### BEGIN INIT INFO # Provides: derby # Required-Start: ...
0
votes
1answer
75 views

How can I tie an alert to a LIbra database?

I want to know how to tie an "alert" or notification to a column in a LibreOffice database table. I'm a new Linux user and am working with a LibreOffice database. In the near future I intend to put ...
0
votes
0answers
199 views

LibreOffice Base 3.5: no Report Builder

I have tried installing Base several times and have read the Wikipedia information about the report builder -- and still cannot get it. I want to use a MySQL database and LibreOffice Base to generate ...
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 ...
0
votes
1answer
188 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under ...
1
vote
2answers
152 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 ...
0
votes
0answers
480 views

Installing Greenplum in Ubuntu Server 12.04

I tried to install Greenplum database using the follwoing guides: http://blog.2ndquadrant.com/greenplum_41_on_ubuntu_server/ on my Ubuntu 12.04 box. It is failing on the last step where I need to ...
1
vote
1answer
97 views

Create database

I want to create database. I know that I should use the following code: mysqladmin -h localhost -u {username} -p create lrs I don't know if something should be replaced with username located between ...
0
votes
0answers
609 views

File could not be read - phpmyadmin

I have a problem with phpmyadmin v.3.3.7: I created a database and I build up a website for a company. When I try to import a db I get the error: "file could not be read". I told it was a db ...
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 ...
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. ...
1
vote
1answer
206 views

Mongodb shell is giving an error while connecting?

When you try to connect to mongodb it is giving a following error: root@ip-10-87-37-28:~# mongo MongoDB shell version: 2.0.4 connecting to: test Fri Mar 8 07:40:11 Error: couldn't connect to server ...
2
votes
1answer
161 views

What is skew value in Mongo DB Database replication?

I have just started the three MongoDB replica servers. I do not understand what is this screw value what it should be on which server? Which values should I monitor I have taken 2 screenshots ...
3
votes
2answers
464 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, ...
1
vote
0answers
98 views

How do I edit the commands that start a service in Ubuntu 12?

So I am trying out GBrowse, as we will use this later on. But then, I'm getting this ------------------------------------------------------------------------------------------------ 256000 features ...
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 ...
0
votes
2answers
353 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 ...
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 ...
2
votes
1answer
887 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?
1
vote
0answers
235 views

install dbmail or other e-mail database

I'm starting to use ruby to parse and store e-mails, but don't want to reinvent the wheel. I have a subset of e-mails, all in one account stored locally, which I would like to keep in a database. ...
0
votes
1answer
102 views

Keepass 2 doesn't show any files present on a pendrive

I keep my keepass 2.x databases and their respective keyfiles in a pendrive, to be able to open them in any PC. Whenever I want to open a database, first I have to execute Keepass 2, then navigate ...
1
vote
3answers
2k views

Connect PHP to Microsoft Access ODBC

One of our employees created a Microsoft Access Database and have built a Joomla! module around it. It is currently running on a WAMP server, with an ODBC connection to the adb file. How can i create ...
1
vote
1answer
70 views

Isn't there an installer package for Oracle Database?

I wish I could install Oracle Database as easy as possible using Ubuntu Software Center or apt-get install. I suggest that at least, someone of the community, could create a package that installs it ...
0
votes
1answer
1k views

MySql #2002 problem [duplicate]

Possible Duplicate: My MySQL installation is broken. How to completely reconfigure it? When i try to login in apache i get a #2002 error. When i try to login in MySQL via terminal it ask my ...
2
votes
1answer
160 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 ...
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 ...
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 ...
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 ...
0
votes
2answers
466 views

LAN data transfer [duplicate]

Possible Duplicate: Sharing files in LAN through Samba or SSH I would to know how can I transfer data using LAN from an Ubuntu machine to another! I am using a wireless router, obviously, I ...
6
votes
2answers
13k 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 ...
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 ...
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?
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?
0
votes
1answer
607 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
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 ...
1
vote
2answers
136 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 ...
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() ...
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, ...
1
vote
2answers
326 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
803 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
402 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 ...
17
votes
3answers
27k 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 ...
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 ...
1
vote
1answer
274 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
73 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
418 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 ...