A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

learn more… | top users | synonyms (2)

0
votes
0answers
4 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
2
votes
1answer
19 views

CentOS - Trying to backup/restore a MySQL database?

My CentOS 6 server got a server issue, so customer support took a backup of my server and reinstalled it. The backup is in a folder called /home/42406. I'm trying to find my MySQL database called ...
0
votes
1answer
24 views

Merging two *.db files with same tables into one *.db file

I would like to combine two mysql database files (*.db) into a single database. Both databases have the same tables. Is there an easy way to do this?
1
vote
0answers
16 views

PostgreSQL and database cluster ownership on shared storage

For my research, I am using an always on virtual machine for the primary analysis of my data. In doing this I need (or, I suppose, would like to) create and store the data in a PostgreSQL database. ...
0
votes
0answers
11 views

Data transfer in sql server 2008

I have following requirement In SQL server 2008,Trying to implement in stored procedure source table T with 100000 records need to be insert into destination table T1.A Job will be schedule for ...
0
votes
0answers
38 views

Upload data in .txt file to SQL database through ftp in command line

I have a table in .txt file with header, and an empty table Final_Beta_Table with header only in SQL database. It's a NETEZZA database and there are many other tables in it. How can I upload the .txt ...
0
votes
1answer
22 views

How do I resolve data range failure from Excel?

When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring? I think that the error has something to do with removing connections because ...
1
vote
1answer
35 views

How to calculate number of possible records in Redis per 32GB of memory?

In my company are talking about the possibility to build some part of our backend in Redis instead of mongodb but we want to calculate how many records we will be able to store in a server with 32G. ...
0
votes
1answer
7 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
0
votes
0answers
5 views

How do I open tox.db for clients for the secure Tox network?

I made an issue in one of the Githubs for Tox, but I don't know whether the developers have time to deal with it. https://github.com/notsecure/uTox/issues/1091 There's this file called tox.db that ...
0
votes
1answer
13 views

Search views in multiple MS SQL databases for use of Order BY and record which view uses it

In the process of migrating over some old databases to new servers, we know that some views in some databases might be using an ORDER BY, but we're unsure which / where. We'd like to record which ...
1
vote
1answer
42 views
+50

To edit commandline Anki flashcards in MySQL

I need to make a small change in 77777 Anki flashcards, preferentially programmatically, not by using their replace tool which is not sufficient. I imported data originally there as CSV files where ...
0
votes
1answer
20 views

If I have a data entry field in a SQL Server table, can I index it efficiently?

I've got a backend SQL Server database. It's my understanding that clustered indexes are most efficient, but that they physically order pages to make it efficient. So, if it's a user-entered field, ...
0
votes
0answers
39 views

Why does Windows Server Backup save as .VHD file?

On our Mail server we are running Exchange 2010. We have four databases. One of the database is called Regional. I decided to take a backup of this Regional database using Windows Server Backup and ...
0
votes
1answer
20 views

How to put a multi-lines text in a database from the command line?

I have emails exports in full text (one file per email). I want to put them in a database from a shell script (bash or python). Let's say I have created a database with a emails table, and from, to, ...
0
votes
1answer
72 views

Connect mysql database to Ms Access directly

I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want ...
1
vote
2answers
50 views

Find out database type from files

How can I find out database type in order to examine data when all I have is the database. By database I mean the database folder under program root folder with bunch of files around database.db file? ...
0
votes
0answers
22 views

Configuring a centralized rsyslog server with MySQL database, gathering events from multiple servers

I'm trying to configure my rsyslog server to collect logs from many servers and write them to a local database. The problem is, the server writes the data to the DB as local (host, ip, etc) I'm ...
0
votes
0answers
19 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
1
vote
1answer
91 views

How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?

I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results. I've installed Sql Server Express 2014 and have verified that ...
0
votes
1answer
51 views

Monthly Pivot Tables In an Annual Report

I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple. The thing is ...
0
votes
1answer
65 views

Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade. The CourseGrade column can contain any of the following ...
0
votes
0answers
23 views

Advanced Query Filtering in Access 2010

I am using Access 2010 to log prospective students for a school program. Once these students apply, they need to have a school ID generated (or if they are a current or former student, simply looked ...
0
votes
1answer
24 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
0
votes
0answers
39 views

URLField in django models allowing users to submit blank records, why?

This is what my models.py file looks like: from django.db import models class accounts(models.Model): url = models.URLField(max_length=200, blank=False) The database is still allowing blank ...
0
votes
0answers
22 views

asp connection to asphostportal mysql database

I'm trying to connect via asp to a asphostportal mysql database on their server. I've created the database and added a users table. I have an opensource intranet (UAPortal) that is really ...
0
votes
0answers
44 views

Where does the Lazarus Chrome extension store its database?

Lazarus' website is down, so I can't look this up. Where in Linux should I look to find its SQLite database of saved forms?
0
votes
0answers
15 views

What diagnostics are available for a General Protection Fault from an old Windows program?

I have run an old (1996) Windows program that accesses DBF files. If I run with an old copy of the database it works fine. But if I run with my current copy of the database, I get the GP Fault when ...
1
vote
2answers
89 views

Query for false values in Access not working

I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in. What I want to do is ...
4
votes
3answers
162 views

How do I force an application to recognise two names for a disk drive?

I have an extensive image database (3.25GB metadata, 90K images) held in a legacy product (idImager V5). This in turn utilises SQL Server 2005 as the underlying DBMS. Over time, I have been adding ...
2
votes
1answer
74 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
1
vote
0answers
14 views

Mongoose: Failed to connect to IPC Port. [closed]

Failed to connect to IPC Port. Mongoose installed without issue. But I get this error when I attempt to actually use Mongoose.
0
votes
0answers
9 views

Carbox Database Software Keyword Error

Having an issue with keywords not taking effect in the Cardbox Database software. It is happening in several different records - the last 30 and a few random ones in between. It isn't registering ...
0
votes
1answer
19 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
0answers
27 views

OSX: mysqladmin create database: connect to server at 'localhost' failed

I'm trying to create database in mySQL on OSX using the command line: $ mysqladmin create database Getting: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user ...
0
votes
0answers
50 views

Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram

In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner. When we use that find operation, we receive a list view of results that ...
0
votes
0answers
20 views

Password issue for Access db in SAP BI

It is little bit complicated system so let me do it in points: We have SQL server 2005 database that is accessed by multiple programs. We have Access 2013 database that works as front end for ...
1
vote
0answers
34 views

Is there a way to let PostgreSQL restore but not create a new timeline

I'm using PostgreSQL 8.4 and am creating a standby server. Since PostgreSQL 8.4 doesn't have built-in replication support, I did the following things try to get read only access to the standby server, ...
1
vote
2answers
625 views

Excel: How to connect to a sqlserver localDB

I have created a LocalDB that I can work with in MS sqlserver management studio 2014, linqpad, and visual studio 2013. Here is the part of the "connection property" dialog in SSMS which shows the ...
0
votes
0answers
13 views

Apollo message broker integrity check?

We're currently using Apollo message broker 1.6 on Linux and one thing we noticed is that if for any reason the broker service doesn't shutdown properly (machine crash, daemon killed, etc) there's a ...
0
votes
2answers
59 views

Lotus Notes, Tabs, & Reference Database

A colleague is experiencing a problem with Lotus Notes on her computer that I (first line of tech support) cannot replicate and also cannot find a solution to. My department has 30+ people in it, we ...
0
votes
0answers
45 views

Receiving authentication failed error while running sonar with Mysql

Receiving authentication failed error while running sonar (3.7.3) with Mysql.I am able to run sonar using h2 database of the same.So i dont believe it's due to the wrong user name and password. And ...
0
votes
0answers
26 views

boost application process in ubuntu

Are there other ways to boost an application process in Ubuntu other than "nice"? I want to backup a database without using import and export method and just use push and pull method instead. I tried ...
0
votes
0answers
79 views

Exception in WCF service while reading Data from Database using ID

I have got exception on live server. pl. let us know, why we have got error so many time Exception in Repository.DTTransaction.Get(). TransactionId: 26397149Exception : ...
-1
votes
1answer
70 views

Automated Visio Database Model Diagrams

Is it possible to automatically create a Visio database model diagram from a edge list or some sort of source/target file? I am looking to automatically create some sort of data flow diagram in Visio ...
-2
votes
1answer
904 views

OSX: Snort: ERROR: /etc/snort/../rules/local.rules(0) Unable to open rules file “/etc/snort/../rules/local.rules”: No such file or directory

I'm trying to setup and run Snort IDS on mac using this kinda tutorial: https://discussions.apple.com/thread/3370709?start=0&tstart=0 OSX Yosemite (10.10.2); PostgreSQL 9.4.1 (installed with ...
-1
votes
1answer
310 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 ...
0
votes
1answer
31 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
0answers
238 views

How to convert a FoxPro database without spending $$$ [closed]

Got an old piece of software that I need to pull the database out of, so it can be easily moved to some new software. Based on the information I have found so far, I believe it is a FoxPro database ...
-1
votes
1answer
61 views

.mdb file completely corrupt after the frequent recoveries

I am running Access database and one of .mdb files was corrupted for a long time. I got an error messages repeatedly, unfortunately I don’t remember exactly which ones. I let it go because I was still ...