Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
0
votes
2answers
13 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
0answers
13 views
How to run different MySQL-statements with parameters in a loop using Powershell 2.0?
I am new to Powershell and would like to do the following in a shell script:
1.) read some filenames out of an file with filenames
2.) execute some SQL-statements for each file read
Here's my code:
...
0
votes
1answer
21 views
In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?
In SQL*Plus, I try to run a script that is stored at a certain URL.
From where I am currently, I can http(s) connect with the internet only via a proxy.
So, if in SQL*Plus, I try
...
1
vote
0answers
48 views
Unable to install postgresql 9.3 on windows 8.1
I have been trying, without success, to get posgresql 9.3 up and running on Windows 8.1 on and off over the last ten days. Here is what I have done so far:
I got the windows installer from ...
0
votes
1answer
36 views
Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON
I'm trying to change the SYS password of an Oracle 11g database to be case-insensitive for legacy application reasons. My research suggests all I need to do is set the SEC_CASE_SENSITIVE_LOGON flag, ...
0
votes
1answer
29 views
Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine
I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
1
vote
1answer
26 views
How to grant rights for a user in DB2 Express?
I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database.
I have ...
0
votes
0answers
30 views
PostgreSQL Install Error
When I install the server for the first time, when almost finished it reports:
(from log file "%temp%\bitlock_installer1376.txt")
Loading additional SQL modules...
Executing cscript //NoLogo ...
2
votes
1answer
41 views
Does Windows Server File Compression slow Oracle DB performance?
I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure.
I can ...
0
votes
0answers
80 views
High availability PostgreSQL 9.3 server on Windows
I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
0
votes
1answer
127 views
Postgres 8.3 faster than 9.3?
Our software product currently ships on Windows 7 with Postgres 8.3 as its database. On a busy site, there may be 24 automated systems generating 100 rows (x100 columns) per minute, with 3-10 human ...
1
vote
2answers
53 views
Why does MySQL + Windows Server = crashed tables periodically?
Windows Server 2008 R2 x64
MySQL Server 5.6.14 x64
Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
0
votes
0answers
46 views
SQL Server Replication do not replicate DELETE statement
We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc.
From A to B we have ...
1
vote
1answer
38 views
Poor query performance in MySQL
I have a 10 million record table in a MySQL 5.5 InnoDB. It's running in a 16GB RAM server with good CPU and fast HD. When I run the following query
SELECT DISTINCT knowledge_id,
...
0
votes
1answer
30 views
MySQL connection timeout error retrieving big results
All of the sudden our MySQL 5.6 server (on Windows server) started to give us this error: "Lost connection to server during query".
We never had this problem before and we haven't touch MySQL config ...
1
vote
2answers
24 views
How to automatically grant permissions to application created databases in SQL Server 2008 R2?
So I have an application that automatically creates a new database after the database it is currently in reaches a fixed number of rows. I need to be able to automatically assign a user within the ...
0
votes
2answers
58 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
1answer
79 views
How do you setup a new oracle instance from the commandline after having done a database software only install?
I'm trying to familiarise myself with the process for setting up new instances/databases from the commandline with the aim of building a tool for deploying databases.
The process we are thinking of ...
1
vote
2answers
96 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
75 views
I can't get an import to go past 1.1gig
I can't get an import to go past 1.1gig. I have a large 4gig InnoDB table/database I would like to get on my "tried and true" box.
Current config on this box I want to work with =
Dell PowerEdge ...
0
votes
1answer
26 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 ...
0
votes
1answer
89 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
1answer
101 views
MySQLdump on specific db date
I'm new in here and i don't really know where to start but here is my concern. I need to backyp a MySQL DB running under windows once a week. For e.g every friday i need to backup and transfer to ...
1
vote
1answer
37 views
db2 connecting to a db via alias and storing user name and password
I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
1
vote
1answer
104 views
Problem setting MSDTC on client computer
I created an application that is making use of MSDTC (to open a transaction on multiple databases within the same MS SQL server), our local environment was setup successfully and both DTCPing, ...
1
vote
0answers
48 views
Oracle: How to find non-local (background) processes in Windows Machine
Following link advises to find non-local background processes and kill them using following bash script.
Solution 1) : without shutdown anything just kill that database
processes which are not ...
2
votes
2answers
2k views
MySQL creates temporary tables on disk. How do I stop it?
We are running a site (Moodle) that the users currently find slow. I think I have tracked down the problem to MySQL creating temporary tables on disk. I watch the variable created_tmp_disk_tables in ...
0
votes
1answer
62 views
Are databases only growing in size?
Databases use the file system to store the data.
As far as I know it is not possible to delete a record from a random access file.
So does that mean that when we do a DELETE FROM TABLE the size of the ...
0
votes
1answer
117 views
oracle XE on windows XP stopped working
I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs.
Actually it's been working fine for a couple of years, but today ...
0
votes
1answer
143 views
How to auto start instance of sql server 2012 localdb on startup?
How do you auto start instance of sql server 2012 localdb on startup?
1
vote
1answer
162 views
mysql 5.1 — unknown variable 'basedir=c:/mysql/'
I recently changed the default port(3306) to another for mysql.
I did it by changing the my.ini file and did restart of the server.
No other changes were made whatsoever.
When connecting using a GUI ...
2
votes
1answer
88 views
Need to understand output of sqlcmd.exe
I was advised to make another question, from here - http://stackoverflow.com/questions/19674045/need-help-to-make-sqlcmd-run-as-per-requirements
My sqlcmd.exe is invoked with a command of the form -
...
-1
votes
2answers
105 views
HP Vertica, can we install it on Windows & the SQL we use for oracle is same for the HP Vertica?
I am new to HP Vertica. I read the installation documentation for the HP Vertica.
The documentation is totally based on the *ix environment. So, my question is Can we install HP Vertica on Windows ...
0
votes
2answers
722 views
Is it viable to attribute permissions to SQL Server virtual accounts (NT Service\SQLSERVERAgent, etc)?
Using MS SQL Server 2012 in Microsoft Windows Server 2008.
I am somewhat confused by the New Account Types Available with Windows 7 and Windows Server 2008 R2 virtual Windows accounts [NT ...
0
votes
0answers
29 views
Converting MySQL 5.6.10 - 32 bit to 64 bit version
I am currently using MySQL DB Version 5.6.10 for 32 bit running in 64 bit Window OS.I want to change it to 64 bit without taking any dump..Can anyone help in this?
0
votes
2answers
866 views
Environment Varible PATH exceeding recommended length solution?
I am attempting to install Oracle Database 11g on a Windows 7 64x laptop.
I get all the way to step 5 of 8 and I get a fail on Environment variable path "exceeds recommended length"...
I have ...
4
votes
2answers
227 views
Restrict range of dynamic ports available to SQL Server
Is there a way to limit the range of dynamic ports available to SQL Server from the database side, or database server side? Our SOP is to use static ports across the network firewall and a vendor is ...
0
votes
1answer
861 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 ...
0
votes
1answer
198 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
0answers
32 views
Retrieving Column comments using MySQL ODBC driver
I am using the following function call to retrieve the REMARKS of a column of my MySQL table.
SQLBindCol(st_handle,12, SQL_C_WCHAR,comment,512-1, &l);
But comment is always an empty string.All ...
-8
votes
3answers
472 views
Wrong Last Modified Date of .ndf file on SQL Server [closed]
I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups with files on different disks just for indexes. I have created new index today in a ...
0
votes
0answers
182 views
Create a high availability cluster configuration PostgreSQL for Windows
I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
-1
votes
1answer
120 views
Restoring Oracle XE database
I had Oracle 10G XE installed on my Windows machine. The machine got corrupted and I will have to install Oracle again. I did not take a backup in the form of SQL queries.
How can I use the old ...
3
votes
1answer
3k views
Cannot open table mysql/innodb_index_stats
After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well.
The errors I ...
0
votes
1answer
109 views
Restoring old MySQL database settings
I know this question may be similar to some others posted but think it may be slightly different, so hopefully it's ok.
Basically I just reinstalled Windows as I bought a new HD and I am in the ...
2
votes
1answer
1k views
SP2-0750: You may need to set ORACLE_HOME
I am getting following error message when i write sqlplus on command prompt
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Here are the path details
0
votes
1answer
80 views
Windows Service Management Node Won't Start
I'm trying to set up a basic Cluster on my Win7 PC for testing. But I am stuck at the first hurdle. I have installed the Management Node as a Service:
...
7
votes
2answers
1k views
How to do incremental/differential backup every hour in Postgres 9.1?
Trying to do an hourly hot incremental backup of a single postgres server.
I have the following setup in postgresql.conf:
max_wal_senders=2
wal_level=archive
archive_mode=on
archive_command='copy ...
0
votes
0answers
167 views
MySQL multi master replication with bi-directional synchronization advice
I need a solution to replicate data between multiple MySQL masters running on different platforms (Windows XP, 7 and Ubuntu Linux).
I have found a replication tool (SymmetricDS) which supports this ...
8
votes
1answer
631 views
On which machine should TCP Chimney Offload be disabled?
I am advising someone on how to disable TCP Chimney Offload, which is enabled by default by Windows Server 2003 SP2. We are working in an environment with multiple server machines, namely the ...
