Questions tagged [database-administration]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
67 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 >...
user avatar
0 votes
0 answers
19 views

Make a mongodb instance running on localhost available on public port on remote server

I am running a mongodb instance on on localhost on protected_server which is not accessible from the outside and I want to make my database accessible on the 27017 port of open_server. I tried ssh -R ...
user avatar
  • 133
1 vote
3 answers
4k 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 ...
user avatar
  • 13
0 votes
1 answer
374 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 ...
user avatar
0 votes
1 answer
64 views

MDSplus configuration: How to Change the Start Shot Number in an MDSplus tree?

When creating a new MDSplus tree, it's possible (or perhaps even required) to specify the smallest shot number for which data can be stored in the tree. Shot numbers are just index values identifying ...
user avatar
1 vote
1 answer
173 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 ...
user avatar
0 votes
1 answer
109 views

SQL Server file is in Is_media_read_only mode and can't apply TDE as a result

We have a database that we restored to a server and have been read/writing to that database for quite some time. We are now trying to apply TDE to that database and it will not allow us because it ...
user avatar
0 votes
1 answer
298 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
user avatar
0 votes
1 answer
31 views

Link two fields in one table to one field in a second table, and create qry in Access

I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works... Essentially there are a list of patients who provide multiple blood ...
user avatar
  • 1
0 votes
1 answer
540 views

MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms

I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
user avatar
1 vote
1 answer
4k 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 ...
user avatar
0 votes
0 answers
103 views

Can you store encrypted passwords in ConnectWise Manage or will they always be plain text?

Title pretty much says it all. I need to store passwords for devices and configurations but I want them to be stored securely and encrypted. Can this be done with ConnectWise Manage?
user avatar
1 vote
0 answers
75 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 ...
user avatar
  • 143
0 votes
1 answer
257 views

postgresql does no restart after changing postgres.conf or pg_hba.conf. This incident happened while i was trying to setup the postgresql BDR

I am not able to login to postgresql after restarting postgresql DB after configuring pg_hba.conf and postgresql.conf file. The snapshot of the error is attached for referral postgresql.conf / pg_hba....
user avatar
0 votes
1 answer
300 views

Removing cluster node from always on cluster

I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster. We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...
user avatar
0 votes
1 answer
751 views

PostgreSQL 10 does not start after something

I'm handling a strange problem with one installation of PostgreSQL 10.4. One of the databases instances of PostgreSQL have stopped working after 7 months without issues. When this guy saw that the ...
user avatar
1 vote
0 answers
62 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 ...
user avatar
1 vote
1 answer
48 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? ...
user avatar
2 votes
1 answer
336 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 ...
user avatar
0 votes
0 answers
23 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
user avatar
0 votes
0 answers
36 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
user avatar
0 votes
1 answer
201 views

Automatic update of cells on a second tab when they are merely a copy of the previous tab

I have 2 tabs in excel, part of the information on tab one is to be copied into tab 2. It works ok until I insert a new row into the tab 1 spreadsheet. That change to the cells does not reflect in the ...
user avatar
1 vote
0 answers
59 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 ...
user avatar
  • 71
2 votes
1 answer
3k 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 '...
user avatar
2 votes
1 answer
328 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 ...
user avatar
  • 121
0 votes
1 answer
2k views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
user avatar
  • 103
0 votes
0 answers
266 views

Odoo 10 stock transfer under wrong company

The Scenario I am running Odoo 10 Community on a postgresql 9.4 database. I have multiple companies setup, including a parent company and two child companies. A PO was setup incorrectly in the ...
user avatar
3 votes
4 answers
862 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 ...
user avatar
0 votes
0 answers
54 views

What are the steps involved to share the credentials with multiple applications?

I have 2 scenarios here. app1 and app2 both belong to the same domain app1 and app2 both do not belong to the same domain. For both scenarios, I require the responsibilities of frontend and backend ...
user avatar
2 votes
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 ...
user avatar
2 votes
2 answers
424 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. ...
user avatar
  • 63
0 votes
1 answer
1k views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
user avatar
0 votes
1 answer
208 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
user avatar
  • 63
1 vote
0 answers
52 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 ...
user avatar
  • 182
1 vote
2 answers
13k 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, ...
user avatar
  • 121
0 votes
1 answer
262 views

How to give DBA Rights to Domain User Account

How can we give rights / permission to domain managed user account, to manage SQL Databases, typically a DBA Rights? I am on Windows OS.
user avatar
  • 111
0 votes
1 answer
37 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
user avatar
0 votes
1 answer
277 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
user avatar
  • 477
0 votes
1 answer
163 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
user avatar
-1 votes
1 answer
5k views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
user avatar
  • 1,998
0 votes
1 answer
752 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 ...
user avatar
  • 1,998
1 vote
2 answers
4k 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 ...
user avatar
  • 1,360
1 vote
0 answers
678 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/...
user avatar
  • 111
0 votes
1 answer
51 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...
user avatar
2 votes
1 answer
295 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 ...
user avatar
0 votes
0 answers
219 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
user avatar
  • 101
0 votes
2 answers
3k views

Adminer error (No PHP extension supported (SQLSRV, MSSQL) available

Adminer is a db management tool made in php (http://www.adminer.org/) I've installed it in Linux LAMP but I get the same error I've written in the Question Title. Did anybody solve this? How? I am ...
user avatar
  • 1,836
4 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 ...
user avatar
-1 votes
1 answer
1k views

Do oracle database servers use a license key?

I installed oracle Linux and oracle database on a test server using the media on the OTN. I noticed that no key was required. My question is this: On a production environment at some point do I have ...
user avatar
  • 237
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 ...
user avatar