Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
1 answer

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run iptables -nL | grep 3306 it outputs: ACCEPT tcp -- …
Jordan Davis
  • 103
  • 3
0
votes
1 answer

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is taking care of the various aspects of Database…
Santa
  • 569
  • 5
  • 15
0
votes
2 answers

User with grant permissions cannot grant permissions for new user with and new database

I am using: mysql 5.5.43-0 on ubuntu 14.04.1 I try to create a new admin-user (admin) who is allowed to do the following things: a creating new users (dbuser1) with password - (permission "create user" -> works) b set password for new created user…
Stephan
  • 1
  • 1
  • 2
0
votes
1 answer

Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions # Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName # changed from 0 to 1 on the target When I run the…
user3325655
  • 101
  • 1
0
votes
1 answer

I set up a web application server, and a separate server for postgres on the same network. How should I secure the connection?

I'm trying to determine the best, modern practice for using your own separate database server for a web-app. I have an app server, appserver1, (running php, nginx, etc, not that that matters much), and a db server; dbserver1 (running postgresql,…
Kzqai
  • 1,278
  • 4
  • 18
  • 32
0
votes
1 answer

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket dev side... My coding/db knowledge tells me this…
Louis van Tonder
  • 141
  • 2
  • 13
0
votes
2 answers

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This application will use SQL server to store much of…
RAGNO
  • 111
  • 1
  • 5
0
votes
1 answer

Setting Up Replication/master slave configuration to mariaDB

I'm starting my project using mariaDB I want to setup master slave configurations on windows 7 64Bit. I don't know how to setup this kind of configuration. I've searched on google, visited websites and blogs, i find a term buildbot, is it related…
Ashish Ratan
  • 113
  • 1
  • 1
  • 6
0
votes
2 answers

SQL server databases are stucked in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that some of my databases are in Restoring state as…
Pooya Yazdani
  • 277
  • 5
  • 12
0
votes
1 answer

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has name , address and contact. The db management…
user938363
  • 97
  • 2
  • 11
0
votes
0 answers

MySQL response times spiking at regular intervals

I recently set up a windows Hyper-V VPS with a bitnami django stack. I am monitering the website with newrelic. I noticed that my MySQL database response times spike about every 30 min. My first thought was that a cron job was running every 30 mins,…
Max Ferguson
  • 101
  • 1
0
votes
1 answer

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only difference is that I do not use postgres account for…
AmShegar
  • 259
  • 1
  • 2
  • 9
0
votes
1 answer

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version…
user2833135
  • 5
  • 1
0
votes
1 answer

Confusing MySql Error

I am trying to install an application on CentOS, and see this error in my apache log. If any can help me understand what exactly is the case, I can try to work on a solution for the error. This is what i see in the logs: [20131010…
Vijit Jain
  • 86
  • 3
  • 15
0
votes
1 answer

Setting innodb_buffer_pool_size in for Mysql

We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting innodb_buffer_pool_size, I have read 2 suggestions Set it to 80% of RAM available on a dedicated DB…
nitins
  • 2,579
  • 15
  • 44
  • 68
1 2 3
…
19 20