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

learn more… | top users | synonyms

4
votes
2answers
174 views

ProcessID Owner with third party app

I am having problems trying to audit a third party app with a SQLServer backend. The app manages users and user access via a SQL table, using a single SQL login to access the databases. I am trying ...
0
votes
1answer
13 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
0answers
12 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
134 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 ...
13
votes
2answers
4k views

How to do incremental backup every hour in Postgres?

Trying to do an hourly incremental backup of a single Postgres server (Win7 64). I have the following setup in postgresql.conf: max_wal_senders = 2 wal_level = archive archive_mode = on ...
1
vote
1answer
33 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' ...
0
votes
1answer
11 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 : ...
0
votes
0answers
549 views

How to detect when ORA-00604 occurred?

Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of some ...
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 ...
1
vote
2answers
271 views

mysqldump with automatically generated export name

When I do database dumps through MySQL WorkBench it picks a filename for me which is the current date (YYYMMDD). Now, I want to do this in a batch file since I want to make weekly dumps automatically ...
0
votes
1answer
626 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 ...
3
votes
1answer
25 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
25 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
2k 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
2answers
29 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, ...
0
votes
0answers
23 views

MySQL server installation file download for windows

I need to install latest MySQL community server 5.6.25 in windows box. MySQL site is giving complete MySQL installer, but not particular MySQL server installation file. Where can I get this ...
2
votes
1answer
183 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 ...
0
votes
1answer
235 views

Toad 9.7.2 for Oracle hangs on Windows 7

I am using Toad 9.7.2 on Windows 7 64 bit. It is generally working fine but there is one problem. When I click on certain tables in "Schema Browser" and then click on "Data" tab to see records in ...
0
votes
1answer
2k 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 ...
6
votes
1answer
127 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 ...
2
votes
2answers
958 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 ...
0
votes
1answer
369 views

How to install Slony for 64-bit PostgreSQL 9.3 on Windows?

I have installed 64-bit version of PostgreSQL 9.3.5 from EnterpriseDB installer. Now I want to install Slony-I through Application Stack Builder, but it offers only 32-bit version of Slony, ...
1
vote
2answers
2k views

MySql InnoDB tables are missing after restarting

I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
0
votes
2answers
118 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
52 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 : ...
1
vote
1answer
681 views

Upgrading using pg_upgrade on windows fails

When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about pg_upgrade, the following command fails: RUNAS /USER:postgres "CMD.EXE" ...
8
votes
1answer
36k views

How do I reset the postgres password for PostgreSQL on Windows?

I have installed PostgreSQL on my Windows machine for development. Now I haven't used it for a while, and have forgotten the password for user postgres (default admin user in PostgreSQL). How can I ...
1
vote
1answer
26 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: ...
0
votes
1answer
125 views

ODBC Data Source Administrator: Driver name is an empty string

Below you will see a screen shot of a warning in Windows 7. Why would I get this error when opening up "Data Sources (ODBC)"? How can I resolve it? If you can give me some tips on where to start ...
2
votes
1answer
24k views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
0
votes
1answer
4k views

Error: Unable to write inside TEMP environment variable path

I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, rather famous it seems, error: There has been an error. Unable to write inside TEMP ...
5
votes
1answer
1k views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
2answers
748 views

How do I use an Ispell dictionary with Postgres text search?

Postgres can use Ispell-compatible dictionaries in text search, but does not provide the required files.
1
vote
4answers
2k views

MySQL SSL disabled on Windows

I want to enable an SSL connection to my database. I've created SSL certificates and so on, however SSL remains disabled: mysql> show variables like '%ssl%'; ...
0
votes
2answers
71 views

SQL storage sizing - How to get statistics of what data is being accessed

How can I monitor which data is being accessed and which frequency? I'm in need to migrate several (very) small SQL Server instances, each which several small databases. Current configuration is ...
0
votes
0answers
33 views

Cant Import mysql system DB from another server

Both Servers are the same in hardware, OS, and MySQL versions (5.6.11). One server has MySQL on it and on the other one I just setup a fresh instance. I want to import all of the data to the second ...
1
vote
1answer
169 views

MySQL Install on Windows 8.1 hangs at server restart

I have a 64-bit Windows 8.1 machine and would like to install a local database to host some helper application databases. I have attempted this several times with this version of MySQL (5.6.25 GA) but ...
3
votes
1answer
119 views

Sharing PostgreSQL database on one dual-boot machine without duplication (cross-platform)

I have PostgreSQL 9.4 installed on a dual-boot machine (both on Win 7 and Ubuntu 14.10). The two systems share a drive (NTFS-formated) which includes a PSQL database directory which was created under ...
0
votes
1answer
43 views

Is the Advanced Security Pack required for windows authenticaion?

Can anyone tell me if the Oracle Advanced Security Pack is required for single sign in under Windows? I've been told we are not licensed for the "Oracle Advanced Security Pack" and need to remove it, ...
13
votes
2answers
10k 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 ...
5
votes
2answers
4k views

How to disable starting MySQL service on Windows7 startup?

When I turn on my desktop (Windows 7 SP1), I often find 2 or 3 GB of memory is already occupied by MySQL processes. I don't care about how much memory a database requires, if it actually runs some ...
0
votes
1answer
60 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
0answers
272 views

How to restore mysql database in XAMPP using backup of mysql folder?

I have a backup of the entire xampp/mysql folder. How can I use it to recover my old db on a fresh installation of XAMPP? Simply copying the old xampp/mysql folder to new xampp leads to mysql errors ...
0
votes
1answer
62 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
0
votes
0answers
29 views

Getting SSL Working

So, I'm trying to configure PostgreSQL to allow SSL connections, on a Windows box. First, per http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html I added this line to pg_hba.conf (and ...
-1
votes
1answer
45 views

Server has antivirus. Do I need to enable external locking on MySQL?

From MySQL docs: If you only read tables with other programs, external locking is not required Assuming the bytes of MySQL files does not match viruses, the antivirus will not change the ...
-2
votes
1answer
68 views

any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server [closed]

i am planning to decide to use mysql5.6 on a window server 2012 or a linux server. Can someone gives me some general advises between the two?
0
votes
1answer
541 views

Oracle 11g XE 64bits installation problem on Windows 7

I had to install Oracle 11g XE on my laptop under Windows 7. So I follow this Tutorial. The installation didn't even fail once, and seem to be OK. But every time i tried to connect to it with SQLPLUS, ...
0
votes
1answer
46 views

Moving two databases from MySQL 5.1 [Prod] to MySQL 5.6 [Stage], not working [Windows]

I'm in the process of upgrading our production MySQL from 5.1 to 5.6, on a Windows Server 2008 R2 server. What I'm trying to achieve is to move 2 databases [say abc and xyz] from Prod server to a ...
0
votes
1answer
147 views

How do the Oracle DB instance and the local listener communicate?

It seems this my other question needs some background: Basically, on Windows, how do the Oracle DB instance process and the listener process communicate? Do they use TCP? Is the configuration of this ...