Database is an organized collection of data.

learn more… | top users | synonyms

15
votes
11answers
15k 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 ...
10
votes
4answers
960 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 ...
10
votes
1answer
155 views

Does anyone actually use and benefit from transparent huge pages?

I've been struggling with transparent huge pages performance issues of late, and noticed many database systems recommend turning it off. I am talking Oracle, Postgresql, MySQL, Cassandra, NuoDB, ...
5
votes
1answer
2k 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 ...
4
votes
2answers
336 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.
4
votes
1answer
337 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 ...
4
votes
1answer
27 views

Making graphs from database with Time/Date field

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part. To explain ...
4
votes
2answers
565 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) ...
3
votes
1answer
11k 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 ...
3
votes
2answers
963 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, ...
3
votes
2answers
7k 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 ...
3
votes
1answer
37 views

centralized Address/phone book able to sync with thunderbird

In my office we are looking for a service able to store and manage all the phone numbers and adresses we have and capable of synchronize the database with clients (e.g. thunderbird) on personal ...
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 ...
2
votes
3answers
3k views

Query Firefox password database

Braiam said that Firefox stores the password data for login websites in ~/.mozilla/firefox/key3.db and ~/.mozilla/firefox/signons.sqlite files. These files can be read with some sqlite editor. I ...
2
votes
2answers
7k 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: ...
2
votes
2answers
274 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, ...
2
votes
1answer
216 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 ...
2
votes
1answer
71 views

Option --skip-slave-start Not Working with Systemctl

I just started with centos 7. I'm trying to get replication working and am attempting to start mysql without starting the slave (so that I can set the pointers as to where it's supposed to resume ...
2
votes
1answer
53 views

Ways to store data for command line API

I am developing an API in Unix environment for virtual machines. I have to store some information in a table about virtual machines. Currently I am using python dictionary of virtual machine objects ...
2
votes
2answers
63 views

What is best and secure way to save application settings?

Let's say I have an application which has plugins, daemons, etc. Now It has to save its settings and plugins settings as well as too. Most of all applications use users home folder for it but it is ...
2
votes
1answer
264 views

mysql restoration process takes longer time

I have a Ubuntu 8.04 machine which has around 300 GB size mysql databases. I have dumped all the databases using the mysqldump command as below. mysqldump -u root -p --all-databases > file.sql ...
2
votes
3answers
267 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 ...
2
votes
1answer
24 views

Can the vacation e-mail auto-responder cope with Berkeley DB version skew?

We have a typical account domain with NFS home directories, accessible by the mail server as well as various user workstations. Do the versions of the vacation package installed on the mail server ...
2
votes
1answer
81 views

XML command line tool postgres

I have an XML files to read and load into database daily at night (cron) So i planed to do this in a batch. Is there any command line tool to : 1. Create a postgres schema using an XSD file? 2. ...
2
votes
2answers
540 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 ...
2
votes
1answer
206 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. ...
2
votes
1answer
120 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 ...
2
votes
0answers
117 views

VoIP dialer for SIP

I have some Java, so am biased in that direction, but not overly so. None of the Java suggestions: http://stackoverflow.com/questions/16471795/sip-client-for-java ...
2
votes
0answers
499 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 ...
1
vote
4answers
2k 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
164 views

Databases backup with cron

I'm trying to set up a cron job in order to backup my databases daily. Here's what I wrote in my crontab file : 25 18 * * * root mysqldump -u root -p myPassWord --all-databases | gzip > ...
1
vote
1answer
161 views

I'm looking for a free database package for Ubuntu

I need to operate a database for personal use. Now I'm using Ubuntu 14.04 LTS, as opposed to Windows operating system, I'm wondering if there's a dBase, Lotus123 or Access equivalent for Linux? ...
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 ...
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
1answer
44 views

How to get the structure of a GDBM database

Modem Manager GUI creates a database named sms.gdbm to store all the SMS details. Currently Modem Manager GUI is not providing a feature to simply delete all received/sent messages. So I'm trying ...
1
vote
2answers
4k 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
90 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 ...
1
vote
2answers
322 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 ...
1
vote
1answer
179 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 ...
1
vote
0answers
61 views

Convert / import flat file with multiple records, one variable per line

I am searching for an efficient way using (UNIX) command line tools to read a flat file into a(ny) database, perhaps after first converting to an intermediate structured format, for example XML or ...
1
vote
1answer
78 views

delete redis keys that have been inactive for 30 days

I've installed a web app called scrumblr which uses redis as a database. What I am attempting to do is delete all keys that have been inactive for 30 days, or have not been accessed in 30 days. I ...
1
vote
1answer
36 views

Changing redis filesystem writing behaviour

The filesystem usage of redis is peaking every 20 minutes at the moment on my server. Sometimes from 63.1% to over 90.9%! This causes my monitoring to send me alerts if its over a longer time-frame. ...
1
vote
0answers
970 views

How to set up Active Directory authentication on CentOS 6.5?

I have: 1. A CentOS machine to which I have SSH and STFP access. 2. The machine is on network where there is a MS SQL Server database and Windows shared drives. 3. All authentication seems to be with ...
1
vote
0answers
294 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
212 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) ...
1
vote
0answers
119 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
607 views

How do I run a service with numactl

I need to do something like this to run MongoDB $numactl --interleave=all /usr/bin/mongod --config /etc/mongod.conf & What should I change to be able to run the mongo daemon with the options ...
0
votes
3answers
346 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 ...
0
votes
2answers
864 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
3answers
9k 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?