Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
5
votes
2 answers

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic configuration that I should change in…
user1070579
  • 141
  • 1
  • 3
  • 7
5
votes
5 answers

Would the database compatibility level affect performance?

We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The compatibility level is currently at 90 (2005). None…
duckworth
  • 700
  • 3
  • 10
  • 12
5
votes
1 answer

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ColdFusion Background: I have a development…
Denoteone
  • 151
  • 3
5
votes
2 answers

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) With this command I can access remote PostgreSQL…
Giovanni Formentini
  • 53
  • 1
  • 4
5
votes
3 answers

Are there useful static analysis tools for databases?

Is there a popular tool for examining the configuration and schema of a database for dubious fields, relationships and configuration, similar to how static analysis tools like lint will flag dubious lines of code? (I'm not sure that this is…
jldugger
  • 14,342
  • 20
  • 77
  • 129
5
votes
5 answers

What is "The" book for database design?

In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc. Is their a book regarding modern database design that simply must be read by anyone that would hope to eventually design…
Eric Wilson
  • 678
  • 8
  • 15
5
votes
5 answers

How do I find the size of a MySQL database?

I'm told that show table status is useful in finding the size of a database, but I get an unreadable mess. Is there any way to alter this command to get less information, or is there another way to find the size of a database or table?
Eric Wilson
  • 678
  • 8
  • 15
5
votes
1 answer

Is there a Informix command to repair database?

We have a Sun Solaris system running Avaya CMS software. The software uses an Informix database. We have a single drive in the server. The drive began to go bad, corrupting files. We sourced a new drive and were able to duplicate the data from the…
Joshua Pack
  • 153
  • 7
5
votes
4 answers

Can you explain exporting and then importing PostgreSQL using phpPgAdmin? (And what's with permissions?)

Bounty Edit: I've left the original question but would like a good answer on the whole permissions debacle that Postgres seems to bath in. 'Importing & exporting clients db's: A field guide' I just got this job today where we need to use…
Gareth
  • 8,573
  • 13
  • 44
  • 44
5
votes
4 answers

Display all the UDFs installed on a MySQL server?

How do I display all the UDFs (User Definied Functions) on a MySQL server? (version 5.0.x) UPDATE I don't want to display the code of all the UDFs, I just want to list the name of each UDF that is installed. Sorta like SHOW DATABASES, but for UDFs.
Amandasaurus
  • 31,471
  • 65
  • 192
  • 253
5
votes
2 answers

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the server: could not receive data from server: Software…
Nyxynyx
  • 1,459
  • 11
  • 39
  • 49
5
votes
12 answers

SQL Server database on an external hard disk drive

Due to some security problems, My boss has asked me to store all sensitive data in external/removable storages like USB stick or external HDD and this specially includes the MDF/NDF/LDF files of SQL Server 2008 we're running. I've been reading for…
Achilles
  • 412
  • 2
  • 8
  • 17
5
votes
1 answer

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple pools of connections, vs one central pool of…
orokusaki
  • 2,763
  • 4
  • 32
  • 43
5
votes
1 answer

Removed Old Domain Trust. Now Progress (9.1D) can't open DB File

My company has an old server, running Progress 9.1D on a Windows 2000 VM, which was used by our company OS (Vantage 6 by Epicor.) Vantage was our primary OS for a very long time. About 2 years ago, we migrated to a larger, corporate OS and we…
RLH
  • 199
  • 10
5
votes
4 answers

MySQL Clustering

I run a mysql server that hosts around 50Gb of data (primarily for around 250 websites), and am wondering what my options are for setting up a redundant MySQL cluster? The primary purpose would be that I could take one server down for maintenance…
Brent
  • 22,857
  • 19
  • 70
  • 102
1 2 3
…
99 100