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
2answers
148 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 ...
-1
votes
0answers
5 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 ...
0
votes
1answer
16 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
0answers
12 views

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

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could not connect to server: No such file or ...
0
votes
1answer
13 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 ...
-2
votes
0answers
12 views

How to return an Iter to 'n' selected objects from a std:map of 'm' objects (c++) [on hold]

I am using a STD::MAP in c++. typedef map< LONG_32, Dataobject > DataobjectMap; typedef map< LONG_32, DataObject >::iterator DataObjectMapIterator Now at times while writing various ...
-1
votes
0answers
18 views

Modify Excel data connection without disconnecting the connection file

When I link a data connection file to a workbook, and then edit the SQL query (to include dynamic parameters), Excel says: The connection in this workbook will no longer be identical to the ...
-1
votes
1answer
44 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 ...
0
votes
0answers
8 views

NoSQL key-value based schema for building a quick lookup hotel room reservation system [on hold]

I am building a hotel room reservation system which will expose 2 APIs to my clients - hasVacancy(...) and reserveRooms(...). I am thinking of using a NoSQL key-value datastore. The number of requests ...
1
vote
1answer
35 views

How to convert a FoxPro database without spending $$$ [on hold]

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 ...
0
votes
1answer
28 views

Performance comparison for older server [closed]

Given the falling price of older decommissioned server hardware, I am considering purchasing one to use for my research at home. I will be running Linux, PostgreSQL, Neo4j and R-Server on it. I ...
1
vote
2answers
45 views

Access database error: The module name xxx is misspelled or refers to a module that doesn't exist

We are using Access database 2003 (I know, too old) with Win server 2008 in my company. We have one .mdb file split into two. A couple of days ago we had a problem trying to open modules. It all ...
0
votes
0answers
22 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
17 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
votes
0answers
44 views

How to drop whole tables in a database using batch script ( Windows)

I would like to know how to drop the whole tables in mysql database using batch script. I've already searched on how to do this in linux and this is what i've found: mysqldump -u$User -p$Pass ...
0
votes
0answers
11 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 ...
7
votes
2answers
8k 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?
-1
votes
0answers
32 views

Poor MSSQL server performance on virtual machine after system upgrade

I'm managing middle sized company database. Recently we have massive system upgrade and switched to virtual machine environment. After deployment, we are having performance issues, Apparently MS SQL ...
0
votes
0answers
2k views

I'm trying to add a VPN through the network setting on OSX

I'm trying to add a VPN through the network setting on OSX. I have added the credentials through iOS on my iPhone, they check out and I'm then connected. I'm connecting to a PPTP. Example: Server ...
-3
votes
1answer
21 views

sql database errors 823. Can someone help me? [closed]

I have a question….How to fix sql database when generating an errors 823? Please help me to out this! Thanks
1
vote
3answers
52 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
21 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
3k 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 ...
1
vote
0answers
143 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 ...
3
votes
4answers
2k views

Can anyone suggest a program like OneNote, but with more database-like features? [closed]

I'm trying to use Microsoft Onenote 2010 to organise and create notes for a PhD and it has many advantages, but I'm finding the limitations of the format frustrating. For example, the functionality ...
17
votes
2answers
11k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
0
votes
1answer
102 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 ...
2
votes
1answer
4k 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

How to Create a VirtualBox like Oracle developer day VM using CentOs?

Oracle has provided us a way to use Oracle Database on Mac with its Developer day VM's. But its of huge size and I couldn't resume the download. So I want to build a VM with Oracle Database installed. ...
1
vote
1answer
69 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
0answers
9 views

How to backup and migrate only the user account data of one Gitlab server to another?

So we have 1 Gitlab server that we've outgrown so I am expanding to a second one for all new repositories but keeping the old one for existing repos. Our userbase is the same but I don't want to go ...
0
votes
0answers
31 views

Why is it not recommended to use zero in an ID column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...
0
votes
1answer
12 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 ...
2
votes
1answer
177 views

Do .frm files represent the entirety of a MySQL database?

So let's say I copy /var/lib/mysql and save it somewhere else, then uninstall/reinstall MySQL and put the original /var/lib/mysql back where it was. Will I have all of my databases without any ...
0
votes
0answers
16 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 ...
0
votes
1answer
1k views

Looking for Firebird GUI [closed]

I use phpMyAdmin to manage all of my MySQL databases and SQL Management Studio Express to manage my MS SQL databases. Now I need to start working with Firebird, and I'm looking for a tool along the ...
0
votes
0answers
25 views

what permissions are needed to run a jar file on a shared drive

I want to run an executable jar file from a workstation that accesses the file from a shared drive on a network server. The program accesses a local database on the server and if accessed directly on ...
0
votes
0answers
10 views

Copy SQL Server database with full transaction log

I have full SQL server transaction log on one server and one database (full recovery model) that I unfortunately don't have direct access to the database. Something in the software is filling up the ...
4
votes
5answers
7k views

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
13
votes
2answers
331 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
23 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
34 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 ...
-1
votes
1answer
79 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 ...
1
vote
1answer
207 views

Excel access.Vlookup? IF?

What I am looking to do, is to move stuff from one excel sheet to another sheet, in the same workbook. We will call the sheet with the data the "suppliers list" and the sheet where I want it to go, ...
0
votes
1answer
685 views

Excel macro to look up data from a database and copy it to another Excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows: You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
0
votes
0answers
7 views

SquirrelSQL does not display schema owned by another user (Postgres)

I've noticed that SquirrelSQL (v3.6) does not display schemas in a Postgres (v9.2) database if it is owned by another user, even if I'm connected to the database on superuser. When I do alter schema ...
1
vote
1answer
100 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
6
votes
3answers
8k 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 ...
0
votes
1answer
206 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 ...