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
1answer
102 views

Visual Studio 2010 SQL Querys how to set BIGGER default font

By default, the default font when you perform a query on a table by going to right click over table -> New Query is very small, you can increase it pressing ctrl+ but when the query is execute the ...
0
votes
1answer
1k views

Libreoffice Base: combobox keeps replacing value to 0

I have a ComboBox which loads a country list, every time i select one item and then focus in other object of the form it resets to 0. This ComboBox is linked with an Integer value in the main table ...
0
votes
1answer
495 views

Is there an easy fix to this copy/paste into Excel error?

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error: Microsoft Excel is waiting for another application to complete an OLE action I ...
0
votes
1answer
1k views

Why is my mysql database table not allowing me to edit data manually?

For some odd reason out of the blue my database in MySql will not allow me to manually edit any records. My guess is it never has. I am logged in with the Workbench under the root account. I have ...
4
votes
1answer
328 views

MySQL quiet installation references wrong executable

I am trying to install MySQL 5.5.27 (latest) quietly from the Windows (XP) command line via batch file using the MSI method. Following the directions on the MySQL site, I simply do this: msiexec /i ...
2
votes
1answer
1k views

How to add new customized columns to windows 7 explorer (or find a similar application that is more customizable)

I like the way windows 7 explorer allows me to organize all my files by sorting columns - except there is little room for customization: I can't add my own types of columnns that can then be directly ...
2
votes
1answer
534 views

Spreadsheet application that can handle big data OS X

I've been working with Excel for quite a while for some statistical analysis that I do regularly. The size of the data that I'm working with has gotten much larger as of late, however. The layout of ...
4
votes
3answers
4k views

How does geolocation based on IP address work?

As all Internet users, I've visited web sites which appear to know in which country and city I'm located. I understand that these web sites typically look up my IP address in a database which maps IP ...
2
votes
2answers
974 views

Simple lightweight cross-platform database [closed]

I'm looking for a really simple to use lightweight database. Ideally something open-source that stores data in a (semi-) human-readable format, in case the software isn't working. Something ...
1
vote
0answers
579 views

installed mysql using yum but mysqld dowsnt start: Fedora 16

i installed mysql mysql-server and mysql-libs ... after installation i thought to start the mysql service using command systemctl start mysqld.service Failed to issue method call: Unit mysqld.service ...
1
vote
1answer
405 views

What does the output of this “source” command mean?

Unix newbie here, installing MYSQL. Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables: setenv MYSQL_UNIX_PORT ...
0
votes
1answer
40 views

Is running multiple databases on login going to make my Mac really slow?

Sometime ago, I installed Postgres, and the Launch agent that causes it to run when I log in. Just now, I did the same thing for Mongo. I was just about to do it for Couch. I don't remember if I ...
1
vote
3answers
9k views

How to connect to MySQL server in LAN?

Here is the technical description. My laptop's config: IP Adress:192.168.2.5 MySQL Server 5.0 on port 3306 Operating System: Ubuntu The database is in this machine My friend's laptop config: ...
0
votes
1answer
322 views

Conversion of GRIB and NetCDF to my database

I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. It was a .tar.gz file so I extracted it in my local directory and I get the files as shown in the image below: ...
0
votes
1answer
211 views

How to get the difference between two dates based on an item (truck) number

I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
0
votes
3answers
293 views

Easy to use database with views for a medical student doing research?

I'm having trouble finding a tool that does this for my friend (without designing it myself). What is needed is a simple program with a database where input forms and views can be designed and saved. ...
0
votes
1answer
460 views

What command in MySQL is like the command “host” in oracle sqlplus

Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc. Here are examples SQL*Plus_FAQ, docs.oracle.com Is there some ...
1
vote
2answers
92 views

How to transfer results to Excel

I have a massive (and I mean MASSIVE) amount of results from Minitab 16 displayed as plain text organized in columns and rows. My problem: I need to put all this information into tables to manipulate ...
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 ...
1
vote
1answer
455 views

How to migrate a database from MyISAM to InnoDB?

I am migrating a database with MyISAM tables to an InnoDB engine. Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
0
votes
2answers
47 views

Access, select or utilise names in another worksheet of the same book

I've created a name database on an Excel sheet and I would like to access, select or utilise any of these names in another sheet of same book.
1
vote
0answers
260 views

Sage 1000 data dictionary

I'm just starting doing reporting using MSQL SSRS against a Sage 1000 database. It's working well but I'm trying to find out more about the data model on the database in order to make best use of the ...
0
votes
0answers
108 views

What enterprise tools exist for exporting from a database into a set of files?

I'm looking for software that's designed to select/query data from a database (SQL or NoSQL), and export it into files (CSV, XML). Ideal characteristics: Manage very large datasets (petabytes), ...
1
vote
1answer
277 views

Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?

I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...
0
votes
1answer
207 views

MS Query unresponsive after launching in Excel 2007

User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...
1
vote
1answer
188 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
147 views

Issue changing mysql password on Debian

I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
1
vote
0answers
291 views

Export MS SQL database as *.dbschema

We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
2answers
2k views

SQL Server Management Studio: Database Attachment Failed

I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem. ...
0
votes
3answers
59 views

Can there be permissions/limitations with browsers over a network?

I'm part of a network at my job and the only thing that can be accessed from my/my co-workers computers is the company database and sharepoint. These are accessed through IE. Everything else is denied ...
1
vote
1answer
183 views

Is there a term for software that allows users who don't understand DBs to create reports from a DB? [closed]

Is there a term for software that allows users who don't understand DBs to create reports from a DB? A customer might just say I wanna see people and addresses that are related to this incident, for ...
3
votes
2answers
722 views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
0
votes
2answers
180 views

extract information from table of values

Hi I have table of values stored in a csv file and the table is organized the following way: Method1,,Method2, T1,T2,T1,T2 a1,b1,c1,d1 a2,b2,c2,d2 a3,b3,c3,d3 a4,b4,c4,d4 One example of something ...
2
votes
1answer
3k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
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
vote
1answer
195 views

Fastest way to transfer an mssql database backup from one windows server to another?

Would it be by copying it onto a hard disk or is there a faster way?
-1
votes
1answer
97 views

Is it possible Connect landphones to mysql? [closed]

I have a land phone that displays the caller ID. I want to use a some interface or cable to connect the phone to a pc and then connect it to mysql, check if the user is available in the database, and ...
2
votes
2answers
5k views

How can I create an ERD for my phpmyadmin database?

Is there a way I can create an Entity Relationship Diagram for my PHPMyAdmin database?
1
vote
1answer
759 views

Database structure for handling multiple accounts (Multi-Tenant Data Architecture)?

It's always easy to write software that handles a single entity. However, designing software to handle multiple accounts/companies requires due diligence. I'm currently doing initial research into ...
2
votes
1answer
772 views

How to export and import an user profile from one Quassel core to another?

I have been using Quassel as my bouncer for IRC for quite a long time now. We (a group of administrators of a small network) have set up a shared Quassel core with many users on the same core. But ...
2
votes
1answer
627 views

Why would a DB connection over LAN be slower than a WAN connection?

I'd noticed for ages that a MySQL database connection over my LAN was significantly slower than a database connection over the Internet. I'm running Windows 7 32bit and I'm connected to a switch ...
0
votes
1answer
282 views

Merging Database Modifications - CVS

I'm working on a project using git for version handling. What is the best approach to include a mysql database in the cvs? For example, if I checkout the database and install it at home, make some ...
0
votes
2answers
341 views

How to setup anonymous FTP for file upload

I want to have a FTP server setup that allows clients to upload large files (2GB+ database dumps) by SFTP. The important point is that I want clients to log into the server with a single username and ...
2
votes
1answer
110 views

Possibe data corruption in x-ray room

I built a small fingerprint ID system for a lab. Registration is done at a reception and identification at 2 other points. One point is the x-ray room The problem: Identification often seems to fail ...
2
votes
2answers
173 views

Evernote Note filesize

I wonder if there is an option (inside of Evernote or outside of it, manually with the help of 3rd party tools) to locate the biggest notes inside of Evernote? I want to remove those or put them into ...
3
votes
0answers
424 views

How can I move the database location of Evernote successfully?

I am currently on Evernote 4.5.x and lost quite some data because I didn't notice that the crashing Evernote deleted recently created notes due to space limitations in my TC container. I am not happy. ...
1
vote
2answers
2k views

Free Database Browser for PostgreSQL?

Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...
2
votes
3answers
802 views

Free software to replace SQL Developer?

As for a developer, the use of SQL Developer is almost daily. However, given that my laptop have only 1 gb ram, it is hard to open SQL Developer and Eclipse together. Do you have any lighter ...
1
vote
1answer
125 views

Is there an off-the-shelf database solution similar to asihollywooddatabase.com or imdb? [closed]

What off-the-shelf database solutions would allow me to do the same thing as asihollywooddatabase or something similar to IMDB without having to write the software from scratch. I have little ...
1
vote
2answers
3k views

Linux Mint (Ubuntu) Microsoft Access Replacement?

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...