The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
75 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
1answer
476 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
189 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
428 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
17 views

Can I set a random/different name to the PostgreSQL database for snort and metasploit etc?

I’m trying to learn PostgreSQL. Sorry, maybe this question sounds silly for advanced database users, but can I give the random name to databases (and users) for Snort and Matasploit instead of ...
0
votes
1answer
288 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
1answer
311 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
1answer
939 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
152 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
0answers
23 views

Strip non-numeric characters from a phone number in spreadsheet

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
0
votes
0answers
19 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
39 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
0answers
54 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
10 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
0answers
135 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
61 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 ...
-1
votes
0answers
26 views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...