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)

1
vote
1answer
19 views

Host a database server with a different hosting company [on hold]

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
18 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 ...
2
votes
1answer
140 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
0
votes
1answer
23 views

How to import an H2Database *.db database file into a WAMP server?

I made a database using H2Database, the database file is saved as *.db file in my documents, how to import that *.db file to WAMP server?
-2
votes
0answers
11 views

importing *.db database files to Wamp server? [duplicate]

i made a database using H2Database, the database file is saved as *.db file in my documents, how to import that *.db file to Wamp server ?
2
votes
1answer
12k 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 ...
2
votes
3answers
7k 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 ...
1
vote
0answers
20 views

Data model for services quotes with MS Access

I'm trying to create a simple quoting tool using MS Access. It's supposed to be a variation on the standard Orders - OrderDetails - Products type of M2M data model, however the complication is that ...
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
15 views

phpMyAdmin + TYPO3 = Error code 200, how to solve?

I'm running a TYPO3 4.5.37 with the phpMyAdmin 4.18.4 plugin installed (both latest versions). TYPO3 itself works perfectly fine and the website, too. But if I click on the phpMyAdmin extension in the ...
0
votes
2answers
2k 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 ...
0
votes
0answers
13 views

OBDC SQL connector for Windows Auditing Server to interface with Linux syslog server

I am working on a cross platform project here is the scenario: UNIX/Linux We have a Linux syslog server currently in place collecting syslogs from all network appliances and UNIX/Linux systems. ...
-2
votes
0answers
33 views

A good day (got laptop back) turns bad - stuck trying to update Windows to 8.1

I have an ASUS that is pretty much my life and it's the busy season of year in the culinary industry. Anyway, after getting a new hard drive, I got the laptop back from techs and needed to update to ...
0
votes
1answer
3k views

How to fix UDI-31623 error in Oracle?

Yesterday I've tried to import another DUMP as a new Oracle schema and failed to to limited space. So the impdp exited with an error. I've successfully deleted outdated schemas using the sysadmin ...
0
votes
0answers
32 views

How to connect to mysql database on a remote server behind a vpn requiring an ssh tunnel from another remote server using php?

I need to connect to a mysql database with php from a remote server. The mysql database is on another server owned by me. On the mysql server, the only permissions I have is to read and do database ...
12
votes
4answers
14k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
-2
votes
1answer
26 views

How to pull data from a website into excel? [closed]

For example, If I wanted the cheapest price of this item displayed in cell A2 of my excel spreadsheet, is there any code I could write to do it? This is not continuously scraping data. Maybe finding ...
5
votes
2answers
4k views

How to drop all MySQL tables from the command-line?

Usually I open Terminal.app and connect to a remote MySQL database. Then I use this command to drop a table: mysql> drop table [table name]; But what I need is the command line to drop all ...
1
vote
1answer
21 views

Transposing data from single column list to multi-columns

I have an Excel spreadsheet which is tens of thousands of entries long but it's not organized. All the data is in a single column with each entry taking up 3 rows followed by a space. For example: ...
0
votes
2answers
85 views

Update a sqlite database while select into a while loop

There is a bash script that will do "some magic"™ to files which will be referenced to a sqlite database and after doing "some magic"™ the database should be updated. Here are the simplified code ...
0
votes
0answers
6 views

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
-1
votes
1answer
76 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
1
vote
0answers
66 views

Can you recommend an alternative to iTunes on Mac computers? [closed]

I have a large iTunes database (over 750 GB) and iTunes can't manage large databases without screwing up. I am looking for an alternative solution to manage the metadata of my collection (including ...
0
votes
2answers
35 views

Shortening an Excel formula if possible

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

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
0
votes
0answers
506 views

Ms Access : “Unrecognized Database format”

thanks in advance, i have an VB6 project which use the database ms access 2000. With some electricity problem i lost the database file from project, but with the help of some recovery based tools , i ...
1
vote
1answer
28 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
15 views

USe of Optimal Flexible architecture in oracle 11g?

I would like to to know about Optimal Flexible Architecture(OFA). I went through some articles in internet. But how exactly should we do to separate Oracle binary files and oradata(data files ) in ...
2
votes
3answers
1k views

Is there any good way to encrypt my ms access database?

After installing my desktop application any body can see the database on their local systems. Even if I set Password security on access database its not going to work.Encryprion may be one of the good ...
0
votes
0answers
7 views

Eclipse plugin for viewing database scheme

I tryed to install following plugin: dbschemaviewer but it doesn't work for me. I see following message: I think that it is related with version incompatibility. Can you advice alternative plugin ...
1
vote
0answers
36 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" ...
0
votes
0answers
14 views

Duplicate data in first column, while retaining data for other columns

I have data that is organised in this fashion: Airport Forecourt 0610 0640 0705 however I require the data to be in this format: Airport Forecourt 0610 Airport Forecourt 0640 Airport Forecourt ...
2
votes
0answers
69 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
7 views

IDEA bad encoding inside database veiw

I have connected my database and IDEA. Now I see list of tables from my database. but when I want to see table content I see following: Actually this content on my native language(not English). ...
1
vote
0answers
74 views

Why are there limits to scaling relational databases? [closed]

It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created. But what are these scalability limitations ...
-1
votes
1answer
33 views

Is it possible to connect to router through ssh?

I have a WiFi-router (cisco linksys) at my job and I have to access the database of our website frequently, but the access to the database is restricted and is only possible from my workplace. I read ...
1
vote
0answers
735 views

The best way to sync an MS Excel file with DB data (including saving it)

I have an Excel file that is supposed to mirror some data from an MS SQL DB. This file is synced automatically to a remote location. I would like that whenever the Excel file is synced, the data that ...
-1
votes
1answer
1k views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
1
vote
0answers
361 views

“Compacting” a SQL database after deleting records with SQLiteMan

I'm using SQLiteMan to edit/delete Skype message history, as described in numerous guides on the Net. I.e. I open Skype's main.db file in my profile folder using SQLiteMan and selectively delete some ...
0
votes
0answers
107 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 ...
0
votes
0answers
26 views

Select last four from credit card field and place in new field

I am new here. I hope this is the correct place to post this? I have a table ("accounts") in Advantage DB with two fields (CCNo & LastFour). CCNo is Credit Card Number. Last Four is the last four ...
1
vote
1answer
292 views

manipulate unknown database file

I have a database file ending in .dat, which says nothing to me. Given that it uses a file per database, I assumed that it had to be some sort of sqlite, so tried to open with sqlite3 and has not been ...
-2
votes
1answer
39 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
1answer
90 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 ...
0
votes
0answers
18 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
0answers
17 views

Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in. I am trying to ...
0
votes
0answers
27 views

How can I connect to apex oracle database using ssh?

I have obtained a workspace in apex.oracle.com , where I can use database provided for me. Now I can run the sql command in browser to do operations, but thats kinda slow. So what I need to do is , ...
0
votes
0answers
54 views

Network shared access database: your network access was interrupted access to continue close the database

I have a network with several Windows XP and Windows 7 users accessing MS Access databases over shared files in a NAS Synology. One of the XP users get several times in a day the following message: ...
0
votes
0answers
49 views

generate entity relationship diagram from h2 database

is there an easy way to generate entity relationship diagram from h2 database? I coudn't find any useful thing from google.