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)

2
votes
1answer
17k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
0
votes
1answer
13 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
21 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: ...
2
votes
1answer
5k views

In Visio 2010, how can I create a mandatory, non-identifying relationship between two database tables

I'm working in MS Visio 2010. This is the relevant part of my ERD: The relationship between Event and Adventure is correct: there's a foreign key from Event to Adventure, and that FK is part of ...
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
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.
0
votes
2answers
4k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
8
votes
3answers
11k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
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
29 views

What data storage solution to choose HDD vs SSD vs Pendrive for an event storage? [on hold]

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 ...
2
votes
4answers
5k views

Program to view and edit fixed width text files?

I'm looking for a program that can view and edit text files that contain data in a fixed width format. The files contain no carriage returns. I've tried viewing them in excel but the import process ...
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 ...
2
votes
1answer
72 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
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 ...
1
vote
1answer
1k views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
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?
0
votes
2answers
231 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I've googled it, but this appears to be already the shortest way from the first page on Google. ...
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
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 ...
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 ...
10
votes
3answers
10k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
5
votes
4answers
6k views

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. ...
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 ...
1
vote
1answer
134 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
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 ...
0
votes
0answers
8 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 ...
1
vote
1answer
45 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. ...
3
votes
4answers
801 views

Is there a GUI interface for sqlite? [closed]

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
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
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
488 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
0
votes
1answer
112 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 ...
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
37 views

How do I create a new database?

Since upgrading to Yosemite 10.10.1, I can't create a new database set theOutputFolder to choose folder with prompt "Please select an output folder:" tell application "Database Events" make new ...
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. ...
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
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
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 ...
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 ...
13
votes
4answers
16k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
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
0answers
70 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 ...
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. ...