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

Where to retrieve MySQL Database Backup? Centos 6

Had taken a look at: Where Are Databases Located - MySQL File Location Didn't seem to help much. I used this for a single MySQLDatabase backup: ...
1
vote
0answers
68 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
0
votes
0answers
50 views

Deleting sentences in database file

I'm writing a MD5 based antivirus, and my friend send to me a document with thousands of samples and their MD5. All is fine, but I have to delete all sentences what contain "File does not exists:" ...
0
votes
0answers
230 views

Ubuntu FTP Server - Hetzner

I have an FTP Backup Server in Hetzner with details Backup Server: u*****.your-backup.de I am trying to connect to it through my ubuntu server using command $ ftp u*****.your-backup.de and i see ...
1
vote
1answer
170 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
0
votes
1answer
884 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). ...
3
votes
1answer
46 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
1
vote
1answer
336 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
1
vote
1answer
192 views

Which is better for multi-use auth, MySQL, PostgreSQL, or LDAP? [closed]

I want to set up an Oracle Linux 6 server that gives users secure IMAP email (with dovecot), Jabber IM, FTP (with vsftpd), and calDav. However, I want each user logon to be able to authenticate all ...
1
vote
0answers
57 views

Database for Quotes needed: Tags, multi-language support?

Dear superuser userbase! Almost every website now supports tags. I want to harness the power of tags for a private database, can you help? Ideal: A database of quotes (columns: English | German | ...
1
vote
1answer
223 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, ...
4
votes
3answers
896 views

How are sites like Pinterest able to hold all those pictures?

Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
-2
votes
1answer
313 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
90 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
305 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
4k 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
118 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
39 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
78 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
164 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
266 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
856 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
56 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
944 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
159 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
298 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
627 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
442 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
111 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
419 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
275 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
586 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
575 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
710 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
1answer
440 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
134 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
205 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
15k 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
75 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
202 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 ...