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

AWS document on number of databases allowed on an Amazon RDS instance

At the Amazon RDS FAQ there is the question "What is a database instance (DB Instance)?". The entire answer (as of mid-June 2012) is: You can think of a DB Instance as a database environment in the cloud with the compute and storage resources…
user35042
  • 2,681
  • 12
  • 34
  • 60
3
votes
1 answer

Limiting database security

A number of texts signify that the most important aspects offered by a DBMS are availability, integrity and secrecy. As part of a homework assignment I have been tasked with mentioning attacks which would affect each aspect. This is what I have come…
Torbal
  • 43
  • 3
3
votes
2 answers

What limits are imposed for mysql user creation?

MySQL 5.1.x What is the cost of an account on disk when it is created in MySql? Also, what is the max number of accounts you can create?
Mike B
  • 11,871
  • 42
  • 107
  • 168
3
votes
1 answer

Restoring MySQL dump - ERROR 2006 (HY000)

I am just trying to restore a mysql dump. Below are the command and error message. Can anybody give me some clues how to approach this? 10:54:16 Restoring C:\Users\matcheek\Documents\dumps\Dump20120405-1.sql Running: mysql.exe…
matcheek
  • 231
  • 5
  • 14
3
votes
1 answer

How to convert Mysql database to Postgresql in Linux?

I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job correctly. So wondering if there is any free and…
alfish
  • 3,127
  • 15
  • 47
  • 71
3
votes
3 answers

Generating an insert script based on selected rows in Sql Server?

In Sql Server 2005, is there any way, using the official GUI or a third party tool, to select rows in a table and then generate a insert script for the selected rows?
James McMahon
  • 773
  • 2
  • 8
  • 16
3
votes
1 answer

CSV engine on MySQL server

I don't think that this is a programming question so I am going to ask it here - Reading the book high performance mysql, I read about the CSV engine. The paragraph says: The CSV engine can treat comma-separated values (CSV) files as table, but…
Jeff
  • 1,089
  • 5
  • 26
  • 46
3
votes
3 answers

Problem with WSUS database

On server which I'm using for WSUS 3, one day i found this: The WSUS administration console was unable to connect to the WSUS Server Database. Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting…
Boris Vezmar
  • 163
  • 2
  • 2
  • 8
3
votes
2 answers

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of conversation, let's say 2 million+ rows to which…
sinping
  • 2,070
  • 14
  • 13
3
votes
3 answers

Using SSD drives in a raid in an operation involving little to no deletes

From what I've been able to understand when reading about the case with Solid State drives and raids, the problem is that TRIM cannot be used for them in a raid configuration, thus, resulting in the disks becoming slower over time when files are…
Aron Lander
  • 33
  • 4
3
votes
6 answers

Way to inexpensively temporarily increase storage on production servers?

We have a set of 6 servers in production for storing some massive databases. Right now they have 280Gb of disk space striped and mirrored across 15K SCSI Drives, our existing database fills them to 213Gb. The new data structure is approximately 1.1x…
Zee
  • 133
  • 4
3
votes
2 answers

Transfer database data from xampp on Windows to Ubuntu

Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
albertopriore
  • 131
  • 1
  • 3
3
votes
2 answers

Is it considered a bad idea to have a publicly facing MySQL or SQLServer Database?

If I wanted to create a publicly facing database for purposes of connecting it to a client MS Word or Open Office Writer installation, would this be considered a dangerous security practice? What if I have set access permissions to various tables…
leeand00
  • 4,869
  • 15
  • 69
  • 110
3
votes
1 answer

sql server limitation of data size

This question is related to my SQL Data type size A varchar(max) seems to be able to store up to 2GB. What I can not understand though is that in this link sql row overflow MS says (my emphasis): A table can contain a maximum of 8,060 bytes per…
user76678
  • 349
  • 3
  • 5
  • 16
3
votes
3 answers

Export massive MySQL database, from a shared level hosting account

I need to export a huge database, with thousands of tables and millions of rows. I'm on shared hosting so I can't use command line exports, and I really have no easy way to get to this data other than through phpMyAdmin or php. cPanel's default…
Cyclone
  • 206
  • 3
  • 8
1 2 3
…
99 100