The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
1answer
611 views

How many tables will be there in Magento 1.8 [closed]

I just started using Magento with 1500 products and I saw the DB size is about 150MB and when I looked at the tables, the count is 250 tables. Is it normal? Should I worry about anything? I host ...
0
votes
1answer
93 views

PHP SQLite Admin is running on PHP 5.4

I tried phpsqliteadmin But it doesn't seem to work anymore on PHP 5.4. There are several alternatives, but none of them seems to be "The One" that is maintained and widely used. Is there a standard ...
0
votes
1answer
412 views

MySQL slave database wont start

I have a MySQL master slave configuration and the slave is not working anymore. When trying to stop and start again the slave db, I am getting this error: 140530 14:21:23 [Warning] Slave I/O: ...
0
votes
1answer
109 views

What is the strategy of query evaluation in DBMS when Limit is used in query?

I have following tables in database post(post_id , user_id , post_text , parsed_text) ; Comment(comment_id , post_id , user_id , comment_text) ; friend(id , user_id , friend_id ) ; group (id , ...
0
votes
1answer
274 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
0
votes
3answers
206 views

Large RAM use after import database - ubuntu server

My new VPS has 4GB of RAM. Before importing database system use about 1.2 GB of RAM. When I import into the database, using 250 MB SQL file, 25000 tables use of RAM goes to 97%, htop showing 3302 mb ...
0
votes
1answer
326 views

Pentaho 4.4 Database connectivity issue

I am getting the following in one of my transformations. I am trying to extract data from SQL server and pushing to mongodb. 2014/04/03 13:11:10 - EMPLOYEE TABLE Input.0 - linenr 700000 2014/04/03 ...
0
votes
1answer
307 views

How should I config the my.ini(or my.cnf) file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU ...
0
votes
1answer
358 views

how many 'text' column a table could have in mysql? I have this error “Row size too large (> 8126).”

I'm working on a application which is kinda complex to explain how it works. But this is the situation I'm in, ------------------------------------------------------------------------------ FIELD1 ...
0
votes
1answer
513 views

What is a bucket in database? [closed]

I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example? Thanks!
0
votes
1answer
424 views

Which MongoDB administration UIs offer a table view (OS X)?

The only admin UI we found that offers a table view is MongoVue, which is only available on Windows. We're on Macs with OS X. Do any exist?
0
votes
1answer
68 views

Database Designing Issue

I have a database having Millions of records in three tables. Now i want to split these three tables in multiple tables to reduce redundancy and data duplication. A lot of records(Persons) have ...
0
votes
3answers
105 views

Applying data changes from one database to another

I have an application running on Oracle 9i database and I was looking for something more practical to deploy data changes (not schema changes) from the development database to production. Currently I ...
0
votes
1answer
211 views

can't connect to postgresql with md5 [closed]

I can connect to db with trust, but it is not letting me to connect with md5. It says : "password authentication failed for user "postgres"" Here what I have in pg_hba.config host all all ...
0
votes
1answer
180 views

Which index types do not support online index rebuilds?

In SQL Server 2012 Enterprise Ed., which index types do not support online index rebuilds? and why? and which activity-operations can prevent online index rebuilds?
0
votes
2answers
617 views

SQL Server 2012. Update second table based on input from first table

I have two tables in two databases: Table01 in Database01 and Table02 in Database02. Both tables have a column called UserID. The UserID column is created when the user creates a new account on the ...
0
votes
1answer
5k views

Oracle 11g increasing shared pool size and java pool size

i need to install/configure oracle jvm on 11g. to be able to install same i need to increase the size of shared_pool_size and java_pool_size. i have automatic memory management enabled. my ...
0
votes
1answer
797 views

Oracle Character set identification

In the given export(Normal Export) log file i see following: Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set Is this multi-byte or single byte database char-set. Can you ...
0
votes
2answers
8k views

SQL Server Management Studio - connection with SQL Server database engine

This question is in regards with SQL server 2005 and 2012. I have a database server with two instances of SQL Server. Through SQL server management studio I was able to connect to both instances by ...
0
votes
1answer
5k views

How to copy backup files to remote share in SQL Server Agent job without AD/domain accounts involvement?

MS SQL Server 2012... with nightly databases backups to the same/local as SQL Server machine... I am trying to add another SQL Server Agent Job to copy the .bak files to remote (non-windows, i.e. ...
0
votes
1answer
175 views

Does failed task considered to be run to completion in SQL Server maintenance plan terminology?

The replies to my previous question: "How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?" answered me that I should change ...
0
votes
1answer
2k views

DB2 9.7 LUW - How do I SET SESSION_USER when I am DBADM,SECADM?

Based on a previous question I have asked, I am attempting to work on a solution as recommended by mustaccio's answer, whereby I have another ID to create my DDL objects. I have been trying to follow ...
0
votes
1answer
1k views

How do you get the graph plugin for Squirrel SQL?

I installed Squirrel SQL and the website claims the Graph plugin is part of the install. It is not available nor is it in the jar. How do I get the graph plugin?
0
votes
1answer
503 views

How to revoke DBADM and clean up any related objects from DB2 LUW

This question has started because of us taking copies of production backups and restoring them into lower environments (with scrambled data of course) for developers to practice and/or debug against. ...
0
votes
1answer
435 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
0
votes
1answer
368 views

Security Concerns of SQL Server Express for Web e-Voting web application

I am building a database driven web application. The web application is basically an E-Voting website, where users can register and vote on things that concern their community ... etc. The database ...
0
votes
1answer
3k views

Plugin 'FEDERATED' is disabled

Im trying to start Mysql using easyPHP : the response is an alert window to a log file. The main error is <-- Plugin 'FEDERATED' is disabled -->. Through my research on internet i found that the ...
0
votes
1answer
335 views

replication breaks after upgrading master

I have a set up of replication with master 5.1.30 and slave 5.5.16 and the replication is working good Now i have upgraded mysql master to 5.1.47 As far as i know we have to turn off the log bin ...
0
votes
2answers
3k views

Secure Linked Server - Non privledged user possible? Registry corruption?

Is it possible to use a non privledged Windows domain account to impersonate itself in a linked server? And why would it be unable to read the registry for available network protocols? Overview: ...
0
votes
2answers
2k views

Unable to change engine to MyISAM in MySQL

I have installed MySQL 5.6.10 on Mac OS X 10.6.5. My issue is that MySQL is using InnoDB as its default engine. I have checked following engines are supported in MySQL: show engines\G ...
0
votes
1answer
2k views

mysql fine tuning: open_tables, opened_tables

I'm a novice to database administration and have been depending on forum suggestions and answers to help resolve my database hang ups and too many connections errors; I've managed to reduce the ...
0
votes
1answer
1k views

TSQL query for viewing start/end of all SQL Agent jobs yesterday

See this related query: What's a good tool for visualizing SQL Agent jobs? I'm not after a visual tool however, since I am looking to build my own visualisation. This is my starting point, but ...
0
votes
1answer
103 views

Is Index Used for This Query

If so, which one? How do we know? I have 3 indexes in a query. Actually only the first 2 should be useful { "v": NumberInt(1), "key": { "LongitudeLatitude": "2d", "Prominent"▼: ...
0
votes
1answer
3k views

What is going wrong with postgresql initdb? Why is the `UTF-8` encoding not getting enforced?

I am using PostgreSQL 9.1. Trying to enforce UTF8 encoding as default. This is what I am doing. service postgresql initdb -E 'UTF-8' \ --lc-collate='en_US.UTF-8' \ ...
0
votes
1answer
545 views

Unable to restore database in Oracle 10g

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message. ...
0
votes
1answer
467 views

What are commonly used database types? [closed]

There are a lot of database types. Can you list a list of the top classification of databases commonly found in schools and offices? Any help is appreciated. Hope to see compressed and summarized type ...
0
votes
2answers
32 views

Merge MySQL tables without data repetition

My situation is this: I have several DIFFERENT tables in my MySQL database with the same name columns. Such tables can contain (or not) the same data. What I need to do is a kind of "merge" between ...
0
votes
1answer
28 views

How can I delete all users except 1 [on hold]

How can I delete all users except 1 in mysql database in phpmyadmin.(it's a joomla 1.5 website database)
0
votes
0answers
40 views

DBA vs DB Engineer vs DB Programmer [closed]

What are the specific differences between a Database Administrator, Database Engineer, and a Database Programmer. I'm trying to determine which title is truly most fitting for my day to day duties, ...
0
votes
0answers
6 views

IBM Data stage compiler error

I have installed InfoSphere Datastage 9.1.2 on Windows Server 2008 R2, and also installed C++, but when I try to compile a job show error in transform stage.
0
votes
0answers
30 views

What is wrong with my ERD?

I am trying to create a reservation/booking ERD. Is their anything wrong with my current ERD? It must show a supertype and subtype, and it must identify attributes for regular, weak, and associative ...
0
votes
0answers
43 views

Is there a way to check which views have data? Oracle 11g

I'm undergoing a cleanup process for a data mart design. However, I want to get rid of any views (in the design) which result in having 1 or less rows of data. Instead of manually going through ...
0
votes
0answers
43 views

DB_STARTUP blocking on spid 7

I have a sql server 2012 instance that I'm installing a new license on that had previously had an evaluation license. I've did this on two other servers with out incident, but this server is giving me ...
0
votes
1answer
18 views

Unable to configure oracle 11g net server

I installed Oracle 11g on my Windows Server 2008 workstation. After I try to configure oracle net server with port number 1521. But ONS error say to me as "Use another port number. This port is ...
0
votes
0answers
30 views

Best method to implement HA and DR, replication via 1 PUB and 2 SUB or replication and LS both

I need a advise on one of our projects where: We have 3 SQL database servers A, B and C: A is the live production server with around 200 users with a database of size 1.5 TB hosted. B is going to ...
0
votes
0answers
41 views

Moving Database SQL Server 2012 to 2008/R2 [duplicate]

I'm planning to move a Large Database from SQL Server 2012 to 2008/R2. I tried the scripting thing, it works on a small-medium type of database but not on Large database w/c is about a hundred MB. Any ...
0
votes
1answer
13 views

Putting some calculations on a database entry from phpmyadmin

I am creating an online store website for sale/purchase. I have to put a specific percentage of an amount (User enters) in database. for example If user enters 100. I have to deduct 30% of it and I ...
0
votes
2answers
44 views

How to build a table for a private messaging system that supports replies?

I'm writing a private messaging web application in PHP, the application allows replies such that when you view a message, you also get to see to what was that a reply to, and to what was that a reply ...
0
votes
5answers
55 views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
0
votes
0answers
29 views

How do I create an after Trigger in sql for a price reduction?

So im trying to do this for a personal project of mine just as a hobby kind of thing. What i need help with is that im not sure how to put a SQL After trigger for something i want to try. What i have ...