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
6
votes
1 answer

Howto install Oracle OCI8 instantclient on Ubuntu 18.04

I want to share some information about my OCI8 installation to access Oracle databases. If you got errors like "PHP Startup: Unable to load dynamic library 'oci8.so'" or "checking Oracle Instant Client library version compatibility... configure:…
FixFaier
  • 301
  • 1
  • 2
  • 8
6
votes
1 answer

AWS RDS Nightly Staging Database

I am trying to determine if it is possible to configure the RDS service in AWS to do the following, but have not had much luck with my Google searches. When it does its instance backup, have it automatically delete an RDS instance and spin up a new…
Jeremy Harris
  • 245
  • 4
  • 12
6
votes
2 answers

OpenSSH and PAM authentication using a public key

I'm looking for a way to authenticate users using a public key which is stored in a db (MongoDB). Similar questions usually resulted with a suggestion to installed a patched version of OpenSSH (https://github.com/wuputahllc/openssh-for-git) which…
Gilad Novik
  • 307
  • 2
  • 3
  • 10
6
votes
1 answer

DB Full Vacuum, Cluster, Analyze - in which order?

I have a huge (~150 GBytes) postgresql database whose performance has dropped during the last weeks. In order to improve performance, I intend to perform FULL VACUUM, CLUSTER and ANALYZE. In which order should I perform these operations? I don't…
Adam Matan
  • 13,194
  • 19
  • 55
  • 75
6
votes
2 answers

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] i want to export database something like above…
jayakrishnan
  • 61
  • 1
  • 1
  • 2
6
votes
3 answers

Protocol choice for Machine-to-Machine communication - level:n00b

I am building a monitoring system for an irrigation pump and the connected pipeline. So far I have completed the sensor network. Everything connects to a micro-controller board (actually 4 Teensy 3.0 boards) and the board is programmed to output a…
dlyk1988
  • 1,674
  • 4
  • 24
  • 36
6
votes
3 answers

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a table: 1286 - Unknown storage engine…
Tiffany Walker
  • 6,681
  • 14
  • 56
  • 82
6
votes
3 answers

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error in your SQL syntax; check the manual that corresponds…
Spacedust
  • 568
  • 5
  • 13
  • 28
6
votes
5 answers

Will a database server perform better running on 2 CPUs with 16 cores or 4 CPUs with 8 cores?

What I have: an online financial application (ASP.NET, C#) at peak we have 5K+ simultaneous users backend is running on Oracle 11g (active server + stand-by using Active Data Guard). At peak - 4K-5K database sessions Oracle is installed on Linux…
Alex
  • 61
  • 1
  • 2
6
votes
4 answers

When to relink Oracle?

Various sources on the internet suggest relinking of Oracle binaries is necessary after each OS upgrade and / or patch. I can understand relinking would be necessary when upgrading glibc. Some package likely do not to require relinking, some do,…
wzzrd
  • 10,409
  • 2
  • 35
  • 47
6
votes
5 answers

Virtualizing Microsoft SQL Database server

My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if since we are using Microsoft HyperV, Microsoft Server…
poconnor
  • 635
  • 2
  • 5
  • 13
6
votes
7 answers

Things every Oracle DBA should know

This could include: Books worth reading; Tools worth having; etc.
cletus
  • 9,999
  • 9
  • 37
  • 40
6
votes
4 answers

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
Chad Johnson
  • 489
  • 2
  • 7
  • 14
6
votes
8 answers

Should We Abolish User Access to rm?

Lately, I've been hearing system administrators and managers ask about solutions to keep people from accidentally removing their data. These are very smart and dedicated people asking for a solution so that data isn't lost either by accident or on…
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
6
votes
2 answers

Recover a MySQL database with only bin-log file

Here is the CATASTROPHE: We are working in our company with a web application for test management: TestLink. One team was working on it for more than 1 month till now. Yesterday, another team wanted to start using testLink too, so i was asked to…
b-lieve
1 2 3
…
99 100