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

learn more… | top users | synonyms

0
votes
0answers
5 views

Windows 7 service manager thinks postgresql 9.4 is stopped, but database is up

I have several machines running postgresql 9.4 on windows 7. The database is configured to start automatically after a reboot, and it seems to start ok. pgadmin is accessible, and I can run queries ...
2
votes
2answers
1k views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...
1
vote
1answer
31 views

Run multiple MySQL instances in Windows

Which is a better way to install multiple instances of MySQL / MariaDB / etc on a single Windows box? Manually setting different ports? Docker? Virtual Box? Something else? (Sandbox, mysql_multi, ...
2
votes
1answer
202 views

Services don't have MySQL Server. How to run it?

I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there: ...
4
votes
1answer
137 views

Problems while building plpgsql_check on Windows

I try to build plpgsql_check extension by @PavelStehule (Erwin Brandstetter recommended it to me in this answer) on Windows XP 32bit with Visual Studio 2010 (I used this article as a manual). However, ...
1
vote
1answer
29 views

pg_dump fails to create a backup when running from System User in Windows Task Scheduler

I am trying to run a pg_dump through a scheduled task in windows. I have two batch files. One creates the task. The other one runs the pg_dump. Even though the pg_dump works with the current user with ...
1
vote
1answer
112 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
1answer
14 views

SQL Server can't see subst/virtual drive

I have been having trouble getting SQL Server to see subst/virtual drives at all. For example: I've used the subst command to create a F:/ drive that maps to C:/FDrive. The stored procedures use ...
1
vote
1answer
707 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
1
vote
1answer
120 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 ...
1
vote
1answer
303 views

All users are having NO Privileges in phpMyAdmin

By mistake, I changed all the privileges of user 'root' in my MySQL Database. Not even a single privilege is having for that user. Now if I log in with another user I am able to access only one ...
1
vote
1answer
2k views

Problem using pg_dump in Windows 7

I am trying to copy a remote database onto my local machine using the following command C:\Program Files\PostgreSQL\9.1\bin>pg_dump -h remote_server -U remote_user_name -c database_name | psql -a ...
7
votes
2answers
765 views

Using SQL Server with BitLocker

I have an application that is running on a device that has two partitions: C and D. The application runs off of C while D contains the SQL Server database (mdf file). In addition, D is also encrypted ...
0
votes
1answer
1k views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
0
votes
1answer
104 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 ...
1
vote
1answer
47 views

Accessing impact of deleting ibtmp1 file in MYSQL

There is a file called ibtmp1 and it is consuming 138 GB. I understand, this stores uncompressed data. Do we really need these files or can we delete it? if deleting is fine, then could you please ...
1
vote
1answer
204 views

Unable to get any type of connection using mysql on LAN

My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the ...
0
votes
1answer
141 views

How to get mysql automatically running when I start tomcat apache on Windows?

When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
2
votes
1answer
793 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 ...
7
votes
3answers
5k views

ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)

I am receiving this error in a development database. It happens on some specific queries (simple inserts and deletes via .NET application). The database is used by one user, and error happens ...
1
vote
1answer
61 views

How can I check the path of my.ini, through the command line?

I would like to know, if possible, how to display (using the command line) the path to my.ini used by the server. I am using MySQL 5.6 inside a windows IIS. I have the following: Program ...
1
vote
2answers
2k views

MySQL Database and Table Loss

I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
1
vote
5answers
308 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
0
votes
1answer
402 views

How to restore data after MySQL Upgrade?

I upgraded from MySQL 5.5 to 5.6 by uninstalling 5.5 and then installing MySQL 5.6. Now that MySQL 5.6 is running, none of my DBs or data is present/visible in MySQL Workbench. I also see that I ...
0
votes
1answer
5k views

ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express

I am using Oracle Database 11g Express Edition. I'm on Windows 7-64Bit I get this error when trying to access the database: ORA-01033: ORACLE initialization or shutdown in progress I set up the ...
1
vote
2answers
20 views

MySQL server feature gap on Windows and Linux

Is there any gap or difference in features of MySQL Server on Windows and Linux? Feature refers to below aspects: common DBMS functionalities such as Stored Procedures, Updateable Views, ...
1
vote
0answers
49 views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
0
votes
1answer
38 views

should I give dbo permissions to NT AUTHORITY\NETWORK SERVICE?

We're in the process of assessing a new application that will require access to our MSSQL database I've set up a user that is a member of a role only giving it readonly access to certain views in the ...
1
vote
1answer
17k views

Trying to install SQL Server 2008 Management Studio Express

On a Wndows Server 2008 R2 64 bits, I installed Visual Studio 2010 Express, which installed a SQL Server 2008 Express: Trying to install a SQL Server Management Studio, first I'm required to ...
1
vote
0answers
57 views

Configure Oracle database (first time user)

I am trying to learn how to use Oracle Database. I downloaded the Standard Edition version 12c from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html. I ...
0
votes
0answers
31 views

PostgreSQL 9.5 - Implications of setting dynamic_shared_memory_type to none

I'm using pg_upgrade to upgrade some databases from version 9.0 to 9.5 on Windows. I've noticed that running two 9.5 clusters on different ports on the same machine is not possible when ...
14
votes
2answers
15k views

“Access is denied” when connecting SSMS to Integration Services

I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name: Connecting to Integration Services service on the ...
3
votes
0answers
9 views

PostgreSQL crash when connection failed [duplicate]

Error log is : 016-02-21 21:22:34 GET DETAIL: Connection matched pg_hba.conf line 83: "host all all ::1/128 md5" .... .... 2016-02-21 21:22:37 GET DETAIL: ...
0
votes
0answers
107 views

PostgreSQL crash when connection failed

Error log is: 016-02-21 21:22:34 GET DETAIL: Connection matched pg_hba.conf line 83: "host all all ::1/128 md5" .... .... 2016-02-21 21:22:37 GET DETAIL: ...
0
votes
1answer
15 views

Prostrct create causes windows batch file to exit

I have a daily job to restore a database from last night's back up before doing other things to it and moving on. I'm trying to automate this with a script, but when I get to the following command the ...
1
vote
1answer
175 views

MySQL 5.6 Server start fails: InnoDB Operating system error number 23

I use a local MySQL 5.6 Server (InnoDB) on a Windows 7 machine to store several schemas of a research project. Until yesterday the system ran without problems. During a query, MySQL Workbench ...
0
votes
2answers
1k views

Does HP Vertica run on Windows and is it compatible with our existing Oracle SQL?

I am new to HP Vertica. I read the installation documentation for HP Vertica, but it seems to be totally unix focused. Can we install HP Vertica under Windows? Additionally, will we need to update ...
0
votes
0answers
273 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 ...
1
vote
2answers
273 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] ...
-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
111 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 ...
2
votes
1answer
223 views

MySQL Create Table with Partition Slow on server machine

Following create table statement with Partition runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz ...
3
votes
1answer
184 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 ...
2
votes
2answers
7k views

SQL Server is started but didn't listen on any port

I newly installed SQL Server 2012. No database created yet. And I can open the Management Studio with sa/password. The Binn\sqlservr.exe is started as a service and I can see it started in the service ...
1
vote
2answers
3k views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
0
votes
0answers
35 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 ...
5
votes
2answers
665 views

My HD crashed and I can't start MySQL

I am on Windows 8, my SSD got corrupted and I installed Windows on a new drive. I had before MySQL 5.6.12, now I installed 5.6.17 and tried to move the entire data dir. The location of the MySQL ...
1
vote
2answers
146 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
1
vote
3answers
544 views

MySQL 5.7 - Where is the mysql_secret file on Windows 7?

I've just installed a copy of MySQL 5.7 for testing, and I love the fact that it now only creates a single root account, and puts the password into a file called .mysql_secret. There's just one ...
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 ...