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

learn more… | top users | synonyms

2
votes
2answers
378 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
597 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
295 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 ...
1
vote
1answer
165 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 ...
7
votes
5answers
65k 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
2answers
20k 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
555 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
350 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 ...
5
votes
2answers
2k 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
121 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
272 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
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 ...
7
votes
1answer
6k 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
1answer
3k 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?
0
votes
1answer
119 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
4k 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
149 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
2k 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
2answers
307 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 ...
8
votes
2answers
22k 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
213 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 ...
35
votes
12answers
69k 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
825 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 ...
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 ...
4
votes
1answer
607 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 ...
6
votes
4answers
22k 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
6k 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
1k 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
3k 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
7k 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
234 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 ...
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, ...
2
votes
2answers
462 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
2k 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
473 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
4k 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 ...
0
votes
1answer
85 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
652 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
228 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?
2
votes
2answers
1k 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
2k 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
84 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
2k 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
2answers
4k 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
17k 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: ...
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 ...
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
1k 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 ...