The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
3answers
103 views

What's the best tool for managing database evolution/versioning?

We need a tool for dealing with database evolution/versioning. And we need the best! :) Can you expert guys help us to find a great tool that has these features? Conceptual Model: The tool must ...
1
vote
1answer
74 views

What's the best way to split client sites in a PostgreSQL installation?

I need to host several client sites using one PostgreSQL installation. What's the best way to split them -- by schema or by instance? The factors would be what makes admin easier (especially ...
1
vote
1answer
28 views

MySQL installation on Mac isn't working

I just installed mysql on my Mac per these instructions. However, at the command line which mysql and which mysqld replies nothing. How do I get from the above link to this tutorial link?
1
vote
1answer
401 views

Taking SQL Server database ownership after the original owner has left the company

I have inherited administration responsibility for a SQL 2008 R2 server at work. The previous database administrator has left the company, and can no longer be contacted. At this point I have: Full ...
1
vote
1answer
293 views

SQL 2005 change IP address and subnet

I have to move few sql servers to a new subnet ( change IP address and mask only ), need to know what should be best practice or correct way of doing this? the sql servers are not in cluster. Thank ...
1
vote
2answers
969 views

Throttle or limit resources used by a user in a database?

I would like to know how databases (like MySQL) are able to manage per user resources (like Oracle Database Resource Manager does) to be able to have users that may only get resources only when the ...
1
vote
1answer
214 views

MSSQL Replace Database in Live Web App

I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one. My dev SQL instance is not the live one. I usually ...
1
vote
1answer
650 views

SharePoint split content database - mergecontentdbs

I'm splitting a SharePoint content database and running into a problem with the stsadm mergecontentdbs command. I'm pretty positive it is an error in my command, which is as follows: stsadm -o ...
1
vote
3answers
5k views

Proper Way to Grant Permissions in PostgreSQL

I am new to PostgreSQL and am having a bit of trouble finding any information on how to grant a user permissions on the database that they own. I have read a few sources that says the owner has all ...
1
vote
3answers
71 views

Normal database changes into a snapshot database when server is rebooted

This subject is a little bit outside of my experience, but we are trying to upgrade our server. We have a new machine, but are using the same versions of the servers on it (MS Server 2003, and SQL ...
1
vote
1answer
933 views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
1
vote
0answers
36 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
1
vote
2answers
47 views

How to disable 1 version of PostgreSQL server without uninstalling it

I have installed PostgreSQL 9.1 and 9.2 on my Ubuntu machine. The postgresql service starts both versions: $ sudo service postgresql start $ * Starting PostgreSQL 9.1 database server [ OK ] $ * ...
1
vote
1answer
177 views

InnoDB Buffer pool hit rate missing from engine status output

I want to check the buffer pool hit rate for InnoDB on MySQL but when I query the database the hit rate seems to be gone from the results: Using query: SHOW ENGINE INNODB STATUS\G ...
1
vote
0answers
98 views

SQL Azure Automated Backups doesn't work

I configured automated export of my SQL azure db, but backups are not created. Also, I'am resieved this mail. Automated SQL Export failed for [servername]:[dbname] at 25.09.2013 23:06:45. The ...
1
vote
0answers
20 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
1
vote
0answers
28 views

Move one site in Wordpress Multisite setup

I have a Multisite Wordpress setup with a dev box and a live. Whenever my developers change a theme on one of the sites or add a page/post/any other content on the deb box, I have to take the whole db ...
1
vote
1answer
560 views

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 ...
1
vote
1answer
88 views

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service ...
1
vote
1answer
74 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the ...
1
vote
1answer
255 views

Database maintenance plan fails to run everytime

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the ...
1
vote
1answer
34 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
1
vote
1answer
1k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
1
vote
1answer
498 views

Load balancing issue with pgpool2 and postgresql-8.3

I'm using the latest release of pgpool2 on Ubuntu 8.04 with postgres 8.3.11. Replication is working great, but none of my SELECT queries are being load balanced to my secondary server. These are ...
1
vote
0answers
424 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
1
vote
3answers
835 views

Can we restart a SQL Server instance remotely?

I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled I am connecting ...
0
votes
4answers
601 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
0
votes
3answers
213 views

Finding an optimal balance of I/O, CPU, and RAM for MySQL

For a long time I’ve wanted to know how MySQL scales as you add more memory to the server.We looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, ...
0
votes
2answers
4k views

How to change the default instance of SQL Server?

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We ...
0
votes
2answers
103 views

Move SQL Server Databases to new installation

I am reinstalling Windows on a developer workstation, that runs SQL Server 2008R2 and contains a lot of SQL Server databases (~50). After the reinstall, I want the SQL Server up and running with the ...
0
votes
1answer
112 views

Mysql slow query log issue…?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # ...
0
votes
2answers
370 views

Setting up mysql on mac

I have successfully installed mysql on my mac, and now on the command-line I can type which mysql and the mac replies back the expected path. I would like to get started with the tutorial here. But ...
0
votes
1answer
2k views

Make a copy of database with SQL Server Management Studio Express 2005

I have a database in MS SQL Sever 2005 Express. I need to make a duplicate of it to test some upgrade scripts. I've tried to backup and restore to a new database, and it fails because it can tell the ...
0
votes
5answers
1k views

MySQL privileges - DROP tables, not databases

Can someone help me with privileges here. I need to create a user that can DROP tables within databases but cannot DROP the databases? From what I understand from MySQL docs you cannot simply do ...
0
votes
2answers
1k views

How should I copy the “mysql” database to my new server using PHPMyAdmin

My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new ...
0
votes
1answer
717 views

Progress 8 database on Unix to OpenEdge 10 on Windows?

Is it possible to upgrade a Progress 8 database to a OpenEdge 10 database, when the operating systems differ? Progress database files from version 8 need to be upgraded to version 9, and then to 10 ...
0
votes
1answer
44 views

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 ...
0
votes
1answer
71 views

Why won't Postgres start after stopping it?

Postgres was running just fine (I have created a database using template0). Then, I used: $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart to stop Postgres and it stopped ...
0
votes
2answers
118 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
0
votes
1answer
288 views

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i ...
0
votes
1answer
58 views

Index Proposals

As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
0
votes
3answers
262 views

Mysql Slow queries log

Is their any way to filter mysql slow queries database specifically from /var/log/mysql/mysql-slow.log file. I have a mysql server with 5 live databases. I am trying to optimize this server. Also I ...
0
votes
1answer
223 views

Scripts to automate maintenance on thousands of databases?

We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the ...
0
votes
1answer
232 views

How often would you run the Postgresql maintenance tasks

After reading the Postgresql documentation, we found that it's recommendable to run the Vacuum tasks daily: We recommend that active production databases be vacuumed frequently (at least nightly), ...
0
votes
1answer
147 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
0
votes
1answer
111 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...
0
votes
1answer
1k views

Easiest way to export functions from a MySQL DB

I am migrating a bunch of changes from our dev database, consisting of some extra tables, the data from a subset of these tables, and some new functions. Using phpmyadmin I have exported the structure ...
0
votes
1answer
2k views

How to copy marked lines in a Textpad…?

I had exported the table structure of my live Database.And open it with help of Textpad.It is very huge file and i want to copy a particular lines from the textpad.I mean,i want to copy marked lines ...
0
votes
1answer
204 views

long dataset of small rows — infrequent writes, very frequent reads — what's the best platform?

A part of the platform I am building requires a large data table (starting at tens of millions of records, scaling to hundreds of millions within a year or two, maybe reaching billions at some point). ...
0
votes
1answer
226 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...