Database is an organized collection of data.

learn more… | top users | synonyms

3
votes
2answers
88 views

Technology / program selection for picture viewing software

I want to learn some Binux usage and/or programming skills and provide an easy to use browser based picture gallery on my local home network. My idea is to have a server machine, that is the Linux ...
1
vote
0answers
105 views

Installing rpm & dependencies

I am trying to install an rpm, namely the Oracle 10g database for CentOS 6 for testing an app. The problem is that the machine the OS is installed on does not have access to the internet and there ...
1
vote
1answer
28 views

How reliable of using “nameofmychoice=”anyname“”

For backup MySQL MyISAM database, I'm using: backupdb=siteone mysqldump -u root -pthepass --lock-tables --add-locks --disable-keys --skip-extended-insert --quick $backupdb > /var/www/html/db2.sql ...
2
votes
0answers
462 views

Automatically update MPD database upon external storage insertion

I have an Alix board in my living room running Voyage MPD edition and acting as jukebox. In order to play "guest" music, I would like that MPD automatically updates its database with the content of ...
2
votes
1answer
196 views

How to solve “/usr/bin/ld: cannot -lodbcinst” problem during FreeTDS installation

I have installed unixodbc for Microsoft SQL Server support in Linux. I want to connect PHP on Linux to a MS SQL server. I tried to install FreeTDS opensource , but it gives me following error. ...
15
votes
11answers
13k views

Grep huge number of patterns from huge file

I have a file that's growing about 200,000 lines a day, and it is all formed with blocks of three lines as such: 1358726575123 # key Joseph Brunner # name carpenter # job ...
2
votes
1answer
117 views

MSSQL database server on UNIX

I have heard rumors, but did not manage to find anything more, about some sort of MSSQL serving on UNIX machine, or MSSQL/MySQL server, that can handle MSSQL storage. I would like to know, if it is ...
0
votes
1answer
673 views

Gracenote database

I use GRIP to convert compact discs to a format that can be copied to an IPOD using AMAROK. By default, GRIP connects to freedb to get disc and track information. I've been told that the Gracenote ...
1
vote
3answers
1k views

Error dropping database in MySQL 5.1 on Ubuntu

I am using MySQL v5.1 on Ubuntu machine. I have a database named my_db which I would like to drop it, so I execute command: mysql> drop database my_db; ERROR 1010 (HY000): Error dropping ...
1
vote
4answers
1k views

Restart MySQL server

I am using MySQL v5.1 on Ubuntu machine. MySQL on my machine used to work. (Running mysql -u root gave me the MySQL command line.) This afternoon, I did the following thing: 1. check active process ...
1
vote
2answers
3k views

MySql: LOAD DATA INFILE

I am using MySQL v5.1 on Ubuntu machine. MySQL data directory is /var/lib/mysql/ I have a test.dat file located on /var/lib/mysql/tmp/test.dat I would like to load data from the test.dat file into ...
1
vote
1answer
76 views

dump out some tables of the database

I am using MySQL v5.1 on Ubuntu machine. I have a database named db_test which contain tables like cars, customers, departments, prices , and so on. I know I can use the following commands to dump ...
2
votes
2answers
6k views

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: ...
3
votes
2answers
757 views

Simple shell script needed to move database files

I am using MySQL on Ubuntu machine. I need to physically move around the database files under /var/lib/mysql/ (this is where all the databases directories are located). Say I have two databases, ...
10
votes
4answers
854 views

Standard key/value datastore for unix

I know about the key/value libraries for unix (berkeleydb, gdbm, redis... ). But before I start coding, I wonder if there is a standard tool for unix that would allow me to perform the following ...
4
votes
2answers
326 views

Databases for embedded Linux?

I need to choose a database for an application on an embedded linux platform. Any suggestions on which databases are typically used with embedded linux? Please let me know. Regards Radha.