The database-administration tag has no wiki summary.
0
votes
0answers
37 views
can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)
I'm having the error 'can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)' when trying to log into mysqladmin and my sites have database connection errors.
Here's the ...
2
votes
1answer
54 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
30 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
79 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
35 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
33 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
24 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
...
2
votes
2answers
68 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
57 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 ?
1
vote
5answers
123 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.
0
votes
2answers
76 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 ...
1
vote
1answer
74 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 ...
2
votes
1answer
42 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 ...
0
votes
0answers
28 views
Maintenance plan on databases fail because of file level locking on db's
We are running a shared SQL server with a maintenance plan that is scheduled to run every night. The maintenance plan does reindexing on all db's but the maintenance plan now throws an error because ...
1
vote
3answers
101 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
1answer
94 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
50 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 ...
0
votes
1answer
72 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), ...
1
vote
3answers
67 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.
0
votes
0answers
116 views
sybase bcp import fails
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).
We ...
1
vote
2answers
46 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 ...
0
votes
2answers
101 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 ...
2
votes
1answer
103 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?
0
votes
1answer
79 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
2answers
160 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
2answers
73 views
RDS or SQL Azure, which one do you recommend?
I have developed a web applicaiton that does soem heavy DB work. I have developed the application using ASP.net and SQL Server 2008 Express. I wanted to know which service I should use, Amazon RDS or ...
-1
votes
1answer
54 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
94 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
81 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
82 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 ...
0
votes
0answers
37 views
Green Plum -Eror unable to write on pg_distributedlog\000A no space in disk
im wroking on Greenplum database bt while Loading huge volumme of Data through ETL
i got a strange error
unable to write on pg_distributedlog
with this error im unale to acces my pg_client in order ...
1
vote
1answer
213 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
2answers
86 views
SQL Server variable size and increase it
It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005
Is a variable declared as varchar(300000) for example considered as a varchar(max)?
E.g. I am seeing in a DB in ...
0
votes
1answer
161 views
Alternative to phppgadmin?
While trying to manage some PostgreSQL databases, I've ran into a rather peculiar problem with phppgadmin:
It is slowly (and occasionally not so slowly) eating away my last strands of sanity.
I ...
1
vote
3answers
129 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
1answer
48 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 ...
2
votes
2answers
337 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
49 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 ...
1
vote
1answer
62 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
144 views
Moving MySQL Data from 1 RDS server to another
How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another?
An interruption of up to 20 mins is acceptable, although not preferred.
My current plan ...
4
votes
3answers
83 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:
...
0
votes
3answers
164 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
63 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. ...
1
vote
2answers
62 views
clustering MS SQL 2008
I have a Project in DBMS just I need something like a BIG TITLES of What TO DO.
Here a brief way about the Project:
Install 3 WIN2K8 R2 one of them domain controller (easy)
On non DC nodes, install ...
0
votes
1answer
82 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
69 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
545 views
How well does PostgreSQL perform with a large number of databases?
We have an web application whose architecture requires that any registered user (a company, actually) should be isolated from the other, i.e., I'll run the same webapp with the same data models, but ...
2
votes
3answers
135 views
After setting root password why does MYSQL still allow me to login without a password?
After setting root password why does MYSQL still allow me to login without a password from the command line? I can type "mysql" at a root unix prompt and it asks for no password and still allows me ...
0
votes
1answer
76 views
What are the dangers/consequences of reducing the SharePoint_Config_log database?
I have used DBCC ShrinkFile on a SharePoint_Config_log database and I'm wondering what the consequences of this action may be?
The log file was growing upwards to >11 GB for an 8GB database and space ...
1
vote
3answers
55 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 ...
