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
20 views

Should I go for Hadoop?

I hope discussing scenarios and solutions isn't out of context, if it is then please suggest. Details: Windows server 2012 R2 with IIS and MS SQL standard edition, using C# in the front end with Ajax ...
0
votes
1answer
16 views

How to export mysql large database from remote server using only phpmyadmin access?

My client give me phpmyadmin access to do database related task. I am stuck to export the database because database size is very large. Client give me credential like followings: ...
0
votes
0answers
11 views

Script from Exchange Management Shell to give data from two servers

I work for a company that has two offices, one in the UK and one in Africa. We also have two Exchange mail servers that replicate each other over the network. The UK Exchange server replicates its' ...
0
votes
0answers
9 views

why am I getting an error with postgres and kerberos?

I am trying to install a web app that requires a postgres database, with a user and a password. Whenever I try to connect to the database, I get the following error: Cannot connect to database mydb: ...
0
votes
1answer
12 views

Unable to delete objects in an Access 2010 database

I converted a database from Access 2003 into Access 2010 by opening the .mdb file in Access 2010 and saving it as an .accdb file. I am now unable to delete any of the forms, queries, etc in this ...
0
votes
0answers
10 views

I have an exel speadsheet and im looking to add a value meaning to each column [closed]

for example, column headed 'flue' will mean we charge £200 for the flue when the column is ticked. I'd like the entire row to add up in a 'gross charged' column and have a '£' value.
-1
votes
0answers
22 views

Database on less than 128MB memory [closed]

I'll buy a small device with a 0.8GHz Kirkwood CPU and 128MB RAM. It can run Linux Arch. I need a database on it (a real database with authorization, socket connection, which is running as a daemon, ...
0
votes
0answers
9 views

Merging two sqlite3 databases into one database file

I would like to combine two sqlite3 database files (*.db) into a single database. Both databases have the same tables. Is there any easy way to do this?
0
votes
1answer
10 views

How to move postgresql database from one computer to another?

I've been created an Internet service on Debian server. I want to move all data from one server to a new one. So, how can I move the postresql database? What is the best pipeline?
0
votes
1answer
27 views

What data storage solution to choose HDD vs SSD vs Pendrive for an event storage?

I intend to buy a PogoPlug for a small server. I want to install Debian or Arch on it and I will use it for sharing and backing up photos between computers and as a HTTP server or/and event storages ...
0
votes
0answers
2 views

Is there a way to get links on URLs in a column in phpmyadmin?

In my personal database, I have one column which contains only URLs with scheme (e.g. http://...). For something else which cannot be automated, I need to quickly have a look at all these pages. I'm ...
0
votes
0answers
7 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
30 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
56 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
22 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
12 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
59 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
24 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
44 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
7 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
14 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 ...
2
votes
1answer
70 views

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
21 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
44 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
22 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
110 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
54 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
25 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
24 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
132 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
61 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
75 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
28 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
26 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
69 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
26 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
54 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
130 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
76 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
16 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
22 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
28 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
63 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
25 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
38 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, ...
2
votes
2answers
881 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 ...