The database-administration tag has no wiki summary.
9
votes
13answers
2k views
Linux knowledge a Junior cannot miss [duplicate]
Possible Duplicate:
What a beginner should know/learn for sysadmin job?
I am soon going to be graduating from college, and am looking for job offers right now. There is one that I have a ...
1
vote
1answer
72 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
981 views
Deleting huge chunks of data from mysql innodb
I need to delete a huge chunk of my data in my production database, which runs about 100GB in size. If possible, i would like to minimize my downtime.
My selection criteria for deleting is likely to ...
35
votes
9answers
38k views
How can I export the privileges from MySQL and then import to a new server?
I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server.
For extra points, there are a couple of existing databases on the new ...
1
vote
5answers
14k views
How can I synchronize MS SQL Server databases?
How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
3
votes
5answers
925 views
What is “The” book for database design? [closed]
In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc.
Is their a book regarding modern database design that simply must be ...
1
vote
2answers
129 views
MySQL Table not repairing
Table info:
Database name: user_motiva
Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD
when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
2
votes
2answers
167 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
215 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 ...
1
vote
3answers
2k views
How do you clone an oracle instance?
How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname.
I'm working with Oracle 10.2.
1
vote
6answers
2k views
SQL 2005 Database Not Accessible
I've moved a database from sql 2000 to a new 2005 server. Everything was fine until I logged into Sql Server Management studio with one particular user. It looks like i logged in successfully but when ...
0
votes
1answer
410 views
Connect to and reindex Postgres database with system table errors
I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per http://serverfault.com/questions/156152/after-db-disk-failure-now-cache-lookup-failed-for-index).
...
0
votes
1answer
553 views
Configuring MySQL logging for an audited environment such as SOX
How do you configure MySQL users and logging to satisfy SOX auditors?
For example, if you need to log queries and the source of the query for later review by an internal SOX controls group.
Is there ...
0
votes
2answers
3k views
Configuring keepalives with TOAD client communication
I have a scenario where long-idle sessions of TOADSoft client communication with the Oracle server seem to be torn down as they timeout on an intermediate state-full firewall.
These sessions could ...
