0
votes
0answers
7 views

Toad for Mysql gives error on Compare

I've posted this message on Toad World looking for help but no one has answered. So I'm trying here. I repeatedly get the same error while using any of the Compare options when connecting to a ...
-1
votes
0answers
3 views

cannot get 2014 cluster to start up

I am trying to get node 1 of a new 2014 FCI to start up. I just did the first node install and at the end of the install it says it can't start up the cluster. I thought about the CNO and VCO and ...
0
votes
2answers
19 views

How to get the second string in the ORA-02296 error to show something meaningful

Whenever I run the following script*: ALTER TABLE ANIMAL.MONKEY MODIFY TAIL_COUNT NOT NULL; I receive the following error: ORA-02296: cannot enable (ANIMAL.) - null values found I have a ...
4
votes
1answer
126 views

How do I choose the right job owner?

This morning I had three failed jobs (no biggy) used for custom reporting DOMAIN\USER is no longer with the company. Error Message The job failed. Unable to determine if the owner ...
3
votes
2answers
86 views

check when last backup was taken

Brent Ozar had an interesing newsletter on 2015-06-22; How do you manage dbas measuring backups, where he thinks that a good DBA should check when the last backup was done it was last restored ...
0
votes
0answers
13 views

Interest in your database with administrative units [closed]

I am a student and I am interested in your dataset that you developed which identifies different administrative units for countries. Is this something that you'd be willing to share with me? If not, ...
0
votes
0answers
11 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 ...
3
votes
2answers
23 views

How do I connect to mysql without having to type an empty password?

I just installed MySQL, and by default the root user has no password. If I connect with this command: mysql --port=3307 --host=127.0.0.1 -uroot -p It asks me to enter a password, I just hit return, ...
0
votes
0answers
15 views

unsigned right shift '>>>' Operator in sql server [closed]

How to write unsigned right shift operator in sql server? The expression is like value >>> 0 Here is the e.g. -5381>>>0 = 4294961915
2
votes
1answer
31 views

Search and compare list of ever-growing IPs

I'm a newbie when it comes to mysql things and queries in general, just wanted to point that out. I'll keep this as short as I can. I have a table where I track the IPs of users that enter the ...
0
votes
0answers
22 views

http vs sql queries [migrated]

i have big problem deciding what approach to take, i have many pages on my site that uses tabs. for example a page with 5 tabs (horizontal tabs). now every tab takes data from different table in the ...
0
votes
0answers
8 views

Amazon RDS Read Replica

I would like to know, is the Read Replica is nothing but the slave server, where only reads are there. I created two mysql instances in amazon RDS, one is Read Master, and another is Read Replica. ...
3
votes
1answer
5 views

How to remove a corrupted shard in MongoDB

I use MongoDB 3.0.3 with Wired Tiger engine on Cent OS 6.4. I have a sharded cluster of 4 shards each of which has about a quarter of total data. One of the shard called "shard2" corrupted and ...
0
votes
1answer
24 views

how to set default value of column 0 when NULL is inseerted

I have a table with a column which has default value to 0. However when null is inserted to this table, I want it to set it to default. As the insert query is generic and used by other databases too, ...
0
votes
0answers
33 views

How can I write a query to aggregate multiple strings into one field? [migrated]

I am trying to merge three tables. The first table has id and data_name, second table data_id, option_id and property, third table user_id, data_id. For example: first table +----+-----------+ | ...
1
vote
0answers
18 views

Creating a unique index on a materialized view with no unique columns?

I am using Postgres 9.4. I have created a materialized view from one of my tables and I want to be able to refresh it concurrently. I know from the documentation that in order to do a concurrent ...
0
votes
1answer
22 views

How to convert timestamp to string in Pentaho Kettle?

I have a timestamp field in my input table like this: yyyy-mm-dd hh24:mm:dd, I want output sting like this: yyyymmdd.
0
votes
0answers
12 views

Connecting to oracle 11g through maestro gives initialization error

I'm very new to oracle DB. When trying to connect to oracle through maestro, this error comes up: Initialization error SQL*Net not properly installed OracleHomeKey OracleHomeDir Dont have any ...
2
votes
0answers
24 views

Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?

My environment is the following: VMWare 5.5 vitalized server MS Windows Server 2008R2 Enterprise domain and SQL Server 2008 R2 Enterprise. Centralized storage with fibre-channel connection. I have ...
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 : ...
1
vote
1answer
17 views

Select Distinct on subset of columns, name different set of columns to return

I am using PostgreSQL and have two tables: Table_A colA | colB | colC | colD | colE | colF | colG | colH | colI | colJ Table_B colA | colB | colC | columnD | colE | columnF | colG | colH | colI | ...
2
votes
2answers
87 views

Conceptual ERD Multi-table many to many, or possibly recursive?

I'm creating a conceptual diagram [yes, I know I've included attributes and keys - but this is just for me to consolidate what I'm doing whilst learning] -- so please treat it as Conceptual with the ...
0
votes
0answers
17 views

How to create multiple mariaDB mysql instance in CentOS 7?

How to create multiple mariaDB mysql instance in CentOS 7? I have already installed first mariaDB mysql instance in CentOS 7. I've been searching for documentations on how to configure a Multi-Master ...
0
votes
0answers
24 views

Partitioning existing table in Oracle

(Oracle) I'm trying to do an exchange partition on an empty partitioned table to fill it with data from a non-partitioned table. I'm getting the following error and can't find the cause. I'm not 100% ...
0
votes
1answer
13 views

How to use PostgreSQL bit_or function to aggregate column?

I wish to use PostgreSQL's bit_or function on several rows of a single column of my table, but I can't figure out the proper usage for this. Suppose I have bitwise flags in my column flags, and the ...
-2
votes
0answers
25 views

Keep connections alive when disconnected from network

In SQL Server, is it possible to keep a connection alive if the end user was disconnected from the network? Specific situation: If I am working with SSMS and create a temp table - is there a way to ...
-3
votes
0answers
27 views

Create database in SQL Server 2014 [closed]

I have installed SQL Server 2014 on my laptop and I have not created new databases in SQL Server 2014 yet. Before creating a database, should I first create a private key and a certificate? If so, ...
0
votes
1answer
27 views

BCP - Different Schema

I have a transactional Replication (Non-SQL Server Publishers - Oracle) implemented for one SQL Server Database. Let's say Publishers: A, B Subscriber: C Note: I can not modify the Oracle DBs. The ...
4
votes
0answers
61 views

Which to trust?

We are troubleshooting a long-running issue with a vendor. Their software has a tendency to freeze up and stop working once or twice a week causing major disruptions to our operation. They have been ...
0
votes
0answers
13 views

SSMS SQL Server 2014 - Selecting BackupSets for a Restore takes a long time

I'm having an issue with SSMS SQL Server 2014 (before and after SP1). When I go and select 'restore database' from the server and select a database, it just sits there and spin and spins. More than ...
0
votes
1answer
23 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
0
votes
1answer
15 views

Replicate a database to one secondary replica, but not the other secondary replica using Availability Group

I have a 3 nodes cluster in an availability group. There are two databases on the primary node. One database I want to replicate to the 2 secondary nodes. Another database I just want to replicate ...
0
votes
0answers
3 views

Part of query is not properly performing in access design view(2010)?

So, I have been trying to figure out why this query is not running in the design view properly. I am trying to create a list of IDs of individuals who have an invoice(Gift table) between 1/1/2014, but ...
1
vote
1answer
16 views

should I change mysql platform for higher innodb_buffer_pool_size?

Currently Im running a 160G MySQL database on Xampp (Windows). But Xampp has upper limit for innodb buffer pool size of 4G. My computer has 16G RAM. So if I want to make full use of resources, should ...
0
votes
0answers
21 views

PL/SQL Triggers [migrated]

I am using these tables: flights (flno, origin, destination, distance, departs, arrives, price) aircraft (aid, aname, crusingrange) employees (eid, ename, salary) certified (eid,aid) and I need ...
0
votes
1answer
22 views

SQL Server : multiple databases with transaction log on one SSD array

I know for HDD arrays that having multiple log files from different databases has a performance hit as it changes the IO pattern from sequential to random for the array. So having an array per ...
0
votes
1answer
27 views

Use PL/pgSQL in PostgreSQL outside of a stored procedure or function?

I'd really like to use an IF, ELSE construct and execute multiple statements within the IF and ELSE blocks, but I don't wish to save my commands to the database as a stored procedure or function. Can ...
0
votes
1answer
25 views

how to make secondary slave as readable in MongoDB?

How do I make a secondary slave as readable in MongoDB? We can do this via shell command rs.slaveOk() But how we can do it permanently for all session via config file?
0
votes
2answers
43 views

What is the privilege for account unlock in Oracle [on hold]

I want to understand the privileges better, but I'm not able to find some useful info using Google. I thought that I needed ALTER USER privilege to be able to unlock user and change password. But ...
-5
votes
1answer
25 views

How to copy my SQL Server 2008 database [closed]

In my SQL Server 2008 copy database option is not present. Can you help me to copy the database?
1
vote
1answer
24 views

Add a new collation to a Postgres database

I have these collations: postgres=# select * from pg_collation; collname | collnamespace | collowner | collencoding | collcollate | collctype ...
2
votes
0answers
35 views

How to verify replication data integrity in SQL Server when using external replication engine

I am looking for a way to verify that data I am replicating between SQL Server databases is making it to the destination OK. Data is being replicated using an external replication engine, no built-in ...
0
votes
3answers
32 views

Merge replication throws PRIMARY KEY violation during the initialization of Subscriber

I am using SQL Server 2014 SP1 to set up merge replication on Windows 2008. The databases (Publisher & Subscriber) are restored from the production back up of SQL Server 2005 publisher database. ...
0
votes
0answers
9 views

mysql 5.5 statement based to rds mysql mixed replication

I am moving to rds mysql 5.6 that has by default mixed replication. I am moving from 5.5 where I have statement based replication. I was wondering if i enable replication between them i.e make rds ...
0
votes
1answer
34 views

Adding columns & index to a huge table

I'm working with a Rails app backed by a MySQL database. One of the more-frequently used models is backed by a table with over 200,000,000 rows (and growing). We've been aware for a while that the way ...
1
vote
0answers
10 views

Report Builder Data Sources Do Not Change in Catalog Table

I am trying to extract the connection string for MS SSRS reports from the Report Server Catalog table. This is straightforward enough but if I change the Data Source in Report Builder, the change is ...
0
votes
0answers
12 views

I am installing postgres-xl. While initializing the coordinator, i am getting the error below [closed]

loading PL/pgSQL server-side language ... FATAL: could not open extension control file "/usr/local/share/postgresql/extension/plpgsql.control": No such file or directory STATEMENT: CREATE ...
1
vote
1answer
32 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' ...
2
votes
1answer
35 views

`chown -R` equivalent for PostgreSQL

We occasionally have the problem that, when upgrading some software and database, inexperienced (or overworked, not excluding myself) sysadmins (we don’t have separate DBAs except for Oracle) run the ...
-3
votes
0answers
67 views

How to recover a database? [closed]

I have a dead database. I looked at the backups but the last backup was made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the ...

15 30 50 per page