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

Alligning Two data sets - one data set has duplicates

How can I align two data sets so that one data set spaces out to match the other. For Example I have two Data Sets: DATA SET A DATASET B Individual ID Household ID ...
1
vote
0answers
872 views

The LDAP Server is unwilling to perform (53)

I know the problem is not new, but I'm trying to get this server work at least one week. The steps I did. Install OpenLDAP Importing all ldif (It was working). ls /etc/ldap/schema/*.ldif | xargs -...
1
vote
3answers
69 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
2
votes
1answer
2k views

Connecting to host OS database from guest OS VirtualBox virtual machine

I’m using Pentaho BI server in a CentOS VirtualBox machine, and now I want to connect it to an SQL Server database that I am running in my Windows host OS (localhost). Is there a simple way to do ...
0
votes
2answers
1k views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
0
votes
1answer
37 views

cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1 formula i use is ""IF(B19=B3,D3,0)+IF(B19=B4,D4,0)+IF(B19=B5,D5,0)+IF(B19=B6,D6,0)+IF(B19=B7,D7,0)+IF(B19=B8,D8,0)+IF(B19=B9,...
0
votes
1answer
69 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
0answers
1k views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried repairing/checking/...
1
vote
1answer
431 views

Inserting Crackstation's Wordlist into a database table

I'm trying to insert Crackstation's 1.5 billion wordlist (15gig) into a database table. I've tried SQLite and Postgres both with no luck so far via the command line. Both get upset that the data ...
0
votes
1answer
36 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...
-1
votes
2answers
131 views

The “smart” way to crawl the web [closed]

I have a project in which I have to crawl the web for lyrics, I am implementing depth-first search and I am making a database in a list (which contains nested lists which will later be saved in a file)...
-1
votes
1answer
218 views

I want to install and configure MySQL Server silently with remote access

How NSIS MySql Silent install and configure to enable remote machine access. **ExecWait "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=root ...
12
votes
2answers
417 views

Can a file system's logical structure (including symlink targets) be represented in a single lightweight file (non-binary)?

After playing with multiple SQL and NoSQL databases over the years I feel the best way for me to ensure portability in my personal apps that are data-centric is to avoid all bonafide databases ...
0
votes
1answer
891 views

phpMyAdmin used by java application

I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is ...
0
votes
0answers
23 views

Hide a Database in a .jpg picture [duplicate]

Is there any way to put a database in a picture with a command prompt only (like copy /b 1.db+2.jpg 3.jpg) but keep the Database and the Image intact? I dont want to use any software. I want put my ...
0
votes
0answers
252 views

Dumping an SQLite database stored as dll file?

A little background first: I need to extract a database from an SQLite dll file for my client who has burned bridges with the previous dev. I have these 4 files sitting on my desktop: System.data....
1
vote
1answer
109 views

Host a database server with a different hosting company [closed]

I am hosting my app and database in Linode. I want to scale it by having a separate database server, but I reckon I don't need to pay $10/month for another VPS with Linode for the database server. I ...
0
votes
2answers
47 views

Data modelling, calculation and visualization tools?

I often need to make decisions based on various kinds of data and their calculation results/visualizations respectively. For simple, tabular data I usually make Excel spreadsheets, however most of the ...
0
votes
4answers
227 views

Read an SQL database to control a light bulb

I have an idea for a game room score board. I would like to turn a light bulb on or off depending on a flag in a database. So let's say I have a column called "out". For out=1, one bulb would be lit, ...
0
votes
2answers
588 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. =COUNTIF(K:K,"Busy")+...
3
votes
1answer
66 views

Index files and folders in windows

I want to create a database of all files and folders within a specific location (say, E:\movies). How can I do this? Is there any software which can do this for me? Otherwise do I need to write code ...
1
vote
1answer
134 views

Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail ...
1
vote
0answers
193 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
3
votes
1answer
950 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
0
votes
0answers
1k views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
-2
votes
1answer
181 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
0
votes
0answers
19 views

Extending an formula over multiple cells

I want to set up an excel table where: A:A is my 1st data table B:B is my result table C:C is my "Column" table D:D is my "Row" table E:E is my 2nd data table I want the result of the function to ...
0
votes
1answer
734 views

Photo Organizer that works from many computers to one file server

I have a file server in the closet. It runs Ubuntu, and exports my photo library as NFS4 and SMB. I have children and a wife who all also want access to these photos. Right now, the archive has the ...
-1
votes
1answer
183 views

Are Intel i7 core mobile processors decent enough for software development? [closed]

I'm reaching out because I'm in the market for a new laptop, and I would like something light that I can take with me for a job interview or meet clients, so I can demonstrate my source code and ...
0
votes
0answers
108 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
3
votes
1answer
71 views

SFTP transfer a file from server to desktop

I am trying to compete an assignment for school and I have one final step. I have use the "put" command to load the file. Then ran a spool and the file followed by ending the spool. Now I am back at ...
1
vote
0answers
58 views

Database-based word document

I will take an example, it'll be easier: So I have a database about classrooms. There is student db which contains all the students like so: id name surname slug class 0 John ...
3
votes
3answers
825 views

How to split one row in Excel into multiple rows for database management

I have a set of data that is currently 39,000 rows and 27 columns. The first column is the ID number. The subsequent columns correspond to elections, with the date of the election in row 1 (cells B1-...
0
votes
0answers
23 views

Are there any NULL bytes in an MS Access database?

Mercurial diffs files only if it is "not binary", where "binary" is defined as "contains a NULL byte". Do databases in MS Access (.mdb) contain null bytes?
0
votes
0answers
124 views

Auto-Fill Textfields in PDF from external sites?

So I've got an editable PDF with 2 text fields. Name and EMail. The PDF is locally as in on my current PC. The database is remote, and has 2 fields called "Name" and "EMail". However it is not a ...
0
votes
2answers
159 views

Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...
0
votes
1answer
469 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
3
votes
1answer
256 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
-1
votes
1answer
462 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
2answers
3k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

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
1answer
1k 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
1answer
60 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
571 views

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS won'...
0
votes
3answers
3k views

I'd like to create a database of pictures. Where to begin? [closed]

I'd like to create a searchable database of images. I'd like something a little expandable, meaning I'd like to define my own fields and be able to search on them, but I'd also like to be able to ...
0
votes
1answer
7k views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
-4
votes
2answers
4k views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
2answers
863 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
110 views

Pull Couchbase database over ssh from remote server

I am working on a Debian environment and I have to pull a Couchbase database from a remote server location into my local Dev environment. I wasn't able to find any kind of details on this topic so ...
1
vote
2answers
300 views

Is there such thing as a portable database that runs easily OsX and Windows?

I need to make a small database for a project at school (not computer related at all, I'm indexing and categorizing paper documents of a research projet). The thing is that in september, my semester ...
0
votes
0answers
1k views

Use Excel to query Sybase database

Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query. How do I do this? I have the following: Query ...