Database is an organized collection of data.

learn more… | top users | synonyms

2
votes
1answer
37 views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
1
vote
2answers
29 views

What network protocols do database servers use?

I have a postgres 9.1 server running on the default port 5432 on an ubuntu 12.04 cloud server. I want to open up the port so I can make remote queries -- but I have to open the port on IP tables, ...
0
votes
0answers
19 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
1
vote
2answers
36 views

Is it possible for a OpenVZ container to interact with a MySQL database on the host?

Say every container and the host itself has its own dedicated, external IP. Is it possible to do this without any problems? And is this really a good plan? Instead of hosting a database per ...
0
votes
1answer
45 views

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a ...
0
votes
0answers
10 views

ODBC driver for Informix

Does anyone known how I can get a ODBC driver for Informix to my Debian (arm) machine? I want to use it with unixODBC. Also is there a ODBC driver for SQL Server available for the same architecture? ...
0
votes
0answers
11 views

Lock on IBM DB2 database on Linux server

My db2 database is running on Linux server, Some time database table got lock by some of db user due to uncommiting the session. My question is that how we can find out through which ...
1
vote
0answers
34 views

Can data be “clustered” on disk? If so, how?

Can linux be set to "automatically" cluster data in the way a clustered index does on SQL Server/MySQL or Postgres but a little better? websocket++ allows for fully persistent and shared memory ...
2
votes
1answer
97 views

How to extract single value from single line tuples?

I have a dump file of a database in the following form ('value1','value2',value3','value4'),('value1','value2',value3','value4'),... I want first to have each tuple in a single line and next i ...
1
vote
1answer
106 views

why csv is consuming more file size in my unix script?

I'm using this unix script which it is fetching records in the form of csv. I have a SQL query used for this purpose. It contains below information SET PAGESIZE 5000 SET COLSEP "," SET LINESIZE 2000 ...
0
votes
2answers
79 views

How to remove the last character from every line in a text file [duplicate]

I have a tonne of data to analyse, but all the data was Thai. Google translate added a "." to every line after translation. How can I remove this dot from every line? Example from output: DB00301. ...
0
votes
1answer
465 views

How to open OLE2 Compound Document Storage database?

I have file called Thumbs.db that I seem unable to open with anything. SQLite Database Browser can't do it, nor can LibreOffice Base. Opening up the file properties tells me it's an 'OLE2 Compound ...
0
votes
3answers
167 views

Brand new to Linux - running a web server/database server, need to connect to my servers- how?

I am brand new to Linux. I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. I am very familiar with Windows and ...
-3
votes
3answers
772 views

What mysql command can show me the tables in a database and how many rows there are? [closed]

is there a mysql command that will show me the tables and how many rows they have in them?
0
votes
0answers
54 views

How to run Oracle10g forms in browser in Linux

How i can run Oracle Database 10g forms in browser in Linux? I want a complete tutorial for this.
0
votes
1answer
224 views

No monetdbd installed on linux64 (opensuse 12.2)

I have installed monetdb from MonetDB-11.15.7.zip on a linux64 box following the instruction in the HowToStart.rst file. The Download is available here. According to the Monetdb's quick start page I ...
2
votes
3answers
200 views

Any programs suitable for making a database over disk-content?

I have quite a lot of external hard-drives, and often have a hard time finding what I'm looking for - not to mention not storing the same file several times on different drives or finding free space ...
0
votes
1answer
1k views

How to remove Oracle Wallet using orapki?

Hi i'm on Centos using oracle 11g And i've created a wallet using : $ orapki wallet create -wallet /u01/app/oracle/admin/DB11G/wallet -pwd WalletPasswd123 -auto_login Now i want to remove it to ...
-1
votes
2answers
155 views

Copyed mysql files from previous system now error while connect, what to do?

Fist of all I have the files but the old system is gone. I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...
0
votes
1answer
27 views

Only value required using mysql command

I created following command to get value of Innodb_data_writes using command show status in mysql database. mysql -u root -p**** -e "show status" | grep Innodb_data_writes Current Output: ...
1
vote
0answers
164 views

how to create a script to backup MySQL databases on separate files?

I need to create a script so to automate the backup process for my database server. Today there are 19 databases on the server and to prevent some schema is created and not contemplated by the script, ...
1
vote
1answer
91 views

syslog-ng ignores MSSQL database name

syslog-ng ignores the database defined in syslog-ng.conf and instead uses the default database of the user when logging to MSSQL destination. destination d_mssql { sql(type(mssql) ...
4
votes
2answers
271 views

Data extraction of entire DB on SCO Openserver 6

Firstly apologies if this question seems like a wall of text, I can't think of a way to format it. I have a machine with valuable data on (circa 1995), the machine is running UNIX (SCO OpenServer 6) ...
4
votes
1answer
710 views

Does quiesce exist for Linux?

Quiescing a file system allows you to make a backup of the database while it is still running and other programs and their data as well. The application generally needs to be notified of the quiesce ...
1
vote
2answers
400 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
4
votes
1answer
188 views

unixODBC documentation / manpage?

Just wondering if there is any official documentation for unixODBC, e.g. how the configuration files have to look like and what parameters they expect? (I am using only a shell, no GUI) Even ...
3
votes
2answers
85 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
87 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
27 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
355 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
156 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. ...
12
votes
11answers
8k 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
99 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
516 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
846 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
998 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
2k 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
63 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
3k 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
482 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
574 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 ...
3
votes
2answers
281 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.