The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
55 views

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
2
votes
1answer
4k 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
2k 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
3k 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
887 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 ...
2
votes
1answer
52 views

Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See

My computer has the following Software involved. Microsoft Windows 7 Microsoft SQL Server 2008 R2 Microsoft SQL Server Management Studio Moreover, I have the following Drive partitions: C: ...
1
vote
3answers
2k 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
1answer
229 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
4answers
143 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
293 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
1answer
456 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
188 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
402 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
39 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
202 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
3k 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
5k 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
4 views

Connecting remote H2 embedded database [migrated]

Is there a way to connect to an H2 database, which is running in automatic mixed mode (AUTO_SERVER=TRUE) inside a web application, from another machine over SSH tunnel?
0
votes
0answers
14 views

OBDC SQL connector for Windows Auditing Server to interface with Linux syslog server

I am working on a cross platform project here is the scenario: UNIX/Linux We have a Linux syslog server currently in place collecting syslogs from all network appliances and UNIX/Linux systems. ...
0
votes
0answers
7 views

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
0
votes
0answers
30 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
2answers
101 views

Adminer error (No PHP extension supported (SQLSRV, MSSQL) available

Adminer is a db management tool made in php (http://www.adminer.org/) I've installed it in Linux LAMP but I get the same error I've written in the Question Title. Did anybody solve this? How? I am ...
0
votes
0answers
41 views

How to update XML data using XQuery or XQuery with embedded SQL using FLWOR expression in IBM DB2?

Our professor instructed us to make a database table with a column with datatype XML and we populated data inside the table. We were told to perform an UPDATE or DELETE on the XML data on a database ...
0
votes
0answers
7 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
2answers
443 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
14 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
233 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
205 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
120 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
1answer
271 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
60 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
901 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
147 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 ...