Super User
Super User

Questions tagged [database-administration]

Questions about how to install, configure or tune the configuration of any database package.

84 questions
5
votes
2 answers

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute until completed? Can I mysqldump in this way on a…
silipulse
  • 53
5
votes
1 answer

How Do I Investigate a CPU Usage Spike Without Being Present?

I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to trigger if CPU usage goes over 50% and this seems…
CadentOrange
  • 294
5
votes
4 answers

Login to Oracle database without username and password

I want to login to a database by running an SQL file from a Unix script without supplying username and password (as root). Is this possible? The database is Oracle.
sam
  • 51
4
votes
1 answer

Grant MySQL user ability to create databases, and only allow them to access those databases

Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other than the databases they create themselves, they…
Gene Goykhman
  • 198
4
votes
4 answers

Why is Hadoop not a Data Warehouse?

What are functional reasons why Hadoop cannot be a Data Warehouse On several sites one can see statements that a Hadoop cluster is not a replacement of a traditional data warehouse. However, I can't find the real reasons why. I am aware that…
Dennis Jaheruddin
  • 496
  • 1
  • 5
  • 24
3
votes
2 answers

Collaborative use of bibtex as an online database (JabRef)?

I am thinking about a collaborative effort, where several people would need to insert data; for different reasons, it would be most convenient that this data is in bibtex format (the references format for latex). Now, I know JabRef reference…
sdaau
  • 6,008
3
votes
1 answer

Access H2 Database from Outside of the App

I have an embedded H2 database running for a web-app that I am working on. The programmer who built the app has gone and I am faced with learning the system and figuring out a way to look into this database. So what I'm looking for is something…
nicorellius
  • 6,815
3
votes
1 answer

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY 'password123'; CREATE USER 'bob'@'10.1.1.1' IDENTIFIED BY…
Chaminda Bandara
  • 559
2
votes
1 answer

Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See

My computer has the following Software involved. Microsoft Windows 7 Microsoft SQL Server 2008 R2 Microsoft SQL Server Management Studio Moreover, I have the following Drive partitions: C: drive D: drive E: drive Therefore, when I created the…
user1338998
  • 259
  • 1
  • 9
2
votes
1 answer

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL 2008 Express, but we are not upgrading the Client…
Jim
  • 338
2
votes
0 answers

How do I enable fully qualified column names in Query Builder in Toad for Oracle?

I've found several hits on google on how to do this in Toad for SQL, but I need the same for Toad for Oracle. (Toad v11). I'm building a large query where I combine several aliases of the same table (a Kimball-style datamart). I have hundreds of…
gorzan
  • 121
2
votes
2 answers

How do I export the data from an Oracle SQL Developer query

How do I export the data from an Oracle SQL Developer query? I can create queries in it fine, but as to export?
SteveC
  • 2,193
2
votes
2 answers

Oracle admin tool for mac os x

I'm looking for desktop admin tool similar to Navicat for Oracle in Mac os X. Navicat it's OK but it is quite buggy. Any other recommendations?
Fgblanch
  • 647
2
votes
3 answers

What is default admin for SQLite?

Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?
King
2
votes
1 answer

MariaDB: Should I configure the db-server using "/etc/my.cnf" or a file in "/etc/my.cnf.d"?

I am trying to configure MariaDB on a machine with Fedora 37: Workstation as its operating system. I expected to use /etc/my.cnf to configure the ports and such, however, the file contained an include to the directory /etc/my.cnf.d. I am confused as…
I sekai tensei
  • 1,340
1
2 3 4 5 6