Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
0
votes
0answers
23 views
Performance of large queries on low bandwidth connections
I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
1answer
75 views
Converting dbo file from windows to linux
I have a .dbo file which is created from windows. This file is succesfully reloaded into the mysql database in windows. I need to reload the dbo file into the mysql/mariadb database in linux. How I ...
0
votes
0answers
16 views
mysqlnd: same mysql server and php version, can't connect from Windows
(This question is also in StackOverflow http://stackoverflow.com/questions/16575994/mysqlnd-same-mysql-server-and-php-version-cant-connect-from-windows)
I'm migrating mysql functions to mysqli. As ...
2
votes
1answer
60 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
0
votes
1answer
74 views
Creating the MySQL slow query log file
What do I need to do to generate the slow logs file in MySQL?
I did:
log_slow_queries = C:\Program Files\MySQL\MySQL Server 5.1\mysql-slow.log
long_query_time = 1
What more do I need to do ...
0
votes
0answers
17 views
Authenticate Oracle Database with Active Directory Users [duplicate]
I'm trying to connect to Oracle Database 11gR2 with the users from Active Directory. I'm looking at some resources/guidance on how to go about doing this successfully.
The link Map Oracle Roles to ...
1
vote
1answer
35 views
Restrict access for Windows administrator in PostgreSQL
Is there a way to protect PostgreSQL from user with Windows administrator rights?
Like this question but for Postgres.
1
vote
1answer
36 views
Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
Having a corrupted Mysql 5.5.31 (Windows) database, my question relates to the the top solution provided in How do you identify InnoDB table corruption? , more precisely to the following script that ...
3
votes
2answers
210 views
Problems connecting to Windows-based Postgresql
Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course.
In my pg_hba.conf I have:
#office subnets
host all ...
2
votes
2answers
62 views
Changing PostgreSQL port using command line
My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7).
I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port
...
-1
votes
1answer
75 views
Windows Server 2008 R2, Active Directory, and Oracle Database Server
I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server
I Want to know how to make the configuration of the following Diagram in this link:
...
1
vote
1answer
55 views
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working
I'm trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command:
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so'
but this command is ...
0
votes
2answers
47 views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
1
vote
1answer
22 views
Oracle Express intermittently stops responding, requiring a OS reboot to fix
I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out.
There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
1
vote
1answer
69 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
37 views
I can't install db-mysql in node.js
When I execute this command: npm install db-mysql, I get the following result. What's the solution to this problem?
C:\Users\Mouad>npm install db-mysql
npm http GET https: ...
1
vote
1answer
402 views
Binlog has bad magic number
I keep getting this error whenever I start MySQL.
121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled.
121028 1:38:55 InnoDB: The InnoDB memory heap is disabled
121028 1:38:55 InnoDB: Mutexes and ...
1
vote
2answers
249 views
Passing path from batch file to mysql
My batch file will contain some thing like this :
set MUSER=root
set MPASS=xprd123
set MHOST=172.33.49.55
set DB=DBName1
set MBIN=C:\Program Files\MySQL\MySQL Server 5.5\bin
...
5
votes
0answers
212 views
Migrating MySQL to new server
We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B).
We have a new MySQL 5.5 instance on ...
1
vote
1answer
57 views
Trying to allocate 3G for buffer pool in InnoDB fails
I'm trying to boost my InnoDB driver on my Windows 7 PC since each page request takes just about 1.7 seconds to load versus 0.002 seconds on my Ubuntu 12.10 workstation.
The setting I'm playing ...
4
votes
3answers
62 views
STARTUP command fails : Why is that?
I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different !
These are the ...
5
votes
1answer
291 views
How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I installed Oracle 11G on my Windows 2008 R2 Server. I also installed Oracle Client Libraries using separate installation media. After the client installation, when I try to log into the database ...
3
votes
4answers
245 views
Stress Test to Saturate Memory for MySQL InnoDB
I'm investigating windows 32bit memory problems (the 2G limit) and am after a test which will max out MySQL's memory including InnoDB Buffer Pool, per connection memory and/or any other uses of ...
1
vote
2answers
100 views
Performance Counters for SQL Server Related to iSCSI Disk Access
I am planning to my SQL server databases (plus TLogs and TempDB) to a new LUN on our iSCSI SAN. The current LUN's used by these of these files are on their own two disk RAID 1 disk group and I'm ...
5
votes
2answers
4k views
PostgreSQL: The database cluster initialization failed
Both C:\PostgreSQL and C:\PostgreSQL\data have postgres user with full access and admin rights.
I ran postgresql-9.1.2-1-windows.exe from postgres user as admin. Target C:\PostgreSQL
Every way I ...
0
votes
0answers
140 views
Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
0
votes
1answer
993 views
MySQL Installation error: Unable to update security settings
I tried to configure MySQL server 5.5 on Windows and this is what I get
mysql-server-5.5-winx64:56 - Attempting to update security settings.
mysql-server-5.5-winx64:100 - Unable to update security ...
0
votes
1answer
67 views
Logging and saving user activity
Database:Oracle 11gR2
OS: Windows 2008 Server R2
I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes.
I need to automatize user ...
1
vote
2answers
95 views
How do I add a database in IBM DB2
I'm supposed to migrate a MySQL database into IBM DB2, but I thought I'd take baby steps first before I do something like that. So for now, I'd just like to add a database.
I'll admit that I have no ...
0
votes
1answer
160 views
How to copy MySQL Database from Linux to Windows?
I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
3
votes
1answer
81 views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
2
votes
1answer
197 views
FLUSH TABLES stays in the processlist even after execution
Here is my code from Stored Procedures in Mysql
FLUSH TABLES;
TRUNCATE TABLE tbl_cdrload;
TRUNCATE TABLE tbl_cdrdetails_temp;
Then i execute a query to load a file in to database as below
LOAD ...
2
votes
2answers
4k views
How to start Oracle database's listener service after a change in the IP address?
I'm using Windows XP as my Oracle database server. Today there was a change in the IP address if the database server.
I want start my database instance's listener again. Windows XP prompst that:
...
1
vote
2answers
960 views
Mysql Can't create test file + 1067 Error
I have installed mysql-5.5.30-win32. All works fine until i create my own my.ini configuration file. When I am trying to start the service using CMD (I do run the cmd as administrator, and install the ...
1
vote
1answer
288 views
Can I install sql server on Win XP machine with user profile on D drive?
Is it possible to install sql server on a windows xp machine where the user profiles are created on a non system root directory, that is, on D drive rather than C drive?
I am trying to install SQL ...
2
votes
1answer
74 views
How does MySQL resolve schema information?
I’ve used MySQL on windows7.
Recently my machine was infected by a virus.
After that SHOW TABLES and SHOW DATABASES statements don’t show any tables and databases but I can see data from tables ...
1
vote
1answer
82 views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
2
votes
1answer
163 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
2
votes
2answers
195 views
Minimum/Maximum Server Memory in SQL Server 2005 with /3GB and /Userva switches
I have a 32-Bit Windows 2003 machine with 3.75GB RAM running one SQL Server 2005 instance. I am trying to optimize memory. If I use the switches in boot.ini like below,
/3GB /Userva=2490
should I ...
2
votes
2answers
422 views
Large files in wamp\bin\mysql\mysql5.5.24\data directory
I have discovered these files located in the wamp\bin\mysql\mysql5.5.24\data folder on my Windows 2008 server.
They are consuming about 22 GB on a 40 GB drive.
I am using a LMS called moodle, that ...
6
votes
3answers
3k views
Installing default MySQL Tables in Windows (mysql_install_db)
In Linux, the default MySQL grant tables can be created with the mysql_install_db script, but that does not work on Windows.
How can the default grant tables be installed on Windows?
(No, I’m not ...
9
votes
1answer
125 views
What platform for a large record based mathematical database?
Hi I am a civil engineer with some experience of programming but I am not familiar with the vast range of options available today. Hope you could give me any pointers the best way to proceed.
I want ...
2
votes
1answer
346 views
PostgreSQL 9 'pgstats wait timeout' problem
I'm asking about this here because in the PostgreSQL mailing lists no one answered me.
In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the ...
4
votes
1answer
217 views
Continuing failovers on production server
At least a few times a day, my main production server has recently begun failing over. Only, the quorum doesn't move to the other node.
I ran the validation report, and got a lot of info I don't ...
1
vote
1answer
92 views
Correct Selection of SQL server instance db owner login name
I am attempting to connect RSA Archer (5.2) to an instance of SQL server 2008 r2 on WS 2008 R2.
When Archer attempts it's initial connection I get -
The ConnectString property has not been ...
0
votes
1answer
170 views
MongoDB Master and Slave Replication - Windows or Linux
I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
2
votes
1answer
257 views
Remove sql server service from windows 7
I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
3
votes
2answers
6k 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 ...
0
votes
1answer
59 views
MySQL installation and data location on Windows
I'm gonna install MySQL 5.5 in a virtual Windows Server. I'd like to have the data in an separate partition (it may be in a different virtual disk) than the system one. I'm considering two options:
...
1
vote
2answers
2k views
How is localhost resolved by Oracle listener?
When I o an Oracle test installation on a Windows server accepting mostly the defaults, I end up with a listener.ora like
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = ...
