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

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
0
votes
2answers
84 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
2
votes
1answer
288 views

What's a good database-backed X.509 certificate authority on Linux

I've been using OpenSSL as an X.509 certificate authority. Because multiple machines will need to create certificates, I've exported the certificate authority folder on a distributed filesystem. When ...
1
vote
0answers
53 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
2
votes
1answer
3k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
-1
votes
1answer
3k 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
1answer
116 views

Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column, the matching name should appear in the second column automatically. The list of numbers and names is on a ...
1
vote
0answers
37 views

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
1
vote
1answer
77 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
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 ...
0
votes
0answers
158 views

How to restore mysql databases from file disk

I used to have a few mysql databases on my system, but my operating system crashed and I cannot access the installed mysql service anymore. The only thing that I have is access to the database files ...
1
vote
3answers
251 views

Does Google Chrome have some primary key in its cookies database?

I am writing some scanner for Google Chrome cookies, as stored in a SQLite database. It also has an option to delete cookies, however I didn't find any ID field. The most similar is creation_utc, I ...
0
votes
1answer
807 views

How do I open a Rails Mysql database in Mysql Workbench?

I having trouble finding my mysql database files in Ruby on Rails project and opening it in MysqlWorkbench This is my folder structure for a app This is my database.yml development: ...
2
votes
0answers
54 views

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle. ...
0
votes
1answer
943 views

Wordpress Creating Empty database

WordPress is creating an empty database, there is a database but with out any values. I am on local WAMP Server 2.4 (PHP 5.4) Windows 8 Wordpress 3.6 (also tried 3.5.1) WAMP Apache is Giving some ...
0
votes
0answers
3k 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 ...
2
votes
0answers
155 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
0
votes
1answer
281 views

Where is the 'Query Options' command in Word 2010?

I want to attempt a mail merge by category. Was it removed from the app?
0
votes
3answers
578 views

Method to convert Zipcodes to Addresses

At my mother's workplace, she often accesses the database and pulls out numbers in order to form reports. From selecting data Oracle to outputting reports in Excel format, she has come across this ...
-1
votes
1answer
420 views

database structure “customers” table having several orders per customer and several items per order [closed]

I want to create a database that has several customers and many orders per each customer and each order has several items in it. I was thinking of creating a table for each order and populate each ...
0
votes
1answer
107 views

Move multiple SQL Server 2008 databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...
0
votes
1answer
395 views

Amazon Cloud as a Server with alot of RAM [closed]

I need a server with very big size of RAM, so around a ~1TB, for a GIS DB, that would be not written to hard disk, because the data is irrelevant after a seconds. So i do not need a lot of disk space, ...
0
votes
2answers
264 views

Where is the Riak CentOS installation directory?

Used "yum install riak" on CentOS 5.8, and easily found the config files in /etc/riak. However, I can't find where the data files and installation files are located. Anyone know where they are? ...
1
vote
2answers
563 views

this database is not compatible with this application - Application compatibility toolkit

I installed the Windows Application Compatibility Toolkit and installed SQL server 2012 express to use as the database server. When I run ACT and try to create or select a database, it puts a little ...
0
votes
1answer
538 views

Excel SUM or COUNT based on related fields from two Tables

I have two tables in Excel The small table with 50 rows...tblGroups[#Headers]= Employee ID; Name; Group. The second table with 3000+ rows...tblData[#Headers]= EventID; Date; Employee ID; ...
1
vote
1answer
1k views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
-1
votes
1answer
697 views

How to update a Powerpoint slide with an external database?

I have a database of 1000 users with their name, number, photos, addresses, and other fields, etc. (in RDBMS-like say mysql, PostgreSQL). But I want to implement this mostly in Excel. So what I want ...
0
votes
0answers
414 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
67 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
2k 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
126 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, ...
-1
votes
1answer
204 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 ...
2
votes
2answers
13k 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
81 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
74 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 ...
-1
votes
3answers
4k 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
190 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
38 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
89 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 ...
10
votes
1answer
31k 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?
0
votes
4answers
306 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
53 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
107 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
77 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
1answer
377 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
903 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
139 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
1answer
380 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
53 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
3answers
100 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 ...