Questions tagged [database-administration]
Questions about how to install, configure or tune the configuration of any database package.
82
questions
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 ...
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 >...
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 ...
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 ...
0
votes
1
answer
87
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 ...
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 ...
0
votes
1
answer
129
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 ...
0
votes
1
answer
367
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....
0
votes
1
answer
37
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 ...
0
votes
1
answer
804
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 ...
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 ...
0
votes
0
answers
148
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?
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 ...
0
votes
1
answer
437
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....
0
votes
1
answer
384
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 ...
0
votes
1
answer
1k
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 ...
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 ...
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?
...
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 ...
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 ...
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 ...
0
votes
1
answer
330
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 ...
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 ...
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 '...
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 ...
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,
...
0
votes
0
answers
267
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 ...
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 ...
0
votes
0
answers
74
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 ...
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 ...
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. ...
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 ...
0
votes
1
answer
286
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 ...
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
...
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, ...
0
votes
1
answer
313
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.
0
votes
1
answer
38
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 ...
0
votes
1
answer
294
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.
...
0
votes
1
answer
191
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 ...
0
votes
1
answer
6k
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 ...
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
...
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 ...
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/...
0
votes
1
answer
57
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 ...
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
...
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 ...
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 ...
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 ...
-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 ...
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 ...