Questions tagged [database-administration]

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

Filter by
Sorted by
Tagged with
5 votes
2 answers
2k views

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 ...
silipulse's user avatar
5 votes
4 answers
11k views

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's user avatar
  • 51
4 votes
1 answer
21k views

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 ...
CadentOrange's user avatar
4 votes
4 answers
1k views

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 ...
Dennis Jaheruddin's user avatar
4 votes
1 answer
5k views

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 ...
Gene Goykhman's user avatar
3 votes
1 answer
4k views

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 '...
Chaminda Bandara's user avatar
3 votes
2 answers
4k views

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 ...
sdaau's user avatar
  • 5,528
3 votes
1 answer
2k views

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 ...
nicorellius's user avatar
  • 6,715
2 votes
1 answer
428 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
Cody Rutscher's user avatar
2 votes
1 answer
11k views

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 ...
Jim's user avatar
  • 338
2 votes
2 answers
1k views

Oracle admin tool for mac os x [closed]

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's user avatar
  • 647
2 votes
1 answer
3k views

Is there any way to export MySQL Workbench 8 connections by shell commands?

I need to add some shell commands to my backup script to take a backup of defined MySQL connections in the Workbench. MySQL workbench allows this in its GUI: menu bar > Tools > Configuration >...
Masoud Shariati's user avatar
2 votes
2 answers
16k views

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's user avatar
  • 2,154
2 votes
2 answers
476 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
Karl's user avatar
  • 63
2 votes
1 answer
486 views

Simulating file corruption on Linux programmatically? (for DB durability testing)

Basically, I want to fwrite() n bytes and have < n bytes be written on the actual disk, or whatever other inconsistency artifacts could arise (like sectors being written out-of-order). I know I ...
joonas.fi's user avatar
  • 121
2 votes
1 answer
344 views

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 ...
user1338998's user avatar
2 votes
0 answers
356 views

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 (...
gorzan's user avatar
  • 121
1 vote
1 answer
13k views

How to reset the postgres super user password on mac os x

I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it. All the directions I found ...
Andrew Lauer Barinov's user avatar
1 vote
3 answers
9k views

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?
user avatar
1 vote
2 answers
8k views

How to start only one version of PostgreSQL database, in this case 9.1?

I have installed PostgreSQL 8.4 and 9.1 on same Ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...
Damir's user avatar
  • 229
1 vote
1 answer
2k views

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 ...
JΛYDΞV's user avatar
  • 868
1 vote
2 answers
5k views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
Thufir's user avatar
  • 1,610
1 vote
1 answer
3k views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
Thufir's user avatar
  • 1,610
1 vote
2 answers
3k views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
pixelbadger's user avatar
1 vote
4 answers
164 views

Editing an SQL Database

I'm new to php, so I installed xampp for windows. Is there a windows software for easy MySQL administration? (creating/displaying/editing tables + data, creating relations ..) i've managed to open ...
Fuxi's user avatar
  • 803
1 vote
2 answers
3k views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
Igor Chudov's user avatar
1 vote
1 answer
616 views

MongoDB Command Line Tool

Is it possible to enter arbitrary command in MongoVUE and get result? If there is not such feature do you know any other windows app that can be used as mongo front-end console?
Real Dreams's user avatar
  • 4,932
1 vote
1 answer
4k views

Oracle SQLDeveloper locks up when using copy/paste

SQL Developer keeps locking up when I copy/paste text in a worksheet. It happens when I past into SQL Developer from itself or from another application and also when I past from Developer into ...
Chris Nava's user avatar
  • 7,215
1 vote
3 answers
6k views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
Red Hat's user avatar
  • 13
1 vote
1 answer
311 views

Database Reverse engineering wizard Fails

I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
harvey_carmichael's user avatar
1 vote
1 answer
7k views

PostgreSQL getting error during pg_restore using pgadmin pg_restore: [archiver (db)] could not execute query: ERROR: role does not exist

I am trying to restore a database from one schema to another schema in PostgreSQL using pgadmin backup and restore utility. The backup is successful for the database A but when I try to do the restore ...
Sunil Cyriac's user avatar
1 vote
0 answers
82 views

How to connect to a PostgreSQL database?

I have a website written in Python / Django, and it is functioning well on a CentOS server (I wasn't one who set it up though). Now I want to set this website up locally on my Mac OS X or Linux system ...
sequence's user avatar
  • 153
1 vote
0 answers
67 views

Talend ETL tutorial [closed]

I need a good tutorial on how to use Talend ETL tool to automatically apply ETL process once new files are added to the directory. eg. (using file watcher). Any useful tutorial on talend is also ...
Zuhair Ahmed 's user avatar
1 vote
1 answer
51 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
GwenKillerby's user avatar
1 vote
0 answers
62 views

Data security in server at home

I am a beginner linux user, and am planning on provisionally opening a game server on a machine I have at home. In addition to the possible DDoS attacks that may occur on this server (the server will ...
Roland's user avatar
  • 71
1 vote
0 answers
53 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
Learner's user avatar
  • 190
1 vote
2 answers
16k views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
Keyjote's user avatar
  • 121
1 vote
0 answers
752 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
Alfons's user avatar
  • 111
1 vote
0 answers
1k views

Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

I intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] . 1....
Praneeth Pj's user avatar
1 vote
1 answer
1k views

How to migrate a database from MyISAM to InnoDB?

I am migrating a database with MyISAM tables to an InnoDB engine. Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
Santhosh S's user avatar
1 vote
1 answer
223 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
Sean's user avatar
  • 181
1 vote
2 answers
1k views

How to pull huge table (80 millions rows) from Oracle into SQL DB or SQL dump via VPN

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is ...
Matthias's user avatar
1 vote
1 answer
669 views

How can I modify tables and forms in a MS Access database using UA Business Software 7.0?

I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0 The problem is that UA hides everything and everything is locked.. It doesn't even look ...
Shawn's user avatar
  • 1,341
1 vote
0 answers
132 views

How can I get call centre information from CallCenterAnywhere

Our organisation uses some software called CallCenterAnywhere to manage a customer services centre which it does well as far as I can tell, but we'd like to extract some information from it to present ...
Baris's user avatar
  • 11
0 votes
2 answers
5k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
JAN ORTS's user avatar
0 votes
1 answer
14k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
AbdulAziz's user avatar
  • 113
0 votes
1 answer
790 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
drew1kun's user avatar
  • 2,127
0 votes
1 answer
54 views

Model for Cooperation in a class? [closed]

Assume you have six classes of students with low level of computer skills. They use Gmail inboxes to store old exam questions, notes and tips. Dropbox and Google Drive too, since Gmail inboxes get ...
Léo Léopold Hertz 준영's user avatar
0 votes
3 answers
2k views

Is it possible extract/delete part of oracle data dump?

We have an Oracle 11g schema and data dump. As this dump is very large, I would like to extract only part of schema with data. Is this possible to achieve?
nimo's user avatar
  • 1
0 votes
1 answer
805 views

Physical to Virtual Migration using Disk2vhd utility

We are currently in plan of migrating physical to virtual servers for both DB & App servers. Currently we are with SQL Server 2014 AOAG System. Databases are FileStream enabled. Currently we have ...
Learning_Learning's user avatar