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.
0
votes
0answers
10 views
How to install and configure database certificate tool?
How to install and configure Firefox Database Certificate Authority Tool (Certutil)
I have a PHP based web application with log-in functionality. Now the log-in works with the help of SQLite ...
3
votes
1answer
37 views
Transfer Amazon S3 data to MySql Database
I have about 350000 files in my Amazon S3.
I need to transfer them to a MySql database running in my server..
Which is the best way to do this?
I saw this post which uses Pipeline, but Pipeline is ...
-2
votes
0answers
28 views
Is it well designed relational database just with one table? [closed]
I have MySQL database containing just one table, having 100 rows and 12 columns: ID (primary key), NAME, LATITUDE, LONGITUDE, TYPE, COUNTRY, CONTINENT, DESCRIPTION_PATH, STORY_PATH, PICTURE_PATH, ...
-2
votes
0answers
25 views
Average time for importing 750MB mysql database on WAMP [closed]
I am trying to import a database with 750MB of data size via the command mysql import.
It's been running for 45 minutes now.
Is this normal? How can I verify that it is running or see if it is ...
0
votes
0answers
12 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
23 views
To keep web application and database on different VMs? [closed]
I have an Analytics Database (star design in SQL server 2008) and a web application (ASP.NET) that gets data from the DB and renders various reports and charts (MS Charts). They run from the same VM ...
-1
votes
0answers
36 views
Using VBA to automatically assign gender in excel spreadsheet [closed]
I have to do an analysis on an online membership database within excel, but for some reason, some of the cells under the Gender column remain unfilled. I have found moderate success by downloading an ...
0
votes
1answer
42 views
Sort by selection..spreadsheet software
I am so frustrated... I use ArcMap a lot and therefore I use the 'show selected features' a lot when I am in the attribute table. Now I need to manipulate a csv file in excel with 150,000+ records ...
0
votes
1answer
28 views
How to access my database stored in PHPMyAdmin from different computers?
I am working on my Java application in Eclipse that connects to the database and makes some queries with the data. This database has been created and managed in PHPMyAdmin. The database is stored ...
1
vote
0answers
13 views
Importing data from database into Excel Web Services with parametres
I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
-2
votes
1answer
55 views
How do companies like walmart,target etc. update there barcode scanner systems? or create a barcode system? [closed]
I was wondering how a big company make a barcode system? Are there any barcode databases off the web that I could just download as a whole? And once I had one where would I go to update the already ...
1
vote
2answers
75 views
Dynamically filtering data before importing from SQL Server in Excel
I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
2
votes
1answer
19 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses.
On SQL Server 2005, we currently log certain table changes via triggers using the inserted/deleted tables. Currently, our log ...
-1
votes
1answer
20 views
phpMyAdmin: Make foreign relation more readable [closed]
I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but ...
-4
votes
0answers
41 views
Is there a database of software? [closed]
I need a database dump, that contain (well, as much as possible) common software as rows.
Something like
id software_name
---- ----------------------
1 Adobe Acrobat
2 ...
2
votes
0answers
45 views
Microsoft Access 2010 Error
Ok, so I am not a pro in MS Access (or databases), but I tried googling this and no answers, so here goes nothing:
I am trying to create a field to convert currencies from one of 2 fields, thus I am ...
0
votes
3answers
46 views
mysql access denied for 'root'@'name of the computer'
I am getting this error everytime im trying to connect to my database
Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045):
Access denied for user 'root'@'name of the computer' ...
1
vote
0answers
26 views
Pull Data From Web Database With Excel 2007
I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored ...
0
votes
0answers
19 views
Microsoft excel 2010 - how to transfer multiple rows based on single key
I have a structure like this Current Department/Responsibility unique code/Target Department
I want to create a new sheet where I will put down all the new departments(target departments) and draw ...
0
votes
1answer
46 views
KeePass like program without password auth [closed]
I'm looking for a program that's like KeePass's UI, and self contained 1 database file, but without the master password requirement.
Essentially take KeePass, and remove the master password ...
2
votes
1answer
557 views
How to: Database Model in Visio 2013
I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
1
vote
0answers
41 views
Is there a way to convert a memo field to a text field in Access 2010 in an expression?
I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
2
votes
1answer
73 views
Easy way to put multiple columns in Excel on their own rows?
I have a sheet that looks like this:
A | B | C | D | E |
----------------------------------------
62| Value1| Value2| | |
345| Value3| Value4| Value5| ...
0
votes
4answers
162 views
How do I have Wordpress keep its database in the same directory as other files (for sharing via Dropbox)?
I am working on a Wordpress site with another person. At the moment the Wordpress files are on a shared Dropbox folder, which allows both of us to see all the files we need to work on. However, ...
0
votes
1answer
25 views
Corrupted database disk image [duplicate]
I have a corrupted sqlite .db file which cannot be opened in java because "the disk image is corrupted". I'd like a way to repair the database and recover as much data as I can, and make it openable. ...
0
votes
0answers
23 views
openoffice base report
I'm using open office Base to create a stand alone database for my service record. the problem is when i try to create a specific report, i cannot get the output that i want. lets says, I want to open ...
4
votes
1answer
49 views
How to store processed data?
I'm working on a project involving Twitter data. I have several hundreds thousand tweets downloaded and stored in files. The data was returned in json format, and the stream consumer I was using ...
0
votes
0answers
57 views
Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8
I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
0
votes
1answer
149 views
How to extract numerical value after a certain string within a sentence in Excel cell?
I want to extract the numerical value immediately following the string "ABS" (Case sensitive) within a bulk of text in a cell from an Excel table.
Not all the cell may contain the the string I'm ...
1
vote
1answer
54 views
Copy data from mail server to database
Is it possible to backup emails into MySQL database?
Say, I have an account me@domain.com and I want to keep record of all the emails inside the mail.domain.com locally, in my computer.
From what ...
0
votes
0answers
63 views
How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?
Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn?
The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
30 views
What Microsoft product is used to draw a Relational Database for MS SQL?
What Microsoft product is used to draw a Relational Database for MS SQL?
For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
2answers
25 views
I have a mysql table with 150k rows and do regular updates. Updates can take 1-3seconds. What options do i have to reduce this?
I have a table (mysql) that has 150k rows. During the day there are multiple updates (1000s) that change an int value to another int value (update table set field = ? where table.id = ?). nothing ...
-1
votes
1answer
45 views
open source utility to create diagrams of tables in RDBMs [closed]
I have reviewed a number of graphical modelling of tables and views in relational database and none of them was satisfactory (re ease of use, stability, etc). Does anybody know of such open source / ...
0
votes
1answer
211 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
85 views
Completely remove Postgresql which was installed with Homebrew
A while ago I did brew update, brew upgrade and now things are working kind of funny. When I run cucumber I'm told that
FATAL: database "project_test" does not exist
(PG::Error)
I keep chasing ...
2
votes
1answer
44 views
PostgresSQL created a user account on OSX
Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
1
vote
0answers
84 views
how to connect to pervasive sql through odbc?
I am trying to add a linked server to a sql server 2012 database using ssms 2012.
the linked server is pervasive sql. here's how i am trying to do it:
EXEC sp_addlinkedserver
@server = ...
0
votes
0answers
49 views
Time truncation in database results in Excel 2013
We have an application built upon Excel (some querytables plus some VBA).
Behind that is an SQL Server query that returns some dates, date part of which is 1899-31-12. This date value is the "zero ...
0
votes
0answers
37 views
Auto - create emails from supplier database triggered by dates
I need to create a record of our suppliers, at the minute I have basic info about them in an excel spreadsheet.
This needs to be expanded to include details of their insurance cover, with the ability ...
0
votes
0answers
108 views
How to set Interbase 6 server always up in Wndows 7?
I have problem in activating Interbase 6.0 in Windows 7.
The IB server always in not-activated state and need to be started every time, eventhough it's service already started.
Do you have any idea ...
1
vote
0answers
18 views
How to migrate a CRM database to an other? Manually or with an ETL solution?
I would like to migrate a database:
- from Goldmine 5.0 - SQL Server 2000 (more than 10 years old, huge quantity of datas)
- to Microsoft Dynamics CRM 2011 - SQL Server 2005
ETL solutions so far I ...
0
votes
1answer
28 views
Should a dev team use a local database or a remote shared one? [closed]
I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each.
I would like to know your point of view about this way of working ...
0
votes
1answer
58 views
Which database should I learn? [closed]
I'm currently learning Python (2nd attempt, by the way) and I wanted to know which is the best database to learn in order to complement my studies? I'm currently a front-end developer, so back-end is ...
0
votes
1answer
39 views
Audio file in database [closed]
Friends, I want to know in which database,an audio file can be inserted and retrieved from a table without any loss? Please help me...!
2
votes
2answers
47 views
Creating A Log Of Files In A Folder
I am an absolute newbie in this thing.
Can anyone help me to build a table that lists all files in a specified folder so whenever a file is copied to that folder the table should update.
I need the ...
3
votes
1answer
97 views
Which program does *this instance* java.exe belong to? Why is it there, and can I remove it safely?
Since I'm stuck in deciding for sure if I should just delete C:\WINDOWS\system32\java.exe ...
(I use the java.exe from C:\Program Files\Java[javaversion]\bin, which I explicitly set in my path ...
0
votes
1answer
44 views
Relational database on a slow storage
I'm trying to pick a RDBMS for usage as a backend for KDE's Akonadi PIM framework.
Problem is that the storage (/home partition) resides on a pretty slow SD card with reiser4 filesystem on it. The ...
1
vote
1answer
95 views
Copy data from “SELECT Multiple” Selection Box
I need to copy data from a selection box with the "multiple" HTML attribute that looks something like this:
I have tried selecting all options and do "Ctrl-C" but it didn't work. When I go to the ...
0
votes
1answer
100 views
How to get the articles out of the RSSOwl database (db40)?
The feedreader RSSOwl saves all articles in a database rssowl.db. As far as I read, it's a "db40" database.
Size of my rssowl.db is at the moment 3.9 GB. I also got another database with size of ...
