Questions tagged [database-administration]
296 questions
2
votes
1 answer
Using mongodump with an auth enabled mongodb server
I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool.
mongodump provides two parameters to set the credentials:
-u [ --username ] arg username
-p [ --password ] arg password
Unfortunately they don't…
bb-generation
- 163
- 1
- 5
2
votes
1 answer
Optimising PHPMyAdmin configuration for massive databases and many tables
Developers require database access to a significant number of databases, each with 220+ tables, and currently they are provided this using phpMyAdmin 2.11.9.5. Initial load is very slow, puts some load on the database cluster beneath, and runs lots…
Andy
- 5,230
- 1
- 24
- 34
2
votes
1 answer
Copy a database from Denali CPT3 to SQL 2008 R2
Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a couple of databases on it.
Now we have an…
primero
- 157
- 1
- 7
2
votes
4 answers
How to load large SQL file into mysql
I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump
I was trying to load it on another server like so:
mysql -u xxxx -pxxxx data_mirror < dbdump.sql
I was not satisfied with this process because
It did not…
Goro
- 664
- 3
- 9
- 18
2
votes
1 answer
Formatting data from management database
I've got some data that goes like this:
Config_Name Question Answer
Cisco WAN Sensitivity: High
Cisco WAN Authorized Users: Brent, Charles
Cisco WAN Last Audited: n/a
Cisco WAN Next Audit: 3/30/2012
Cisco…
bVector
- 140
- 2
- 10
2
votes
1 answer
DB2 Integrity Checks and Exception Tables
I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on.
A few notes on this migration:
We are using db2move to export and load…
imthefirestartr
- 53
- 2
- 7
2
votes
1 answer
Consolidating SQL Server
We have a number of SQL Server 2008 R2 standard servers, each for a single application that we'd like to consolidate into one physical server. Running perfmon on these servers they're not using a high amount of CPU, IO, or network traffic so…
Benjamin Bryan
- 197
- 1
- 9
2
votes
3 answers
How to share a SQL DataBase over the internet?
According to the above figure how can I share a database over the internet that is hosted on a server and allow a remote PC to connect using its static IP and using a connection string.
Keizer
- 21
- 1
- 2
2
votes
1 answer
Adding Domain Admin as a SQL Server admin
I inherited a domain with a SQL Server where nobody knows password to it's admin login. I have full rights on the domain and that server, is there a way to get access to the SQL Server instance?
Andrey
- 354
- 5
- 17
2
votes
1 answer
What is the best way to determine what's locking up SQL Server using a query?
Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so far:
SELECT
SPID = s.spid
, …
Aplato
- 23
- 1
- 4
2
votes
1 answer
How to setup two mysql servers in Synchronization mode
Infrastructure
I have two database servers, running on two different boxes. One works as a primary database for my web application and other works as secondary database. Secondary data base is updated by replication facility in mysql server. Primary…
vijay.shad
- 129
- 2
- 6
2
votes
1 answer
How to move MySQL partitions from one machine to another?
I have a MySQL table:
CREATE TABLE tweets (
tweet_id INT NOT NULL AUTO_INCREMENT,
author_id INT NOT NULL,
text CHAR(140) NOT NULL,
PRIMARY KEY (tweet_id)
)
ENGINE=InnoDB
PARTITION BY HASH(tweet_id)
PARTITIONS 12;
How do I move selected partitions…
Continuation
- 3,080
- 5
- 30
- 38
2
votes
1 answer
How to rename database without first stopping SQL instance to flush connections
Is there a way to force a database into single user mode so a script can be run to rename databases? I find I have to Restart the instance of SQL (to force off any connections from a web app, etc.) and then I can run this script:
USE…
DaniellaMercuryFan
- 249
- 1
- 8
- 17
2
votes
1 answer
Alternatives to Zmanda for MySQL backups?
I don't have a problem with Zmanda but i wonder if there is any better or popular solutions out there other than doing it by hand.
My requirements are:
Online backups
The tool should decide to use mysqldump or mysqlhotcopy depending on the…
pablasso
- 225
- 3
- 8
2
votes
5 answers
revision control for database schema and configuration
What are the best practices for managing revisions to the database schema and configuration ?
what tools do you use ?
Michael
Michael Ellick Ang
- 2,039
- 3
- 14
- 15