0
votes
2answers
45 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 ...
1
vote
0answers
24 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 ...
0
votes
0answers
122 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 ...
2
votes
1answer
727 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 ...
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
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, ...
1
vote
1answer
404 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.
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 ...