The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
3k views

How Do I Investigate a CPU Usage Spike Without Being Present?

I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...
2
votes
1answer
717 views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
2
votes
1answer
2k views

Grant MySQL user ability to create databases, and only allow them to access those databases

Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
2
votes
1answer
762 views

Access H2 Database from Outside of the App

I have an embedded H2 database running for a web-app that I am working on. The programmer who built the app has gone and I am faced with learning the system and figuring out a way to look into this ...
1
vote
3answers
1k views

What is default admin for SQLite?

Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?
1
vote
4answers
141 views

Editing an SQL Database

I'm new to php, so I installed xampp for windows. Is there a windows software for easy MySQL administration? (creating/displaying/editing tables + data, creating relations ..) i've managed to open ...
1
vote
1answer
196 views

MongoDB Command Line Tool

Is it possible to enter arbitrary command in MongoVUE and get result? If there is not such feature do you know any other windows app that can be used as mongo front-end console?
1
vote
2answers
1k views

Collaborative use of bibtex as an online database (JabRef)?

I am thinking about a collaborative effort, where several people would need to insert data; for different reasons, it would be most convenient that this data is in bibtex format (the references format ...
1
vote
0answers
23 views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
1
vote
1answer
403 views

How to migrate a database from MyISAM to InnoDB?

I am migrating a database with MyISAM tables to an InnoDB engine. Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
1
vote
1answer
182 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
1
vote
1answer
345 views

How can I modify tables and forms in a MS Access database using UA Business Software 7.0?

I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0 The problem is that UA hides everything and everything is locked.. It doesn't even look ...
0
votes
1answer
37 views

Model for Cooperation in a class? [closed]

Assume you have six classes of students with low level of computer skills. They use Gmail inboxes to store old exam questions, notes and tips. Dropbox and Google Drive too, since Gmail inboxes get ...
0
votes
2answers
44 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
0
votes
1answer
2k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
0
votes
1answer
4k views

How to reset the postgres super user password on mac os x

I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it. All the directions I found ...
0
votes
0answers
13 views

TCP traffic normalization

BitSquatting is not new but it’s relatively new. This type of attack relies on a random bit that switches from 0 to 1 or from 1 to 0 inside a RAM. Because of this even though you try to access domain ...
0
votes
2answers
43 views

How do I connect to some local DB server in MS SQL Server 2012?

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
0answers
10 views

MSSQL administration tool without installation

I need a tool to have a look at mssql database and do some basic CRUD operations. To use it in every environment, it should be an installation-free EXE. Do you know such a tool? Before you ask: I ...
0
votes
1answer
91 views

How to start only one version of postgresql database, in this case 9.1?

I have installed postgresql 8.4 and 9.1 on same ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...
0
votes
0answers
119 views

Cannot copy-paste multiple rows in PgAdmin

I don't understand why this is not working. I have one instance of PgAdmin in which I administer multiple databases on multiple servers. I wanted to copy some rows of a table from one database on ...
0
votes
0answers
94 views

How to restore mysql databases from file disk

I used to have a few mysql databases on my system, but my operating system crashed and I cannot access the installed mysql service anymore. The only thing that I have is access to the database files ...
0
votes
0answers
28 views

What is “injection rate” with regard to DB software? How do I tell what it is set to?

I'm trying to set up a specific environment and I've come across a term that I'm not quite familiar with, and searching around has not yielded fruitful results. What does injection rate mean? Does ...
0
votes
1answer
182 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
0answers
53 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
0
votes
1answer
798 views

Mysql not starting with changed datadir

I was looking for a way to store my mysql databases on a different partition than the default installation. I found this link and followed the steps. However, after having changed the line datadir = ...
0
votes
1answer
124 views

Issue changing mysql password on Debian

I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
0
votes
1answer
45 views

Database Tool with good Interface for Reusing user-created Queries

I am looking for a tool that would help me easily reuse queries. What should it be like? You type a query like Select * FROM person where name LIKE ${name} And you would like to re-use this type of ...