Operating system produced by Microsoft. Windows is produced in various desktop and server versions.

learn more… | top users | synonyms

-1
votes
0answers
19 views

PostgreSQL on Windows - Terrible performance

Performance is extremely bad. Every query is painfully slow. PostgreSQL 9.5 Windows Server 2012 R2 16GB RAM i5-6600 @ 3.3GHz postgresql.conf is here: http://pastebin.com/Zxuejyi3 Tried ...
-2
votes
1answer
23 views

Application load considerations, use what you get vs. not all at once

General question: Should I as an application use all resources I can get and thrust the OS schedeuler or should I already do some load considerations for the OS. If so, what metric should I use? ...
2
votes
1answer
41 views

How do you configure Postgres 9.4 for incremental backups and hot standby?

I want to set up Postgres to do incremental backups. I'm using PostgreSQL 9.4 on Windows with a database that weighs about 1GB and has a growing 10000 records each day. I understood that the steps ...
3
votes
1answer
59 views

Using a Different Windows Account for Invoke-Sqlcmd

I'm attempting to make a Powershell script that needs to interact with SQL Server, so part of the script will involve invoke-sqlcmd. However, the script can't be scheduled as a job in SQL Server and ...
1
vote
1answer
66 views

Why do innodb tables get corrupted so easily?

I'm upgrading a legacy system running MySQL 5.1 all the way to MariaDB 10. We're on a brand new Windows server, running XAMPP. I've done plenty of DB migrations in my time but this one has just been ...
0
votes
0answers
31 views

Oracle 11g databse control with Enterprise manager on Windows 7 64 bit error

I am trying to install Oracle 11g on Windows 7 64 bit. I get Successful installation until when I get to connect to the database I got a message error.I login as a Username "Sys" with password and ...
0
votes
1answer
40 views

Update row contents on some condition

For example, let's say I'm building a database for an auction system, in which various users can partake in both selling and bidding on different items, I'd want for an "Auction" instance to also ...
0
votes
0answers
12 views

Is there anyway to check what is the PostgreSQL data directory programatically?

I'm doing an installer to my program and I'd like to check if the databases already exists in the computer. I do this in a horrible way, calling psql -lqt | findstr dbname. If someone knows a better ...
1
vote
1answer
129 views

Installing SQL Server 2012 error

I am installing SQL Server 2012 on Windows 7 Enterprise on a company laptop. I am getting SQL Server Setup failure An invalid return code was encountered waiting for a program to execute. ...
2
votes
1answer
143 views

ORA-12546: TNS:permission denied, on Windows through Task Scheduler

I am trying to export all objects of specific oracle user by executing a batch file through Windows Task Scheduler: exp.exe myuser/pass@dbname owner=myuser log=mylog.txt The Oracle 11.2.0.4 x64 and ...
1
vote
2answers
30 views

Recovery of a corrupted database using only the .frm in Windows

Is it possible to restore mysql database using only .frm files in Windows
0
votes
0answers
10 views

Is it possible to create a SQL Server 2012 cluster with the node name becoming the cluster name?

For example, I have a single, stand-alone SQL Server 2012 system that I want to put into a two-node cluster. Due to the amount of effort reconfiguring all the applications that use that server would ...
0
votes
1answer
57 views

Increase sga_max_size on Oracle 10g Windows

i would like to increase the max memory size of one Oracle 10g database installed on Windows. The v$parameter shows sga_max_size 452984832 and sga_target 452984832 Note that the ...
0
votes
0answers
76 views

PostgreSQL on windows fail to start - 'could not create shared memory segment'

PostgreSQL 9.4 & 9.5 (beta) on my Windows 7 laptop fail to start. In windows event log I see the following error: 2015-11-10 13:53:49 IST FATAL: could not create shared memory segment ...
1
vote
1answer
42 views

Can't create a Database on Oracle 11g

I'm new on Oracle and I'm trying to create a new database. I followed tutorials online but the problem seems to be in Windows and not in Oracle. I'm using the Oracle assistant to build my Database ...
0
votes
1answer
38 views

Checking whether my pgAdmin III is a 32 or 64 bits version

I need to check if my pgAdmin III is a 32 or 64 bits version. Where can I find this information? The About... menu in pgAdmin GUI does not mention it (only the version number like 1.20). I've looked ...
6
votes
1answer
995 views

Install MySQL for Windows from .zip and reset root password

I wanted to have on my PC (with Windows 8.1 x64) the MySQL server only, without Workbench or something. So I downloaded .zip archive from dev.mysql.com/downloads. It's a download for Win64 on x86_64 ...
0
votes
0answers
142 views

MySql Workbench 6.3 error with Server Status on Windows 7

I am using 32 bit Windows 7 Ultimate and MySql Workbench 6.3, with WAMP installation (MySQL5.6). I am able to set connection, and run few SQL queries against test named database. But whenever I ...
0
votes
0answers
51 views

Postgres user credentials for copying WAL files to a network storage in Windows

I have 3 postgres server setup with streaming replication - 1 primary and 2 secondary servers, one intended as a failover server and another as DR. I want to setup WAL archiving on to a network ...
1
vote
2answers
149 views

MySQL - Slow InnoDB Write Speeds on Windows 10

I have Windows 10 bootcamped. I've installed the latest version of MySQL community server. I've also installed WordPress onto IIS. The MacBook has 16Gb of memory. Here is my config file [client] ...
1
vote
0answers
45 views

PostgreSQL: Installing a contrib extension on windows

I am trying to install this Temporal Tables extension into my localhost installation of PostgreSQL. (pg9.4, windows 7) I have figured out I needed to put the files into the 9.4/share/contrib folder ...
0
votes
0answers
38 views

Installation of SQL*Plus and SQL Server Management Studio into Windows Tablet

I would like to check if SQL*Plus client and Microsoft SQL Server Management studio (SSMS) are supported in Windows(8.1) tablet? Windows tablets such as Asus or Lenovo MII3/thinkpad 8 comes with ...
1
vote
1answer
82 views

How do flush innodb table, copy files, then unlock tables from Windows bat file?

I can successfully execute "FLUSH TABLES myTable FOR EXPORT;" in MySql Workbench. Then I can copy the cfg and ibd files I need, and then I can go back to workbench and run "UNLOCK TABLES" and all is ...
0
votes
1answer
22 views

MySQL Linux and Windows entity changes [closed]

I have a trigger on an entity that copies the row and saves it in a different entity. I also have 2 MySQL servers one on Linux and the other on Windows. It seems the order of the columns in the same ...
1
vote
0answers
47 views

Connecting to MS SQL server from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain ...
1
vote
0answers
35 views

Effect of upgrading windows server 2012 data center

I have a production windows server 2012 data center server where IIS and SQL server was installed and replication was configured in SQL Server. It is infected with a malware. After cleaning it with an ...
1
vote
2answers
28 views

MySQL Drive Storage Allocation

In our production servers for SQL Server, we usually split our drives by Software, Logs, Data, and Backups. I've been assigned to help with a MySQL installation (On Windows Server) and I'm not as ...
2
votes
0answers
55 views

Identifying table causing runaway rollback in MySQL 5.5 (InnoDB / Windows)

I have a large database (180 GB), running under Windows, with a runaway rollback that starts running as soon as the database is started up. I have started the database with innodb_force_recovery=3 ...
0
votes
0answers
57 views

Lost my Databases after using Xampp - Mysql (Windows)

This migth seem a newbie seek up question, but I'm intrigued with a problem that arose. I use Windows (ok, I know its not a good OS to deal with database and stuff) and I had Mysql installed with the ...
1
vote
1answer
66 views

How I compact WAL files?

I like compact WAL files. Actually I do: archive_command = 'cp "%p"C:\\%f"' What is the best way to do it?
0
votes
1answer
55 views

Windows ODBC Driver versions for Netezza

I am looking for information regarding the Netezza windows ODBC driver versions. What are the supported/preferred windows ODBC driver versions for Netezza 7.2, Netezza 6.1 and Netezza 6.0. Any ...
0
votes
1answer
212 views

Changing Data Directory on MySQL DB Server

I have installed mysql server 5.6.24 on Windows Server 2012 R2. I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data I want to change directory like ...
3
votes
2answers
75 views

What's the quickest way to periodically export PostgreSQL data to a local file on Windows?

I have access to a PostgreSQL database that I need to get data from for another system. The other system is running Windows 7 and does not (yet?) have PostgreSQL installed. Ideally, I'd like to have ...
0
votes
0answers
72 views

Importing old SQL database dump onto local Windows 10 desktop system

Hi I just installed MySQL 5.6 on Windows 10 x64. I'm trying to execute an old backup file that happens to be 5 gigs. Some of the insert lines are really long and so the server loses connection. I ...
3
votes
0answers
548 views

“could not write to log file, Bad file descriptor” error when working with huge table

I'm having a big problem with a PostreSQL database. Whenever I do something with a huge table (over 9 million rows) the whole postgres process crashes with the following entries in the log file: ...
0
votes
1answer
85 views

Some tables not found after moving MySQL database from Linux to Windows

I had a MySQL database which I was working with from Linux. Some of the schema/table names were in mixed case. I then needed to work with the same database on Windows, but because of the enormous ...
0
votes
2answers
106 views

How to add deleted user in sql server? [duplicate]

I have set up sql server 2008 in windows server 2008 r2 and it works fine. However, I have deleted the my user from logins in the sql server accidentally and now I cannot find a way to log in to the ...
0
votes
0answers
36 views

Where can I find exact rules of a collation?

Is there any documentation anywhere for the exact sorting/equality rules defined by a collation in Windows (SQL Server), for instance "Finnish_Swedish_CI_AS"? I know about CI/CS, AI/AS etc, but I'm ...
3
votes
1answer
286 views

current_timestamp default column value working in Windows but not in Linux

This MySql query runs fine in Windows: CREATE TABLE `posts`.`table` ( `idTable` INT NOT NULL AUTO_INCREMENT, `Column1` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`idTable`)); In ...
1
vote
1answer
1k views

import CSV into mysql table via command prompt (MySQL 5.6.25)

I'm trying to load CSV's into a mysql database with this command: LOAD DATA LOCAL INFILE '\Users\userName\Downloads\tableName.csv' INTO TABLE tableName FIELDS TERMINATED BY ',' LINES TERMINATED BY ...
1
vote
0answers
29 views

Test Failover SQL Server 2012 [closed]

I have created simple FAILOVER cluster in SQL Server 2014 on Windows Server 2012 R2. This is my development lab and never worked on have a fail over cluster with SAN. As this is my development lab ...
1
vote
1answer
76 views

Windows crashes on doing sql dump [closed]

Windows simply crashes and opens the blue screen for dumping physical memory on trying to import sql dump. Blue screen error: IRQL_NOT_LESS_OR_EQUAL So far I have tried 4 methods: Through workbench ...
3
votes
1answer
337 views

Importing via sqlcmd errors out

PS C:\Users\administrator.INTERNAL\Desktop> sqlcmd -S SQLMAIN\MSSQLSERVER -i rdmdb.sql Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server Network Interfaces: Connection string is ...
0
votes
0answers
31 views

MongoDB fsyncUnlock won't unlock occasionally on Windows

We have a MongoDB replica set installed on Windows servers, with a scheduled backup job. MongoDB is configured to use journaling. The job runs db.fsyncLock() via script on MongoDB (primary server), ...
0
votes
1answer
110 views

Multi Source replication on single slave having multiple instances MySQL

i had 1 instance of mysql 5.6 on one server A (Slave S) 1 Mysql installed on server B ( Master M1) 1 MySql installed on server C ( Master M2 ) At Slave end : I have created one more instance by ...
0
votes
1answer
41 views

For multiple mysql instance , fresh download required when one exist?

i need multiple instances of Mysql on same server. I had been through many links , but i confused here : What i have : MySQL 5.6 is already installed on my windows server A. Installed at : ...
1
vote
1answer
137 views

Cannot delete MySQL trigger. Appears in information_schema, but no .TRN file

I have a MySQL database with a few tables and triggers. A process was trying to drop one of the triggers and it failed with the following error: Malformed file type header in file 'trigger_name.TRN' ...
3
votes
1answer
104 views

Get problem with Binlog_Do_DB in Master configuration

I have followed all the rules for replication. The steps are I have changed the my.cnf file. My db name is new_db. server-id = 1 log_bin = D:/xampp/mysql/mysql-bin.log binlog_do_db = new_db Grant ...
0
votes
0answers
38 views

Replicating table level PostgreSQL 64bit windows

I need to replicate some tables on PostgreSQL 64bit for Windows (master -> slaves replication model) and I can't find any tool that can achieve that. Slony-I work very well for PostgreSQL 32bit for ...
0
votes
2answers
59 views

MySQL Upgrade on Windows

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...