0
votes
1answer
29 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
0
votes
1answer
14 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
105 views

Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]

Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
2
votes
1answer
554 views

Cleared vs. Unformatted partition in GParted

I am running a database-like application that writes and reads data directly to and from a raw block device. I would like to create a new partition for this purpose, and I am using GParted. I've ...
0
votes
1answer
74 views

Multiple requests shut down MySQL

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
0
votes
0answers
115 views

Ubuntu FTP Server - Hetzner

I have an FTP Backup Server in Hetzner with details Backup Server: u*****.your-backup.de I am trying to connect to it through my ubuntu server using command $ ftp u*****.your-backup.de and i see ...
1
vote
1answer
104 views

Which is better for multi-use auth, MySQL, PostgreSQL, or LDAP? [closed]

I want to set up an Oracle Linux 6 server that gives users secure IMAP email (with dovecot), Jabber IM, FTP (with vsftpd), and calDav. However, I want each user logon to be able to authenticate all ...
2
votes
1answer
165 views

What's a good database-backed X.509 certificate authority on Linux

I've been using OpenSSL as an X.509 certificate authority. Because multiple machines will need to create certificates, I've exported the certificate authority folder on a distributed filesystem. When ...
1
vote
1answer
58 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
0
votes
1answer
182 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
1
vote
1answer
366 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
0
votes
1answer
406 views

What command in MySQL is like the command “host” in oracle sqlplus

Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc. Here are examples SQL*Plus_FAQ, docs.oracle.com Is there some ...
1
vote
1answer
182 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
124 views

Issue changing mysql password on Debian

I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
1
vote
2answers
3k views

Linux Mint (Ubuntu) Microsoft Access Replacement?

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...
0
votes
1answer
78 views

Can an application running as user foo log onto a database as (database) user foobar?

I am writing a simple application that will run as user foo (i.e. Ubuntu user foo). However, the application will connect to my database as (database user foobar). IIRC, database users have nothing ...
0
votes
1answer
61 views

back-up database in Linux partition from windows partition!

Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since ...
1
vote
2answers
98 views

how to search file at server

i'm newbie at linux... 1. i want to make backup database(use mysqldump) 2. copy from server(use linux-server) to client PC (use linux- ubuntu 9.0).. 3. before that i want to search that DB file using ...
3
votes
1answer
59 views

Need data on disk drive management by OS: getting base I/O unit size, “sync” option, Direct Memory Access

I want to ensure I have done all I can to configure a system's disks for serious database use. The three areas I know of (any others?) to be concerned about are: I/O size: The database engine and ...
4
votes
5answers
6k views

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
1
vote
1answer
638 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
0
votes
1answer
60 views

migrating berkeley database from XP to linux box

I am in the process of migrating from XP to Linux (Unbuntu 9.10). I need to migrate a larg(ish) BDB database (approx 5Gb) from my XP machine to the Linux machine). The berkeley database was created ...
1
vote
1answer
129 views

What tool to build a clients database and agenda?

Background: A friend of mine wants to upgrade his computer. He is using an old proprietary tool to manage his clients files and agenda. This tool won't work on a modern OS, he could ...
8
votes
5answers
6k views

Linux GUI Database Manager

Does anyone Know any KDE application for working with databases in a unified way? It must support several DBs (sqlite, MySQL, Oracle). GTK apps are also welcome :)