Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [windows]

Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.

1
vote
0answers
16 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
-1
votes
2answers
44 views

What permissions should be added to public users sql [closed]

I have a SQL Server and am looking at making it public. What I mean by this is: I can create a DB and give access to myself and friends etc. I need to create a login which can only view databases it ...
1
vote
0answers
25 views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop but at both times i faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following ...
0
votes
1answer
48 views

Running loadjava with Windows authentication

I want to run following command under Windows with Oracle Database 12c installed: loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar The problem is that I use ...
0
votes
1answer
28 views

Oracle TKPROF Insert data doesn't match text results

I'm trying to make sense of the output from a SQL Trace from an Oracle 12.2 database on Windows. I've used TKPROF to interpret the the resulting trace files. This utility generates a text file output ...
1
vote
0answers
42 views

MySQL 5.7 issue with 16TB disk

(Repost from StackOverflow) I have a MySQL 5.7 running on a Windows Server 2016 VM with two disks from a NAS: C:\ for system and D:\ for data (empty at start). I try to create a partitioned table: ...
1
vote
1answer
43 views

Which Editions of Oracle are Free?

I am aware of Oracle Express edition which is up to version 11g, which is pretty dated. However, I have read that Oracle are changinging/have changed their licensing of newer editions so that we will ...
-2
votes
2answers
69 views

How do I install a PostgreSQL extension in Windows? [closed]

In Linux (with Ubuntu or Debian) if I want to install gen_salt(), I first install the -contrib package. sudo apt install postgresql-contrib Then I install the extension in the database, psql -d ...
2
votes
1answer
20 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
0
votes
0answers
24 views

Not able to start the PostgreSQL Database Engine getting Event ID 0 error

I am not able to restart the PostgreSQL (10.4) database engine. Getting the below error message, "The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that ...
6
votes
1answer
418 views

Error starting SQL Server 2017 service. Error Code 3417

I have SQL Server 2017 installed on my computer. This is what SELECT @@VERSION returns: Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) Jul 21 2018 07:47:45 Copyright (C) ...
2
votes
1answer
216 views

How to restore from .wt files?

Environment Windows Professional 10 MongoDB 3.6.4 2008R2Plus SSL (64 bit) (before computer crash) MongoDB 4.0.2 2008R2Plus SSL (64 bit) (after computer crash) I have been developing locally, and ...
0
votes
1answer
54 views

Always On Windows Server Edition

For setting up Always On Availability Groups in SQL Server I know you need to have at least Enterprise Edition for SQL Server 2012, 2014, or 2016. Do you also need the Datacenter or Enterprise ...
-1
votes
2answers
48 views

MySQL on Windows or Linux [closed]

I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition. What I am confused now is which OS should I choose, ...
0
votes
0answers
29 views

Do any of the PostgreSQL releases for Windows support automatic updates?

PostgreSQL has two distributions for Windows, EnterpriseDB BigSQL Do either of these Windows distributions support automatic updates for the term of support? Something that looks for the updates ...
1
vote
2answers
158 views

MySql 5.6: Ignores innodb_page_size setting in my.ini

So I tried to increase the innodb_page_size to 32k, by setting this value in my.ini: innodb_page_size=32k I then stopped the MySql service, and restarted it. The service in Win looks like this: "C:\...
0
votes
0answers
163 views

Python version issue on Cassandra 3.11.2

Searching around I found a lot of thread about this problem (coming from 2012) but I can't find an official solution: running cqlsh.bat File "C:\apache-cassandra-3.11.2\bin\\cqlsh.py", line 146 ...
0
votes
1answer
72 views

Does the Mysql install location affect write speeds?

Up until lately, I used a 32 bit version of Mysql 5.7, bundled with a WAMP server (EasyPHP) on Windows for local development, all running on an SSD. I ran into database size issues, and had to upgrade ...
0
votes
0answers
37 views

OpsCenter missing in Datastax Cassandra for Windows

Following this guide within the Cassandra installer I should get OpsCenter too. But this screenshot https://www.datastax.com/wp-content/uploads/2012/01/dsc-win4.jpg doesn't match the current release (...
1
vote
1answer
22 views

Connection is Using Properly or not in Net Use via SQL Procedure

am doing an operation of creating a file and writing in a SAN SAMBA where it will be done using the cmd_shell via SQL Procedure. It's creating and writing it successfully but while am calling that ...
0
votes
0answers
119 views

MySQLDump with Pipe Command in Windows

Is there a way to use the pipe command with MySQLDump on Windows. The problem I have is that I need to dump a slave database onto a new server. The Database to be dumped is apx 300GB. If I write it to ...
0
votes
1answer
68 views

MySql Replication on Windows

guys any one please give detailed document on Mysql Replication on Windows System.I replicated master to slave, but it is showing 'connecting to master' errorno showing as 1045 and 2003 its varying. ...
0
votes
0answers
26 views

Retrieving Mongo Databases without connecting directly to an instance

Hope someone can help. I have two MongoDB 3.6 installation set up on Windows Server and Ubuntu. Both installations (Windows and Ubuntu) have 5 databases each including the default databases. I've ...
1
vote
3answers
562 views

How to prevent asking for password when creating new database in PostgreSQL 10?

I use the following batch file to create a new database in PostgreSQL 10. echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" createdb -h localhost -p 5432 -U postgres myDB But it asks to enter ...
0
votes
2answers
45 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
0
votes
1answer
207 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
0
votes
1answer
1k views

How to create a new database in PostgreSQL 10 in Windows from batch file?

I am creating a batch file to create a new database in PostgreSQL 10. I used the following code, echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" psql "dbname=myDB host=localhost user=postgres ...
1
vote
1answer
482 views

MySQL select * from table without conditions does not return rows right away

I have a table with about 4 million rows and a bunch of columns on each row and I'm doing a simple select * from table in the mysql client and it doesn't return data right away. A count(*) of the same ...
0
votes
1answer
497 views

`“C:\xampp\mysql\bin”' is not recognized as an internal or external command,operable program or batch file [closed]

I am trying to access to mysql from windows command prompt by this command: "C:\xampp\mysql\bin" mysql -u root - p But it sayas: `"C:\xampp\mysql\bin"' is not recognized as an internal or ...
0
votes
1answer
17 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
1
vote
1answer
208 views

Access denied error when archiving WAL during postgresql 9.5 replication setup

I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video. For archive_command I use this: archive_command = 'copy "%p" "\\\\ip-address of ...
0
votes
1answer
110 views

How save psql `ERROR` output to the same file as the DDL commands?

I'm trying to restore a database from a text file. I'm following the answer on this question. How do I restore a plain text postgres .backup file But add: > c:\result.txt psql.exe -U sde sde <...
1
vote
1answer
44 views

Share mongo database between two OS on dual boot

Now I have two OS on my computer: Windows 10 and Linux (arch). Sometimes I use Linux but I also use windows because of gaming, and I want to create a small application that is going to work on both OS....
4
votes
1answer
376 views

Slow connect time to postgresql on Windows 10

Connect time to postgresql on my Win 10 machine incredible slow. It take 2.5-3.5 seconds for a connect. $ time 'c:/Program Files/PostgreSQL/10/bin/psql.exe' -h 127.0.0.1 -p 5433 -U xxx -c 'select ...
2
votes
1answer
8k views

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an ...
0
votes
1answer
220 views

Removing a FILESTREAM windows share after uninstall

I had to uninstall my local SQL 2017 Dev edition on my home PC (Windows 10) because I changed some drive structure (including where all the system databases lived) a while ago, so I needed to ...
1
vote
0answers
229 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
3
votes
1answer
192 views

mysqldump slow on Windows unless piped to file

Running mysqldump without piping to file such as: mysqldump -u root -pPASS db is really slow on windows. If I do mysqldump -u root -pPASS db > db.sql it runs fast. This might not seem like a ...
1
vote
2answers
2k views

Set TERMOUT OFF is not working when I am using sqlplus in command prompt?

I am using the sql statement listed below in my spool sql script, and I am executing this script from sqlplus. But in terminal query output is still coming and I am using sqlplus in command prompt. ...
0
votes
0answers
33 views

Never stop growing of MariaDB service memory on Windows

I have this strange problem in a Win7-4GB machine with MariaDB v. 10.1.18 using only InnoDB tables. mysqld.exe service memory grows until the OS error out of memory, it take some hours but at the end ...
0
votes
1answer
239 views

Installing command line tool with pgAdmin4

I have pgAdmin4 and the latest version of PostgreSQL installed on my machine. When I tried to insert large amount of data using INSERT statements contained in a .sql file of size 40 MB, 50MB and above,...
1
vote
1answer
1k views

Where can I download an old version of PostgreSQL for Windows? [closed]

I need version 8.4 for a legacy system, but EnterpriseDB (the official link) only shows 9.x On the PostgreSQL FTP Mirror I see the 8.4.22 binary, but only have binary for solaris:
0
votes
1answer
23 views

Problem connecting to postgresql from external windows machine

I have a Windows laptop running a postgresql database. I want to be able to pull data from this DB into an application on another laptop, say excel or access. So far, I set up a DSN on my machine ...
1
vote
1answer
32 views

Update table based on reference values from another table [closed]

I have two tables structured like so: Table1 (reference table) | Name UNIQUE | Value(Double) | Table2 (data table) | Name1 | Name2 | Number(Int) | I want to add 10 to the number in each row of ...
0
votes
0answers
22 views

Unable to Run the Postgresql 9.5 wiith pgadmin ||| in windows 8 environment

I had installed many PostgreSql 9.5 (x86) with pgadmin 3. It always failed authenticate my default user openpg. But when i tried to change my configuration as following pg_hba.conf # PostgreSQL ...
2
votes
1answer
267 views

What differences are there with SQL Server 2017's packaging of `Binn` on Linux and Windows?

Knowing that the Binn is packaged differently on Windows and Linux, I'm wondering what differences there are between the two? Do they come with different utilities? On Linux Binn is distributed in a ...
0
votes
2answers
86 views

There is already an object error after database is dropped

Started learning SQL Server and stuck with this simple code: drop database if exists dbo; create database dbo; create table dbo.a_table (a_table_a_field int not null); Running it twice in SSMS ...
3
votes
2answers
409 views

In 2-node cluster using failover with Dynamic Quorum, is Witness needed?

I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum. There is one thing that made me confused: do we really need a Witness in this case? Since ...
2
votes
1answer
2k views

SQL Server Failover Cluster Instances: why current vote is 0?

I set up a 2 node SQL Server Fail-over Cluster Instances. Each node is EC2 instance. At the moment, under "Cluster core resources", my cluster is online. But one node is online and the other one is ...
0
votes
0answers
214 views

Vanilla installation of MySQL on Windows 10 fails, service cannot start, corrupt InnoDB page

I started with a clean machine (Windows 10, 64bits), no previous installation of MySQL. I downloaded MySQL Installer Web Community 5.7.20.0, and installed the following: MySQL Server 5.7.20 (x86) ...