The tag has no wiki summary.

learn more… | top users | synonyms

5
votes
4answers
1k views

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that ...
3
votes
3answers
994 views

How to change default recovery for new databases?

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default? Currently if we remember, when creating a ...
1
vote
1answer
114 views

Table Space and Data Sized increased multiple times after power failure

We had a total power failure on our 2 node cluster using SQL Server 2008 (10.0.2531) Standard Edition. After recovery, everything is running fine. One issue I discovered is the Table Size and the Data ...
0
votes
1answer
431 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 ...
1
vote
4answers
2k views

how to restore my mysql 5.1 on ubuntu 10.4?

I am in big trouble not able to access my mysql server.. after restarting grep mysql /var/log/syslog is showing Jul 30 14:30:23 of-desktop kernel: [ 4763.427066] type=1505 audit(1280480423.517:20): ...
0
votes
1answer
86 views

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the ...
2
votes
1answer
61 views

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

copy a MySQL table which has data in ibdata file

I have a database in MySQL with several tables. Some of the tables only have .frm files. Some have .frm .mdy .mdi I believe data for the .frm tables is in the ibdata file. There is a lot of data in ...
3
votes
1answer
3k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ...
1
vote
2answers
229 views

create a 'definition' file from Oracle

I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am ...
1
vote
4answers
2k views

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

MySQL connection issue with error 2003 / 111

I'm running a mysql server using the following command: mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables & My understanding is that this command starts ...
0
votes
1answer
184 views

ASP.NET Application Connection String and SQL Server Security / Permissions

I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company ...
2
votes
1answer
28 views

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 ...
4
votes
2answers
612 views

MySQL 5.5.16 allows anonymous connections

Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access ...
1
vote
2answers
381 views

[MySQL]multiple-masters single-slave

Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ? If yes, how to do it ?
2
votes
3answers
2k views

Access to SQL Server when administrator account deleted

An interesting situation here. We have a database server, used for testing only, where someone went in and deleted the administrator login. Since this is a test server the was no other admin level ...
1
vote
5answers
532 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
3
votes
4answers
1k views

Using linked servers to query across database servers?

We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
2
votes
1answer
54 views

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 ...
2
votes
3answers
4k views

MySQL maintenance - how to clear the buffer?

We have a server running our web app (PHP / MySQL) which is SLOW. My predecessor says that: "We use to do database maintenance, which use to clear the buffer, cached and unwanted variables." And I ...
1
vote
3answers
2k 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
2answers
218 views

Curious about my database server setup

I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server. The main app that I'm ...
0
votes
1answer
243 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 ...
2
votes
1answer
2k views

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

How to set backup / database in order to maintain heavy write loads

I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here. I need your inputs with regards to management ...
2
votes
3answers
462 views

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.
1
vote
2answers
96 views

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How ...
1
vote
2answers
521 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...
2
votes
1answer
1k views

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?
3
votes
2answers
573 views

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of ...
-1
votes
1answer
69 views

Linking LDAP with other databases — design considerations [closed]

There's a company X (a call center) with about 300 workstations and a task to implement LDAP for user authentication. Fine. We put non-volatile user information (UIDs, e-mails, first and last names) ...
0
votes
2answers
107 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
203 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
129 views

Backup SQL Server database to local machine

I'm connected to the remote database using SQL Server Management Studio 2008. I'm a little bit limited for space on my server, so I just want to do a backup to an external drive connected to my ...
1
vote
1answer
488 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
1
vote
3answers
174 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
0
votes
3answers
624 views

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the ...
0
votes
1answer
113 views

Managing multiple storage volumes in Microsoft SQL Server

I have a backup application backed by many databases (one per client) in Microsoft SQL Server, storing files in the database as BLOBs. We are looking to move this application to Amazon EC2, and ...
4
votes
3answers
321 views

Naming convention for databases and database users for access by a web application?

When installing a web application where a single user is used to talk to a single database (say MySQL, but this could apply to other RDBMSes also), you often have a sequence of events such as this: ...
7
votes
2answers
2k views

With MySQL, how long does an “ALTER TABLE … DISABLE KEYS;” statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of ...
0
votes
1answer
74 views

Validate SQL Server partitions and filegroups

Information: I took over a SQL Server 2005 that the previous DBA had configured three filegroups to segregate the data onto unique LUNs: G: Data (Primary) F: Audit J: Index However, the ...
1
vote
3answers
112 views

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

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
95 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 ...
0
votes
3answers
227 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, ...
1
vote
1answer
335 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 ...
0
votes
2answers
196 views

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. ...
0
votes
1answer
401 views

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
0
votes
2answers
730 views

How to do MySQL Maintenance especially after disk is full

I have a quite large mysql database (InnoDB) running on ubuntu server virtual machine. Recently due to my fault the hard drive became full (on the physical machine) and the server got stuck and users ...