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
0
votes
2 answers

High availability for databases (DRBD + GFS)?

Does it work to have like an MySQL (or any other relational database) on the GFS (with DRBD) and have multiple nodes reading and writing to it? Is that the "best" way of providing a HA database/application setup if so? Is RHEL (cluster suite) a good…
EvanAlm
0
votes
4 answers

What is the best way to backup the schema of a sql server 2005 express database?

I want to backup the schema of a sql server 2005 database from the command line. Whats the best way to do this? Update I ended up buying SQL Compare 8.1 from Red Gate Software. It works just as well as Change Director and is 1500 dollars cheaper.
Justin Tanner
  • 151
  • 1
  • 3
  • 7
0
votes
2 answers

How do I set the password that contains quotation mark to a connection string in an ASP.NET application?

How do I set the password that contains quotation mark to a connection string in an ASP.NET application? Answer: Password: This"Is"Password In connection string: This""Is""Password
None
0
votes
2 answers

Database cluster... without Master/Slave?

I'm wondering if it is possible to have a set of SQLdb servers to which data is written and have them replicate, avoiding conflicting information. I imagine that a Master/Slave structure would be mandatory, I would like to know if a system where…
RadiantHex
  • 547
  • 2
  • 9
  • 18
0
votes
1 answer

Determine Configured Location of MySQL's data directory OR all loaded *.cfn Locations

I'm not a sys-admin, but sometimes I play one at work. I've inherited a virtual server that had MySQL installed from source. I'm gathering as much information about the install as I can (original people who installed it are, of course, not a…
Alana Storm
  • 458
  • 5
  • 16
0
votes
2 answers

Ideas for scaling out database architecture

We're looking to scale out our existing database architecture and need some advice on which way to go. We currently have 2 web servers behind a load balancer that both read & write to a single master database which replicates to a slave. Ideally,…
andrew
0
votes
2 answers

How should I copy the "mysql" database to my new server using PHPMyAdmin

My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new one (b). I assume I need to overwrite the 'mysql'…
undefined
  • 654
  • 2
  • 8
  • 18
0
votes
1 answer

Memory Usage for Databases on Linux

So with free output what we care about with application memory usage is generally the amount of free memory in the -/+ buffers/cache line. What about with database applications such as Oracle, is it important to have a good amount of cached and…
Kyle Brandt
  • 83,619
  • 74
  • 305
  • 448
0
votes
2 answers

PostgreSQL lots of large Arrays and Writes

I am running a python program that spawns 8 threads and as each thread launch its own postmaster process via psycopg2. This is to maximize the use of my CPU-cores (8). Each thread call a series of SQL Functions. Most of these functions go through…
user84590
  • 147
  • 3
0
votes
1 answer

MySQL keeps restarting due to running out of memory

how can we prevent this from happening? it generally causes down time of about 30 minutes, which is extremely disruptive for service...
meow
  • 113
  • 7
0
votes
1 answer

Moving Drupal site to new server

I'm tasked with moving a Drupal 6 site from a shared hosting account to a new virtual server. Once I transfer the files to the new server, can I have the new server access the same database on the old shared server? So both sites (shared account…
Rob Decker
0
votes
3 answers

How to script sql server 2005 database with data?

I use sql server 2005 as my database for my web application.... I generated scripts of the database by, Database->Right Click->Tasks->Generate Scripts I can script all my Tables,Stored Procedures,User Defined functions,Views,Users...... I have no…
ACP
  • 149
  • 1
  • 5
  • 12
0
votes
3 answers

Do 'recover deleted items' take up space in the Mailbox Store and if so how can I get rid of them?

I'm trying to recover space in my Mailbox Store and we have the 'Recover Deleted Items' option active in Outlook. Are these items still in the database and if so how can I permanently delete them?
Marko Carter
  • 4,092
  • 1
  • 30
  • 38
0
votes
2 answers

Import database: SQL Server 2005 Express to SQL Server 2008 Enterprise

I have two servers 1 x SQL Server 2005 Express and 1 x SQL Server 2008 Enterprise How can I move/import my database from SQL Server 2005 Express to SQL Server 2008 Enterprise? (BACKUP SQL SERVER 2005 and RESTORE to SQL Server 2008, would that work?)
001
  • 491
  • 1
  • 11
  • 21
0
votes
2 answers

Corruption in Exchange

Using Microsoft Exchange, if the database corrupted, will I be able to receive email?
saja
1 2 3
…
99 100