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
5 answers

How to copy & move MySQL database

I'm very new to servers and databases, my experience spanning only a few installations of XAMPP for easy website testing and exploration. So I have XAMPP installed on my laptop, and I just put it on my netbook. I copied & moved my htdocs folder…
nona urbiz
  • 187
  • 1
  • 1
  • 11
4
votes
2 answers

How to upgrade to MySQL 8.0?

I have a Drupal site 8.6.10 on an Ubuntu server 18.04 with MySQL 5.7.25 I want to update MySQL to version 8.0 Here are the steps I followed : 1) I backed up my database. 2) I uninstalled MySQL from my server with the commands : $ sudo systemctl stop…
ML19
  • 91
  • 1
  • 2
  • 8
4
votes
2 answers

Restrict access to S3 bucket folders to specific website users? (not using IAM Users)

I have a website where users need to log in. They can upload and delete their own pictures BUT these pictures are supposed to be private so images are not set to public that anyone can view. I know that we can use IAM policies to restrict access to…
Dora
  • 341
  • 1
  • 5
  • 15
4
votes
1 answer

Error When Starting Cassandra for First Time

I'm trying to get a single-node cluster of Cassandra set up on my VPS for a school project. So I installed cassandra on Ubuntu 16.04 (JVM 1.8.0_161), but when I run, I encounter this error... https://pastebin.com/raw/h1vWhm2e (Posted as link to…
cclloyd
  • 593
  • 2
  • 14
  • 29
4
votes
3 answers

du -sh * show significant more used space that ls -lah

I am having trouble with running out of diskspace of one of my clients servers. The output of the commands ls -lah in /var/lib/mysql shows: drwx------ 2 mysql mysql 16K Dec 30 2015 database_xyz But when I check the filesize in the same catalogue…
Orphans
  • 1,396
  • 2
  • 18
  • 30
4
votes
1 answer

Cant delete Azure Database

Created this a database from a backup. I want to delete this database because I selected the incorrect backup. When trying to delete the database I get the following error: Failed to delete the database: [DBNAME]. ErrorCode: 400 ErrorMessage: Cannot…
Louwrens Potgieter
  • 41
  • 4
4
votes
2 answers

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

I resized an Azure VM and now the MySQL DB running in Windows inside the VM is dead. I am seeing the below fatal error on startup. I tried to run mysql_upgrade as it suggests but that just errors out saying it cannot connect. Does anyone have any…
A X
  • 469
  • 4
  • 10
  • 31
4
votes
0 answers

OlegDB in production

When evaluating available NoSQL solutions, our team identified following product for evaluation: OlegDB. Site looks pretty decent and documentation is available. While site says it's production-ready (here), I'd like to know community opinion before…
Lev Kassil
  • 41
  • 1
4
votes
4 answers

When does a database data file get written to?

I was using perfmon to monitor writes per second on a LUN containing a single SQL2005 database data file. I was under the assumption that database files are only written to during checkpoints or by the lazy writer process, is this assumption…
SuperCoolMoss
  • 1,262
  • 11
  • 20
4
votes
6 answers

Oracle DB on VMWare?

Management have OK'd a migration of our main Oracle DBs to a virtual machine platform. Operations say they'll dedicate heavy-duty hardware and only run the DB VMs on it. I've heard that running DBs on a vm is a no-no because of the extra layer…
justatest
  • 41
  • 3
4
votes
10 answers

how to complete mysql daily backup dump without timeouts?

what is best way to complete daily Mysql database backup, we are having critical mysql database connection timeouts during backup dump we use dump and gzip cron has a line: 1 1 * * * root nice -n 19 /etc/automysqlbackup.sh problem occurs during…
Tom
  • 151
  • 1
  • 1
  • 6
4
votes
2 answers

MongoDB Auth, can be authenticated in the shell but not via the command line

I have an application that connects to a MongoDB database called discussions. I've created a user Mongo shell: > use discussions switched to db discussions > db.auth("discussions","XXXXXXXXX") 1 > show users { "_id" :…
monksy
  • 357
  • 1
  • 3
  • 14
4
votes
1 answer

Latency & speed considerations between 2 servers on Amazon EC2

I'm setting up a system that consists of: 2-4 database servers 2-4 webservers (running Node.js) The webservers use the database servers heavily. Aside from connecting to the private IPs of the database servers and using the same Availability Zone,…
SilentSteel
  • 217
  • 1
  • 11
4
votes
7 answers

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but it shouldn't be outside the range of reasonable…
taw
  • 547
  • 2
  • 5
  • 13
4
votes
6 answers

How to keep multiple read/write DB servers in sync?

I'm curious to know how big sites spread the load between the different DB server in the case where users write as much as they read, ie. when the standard solution of having one master to accept write, and several slaves that only let users read…
OverTheRainbow
  • 277
  • 5
  • 13
1 2 3
…
99 100