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
67 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
284 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 ...
1
vote
1answer
949 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 ...
0
votes
0answers
63 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
2answers
81 views

Kubuntu - how to find out what DB is installed

I'm newbie in linux, I installed latest kubuntu release. I was told that it already has sqlite on it/ How can I find out is it installed and what version of SQLite is on it?
0
votes
2answers
191 views

what is the main difference between a file with .db extension and a file with .txt extension while I save both of them from a text editor?

What is the difference between a file with .db extension and a normal file with .txt extension , leaving the fact that a .db extension is for a database file and .txt makes a normal text file. I open ...
2
votes
1answer
183 views

Do .frm files represent the entirety of a MySQL database?

So let's say I copy /var/lib/mysql and save it somewhere else, then uninstall/reinstall MySQL and put the original /var/lib/mysql back where it was. Will I have all of my databases without any ...
0
votes
2answers
3k 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
1answer
264 views

Mapping of child elements

I can't find one good way to solve this problem. I will try to sum the issue as best as I can: I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...
1
vote
0answers
980 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
1
vote
1answer
100 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
2
votes
2answers
278 views

Record bash_history to private database for all users?

I want to be able to setup a MySQL database and record all commands issued on my server by username and command. Is this possible, and if so, how would I set it up?
-2
votes
1answer
355 views

Ceridian HR-Payroll Source SQL error

We are using an old piece of software from Ceridian called Source this is a HR Payroll piece of software. I cannot phone their support as we no longer have a contract but use the software for archive ...
0
votes
1answer
43 views

Cannot connect to database

I created a php file to connect to my database hosted on ipages.com with the following simple code: <?php mysql_connect('hostname', 'username', 'password'); ?> When I load this page, I get ...
1
vote
1answer
101 views

How to connect or set a specifig schema in LIBGDA database browser?

I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement: SELECT * FROM schemahere.tablehere; Or is ...
1
vote
2answers
34 views

Best option for db installed in home dir? [closed]

My research group shares a server for which I do not have root access. I would like to install a database in my home directory to manage my results. What would the best option in terms of ease of ...
1
vote
1answer
2k views

Difficulty connecting to a database with Primavera P6

I'm having trouble connecting to Primavera P6 (project). When I enter my username and password, I receive an error: This user is already logged in... The password was never changed.
1
vote
1answer
202 views

MySQL deadlock - Adding columns

I had a nasty MySQL problem arise the other day. I added two new columns to table 'Promotions' (13 existing columns, ~750 records) using the PHPMyAdmin interface. This query ("ALTER TABLE.....") ...
0
votes
1answer
86 views

Am I using the best/fastest method of connecting to a remote database?

In my work, I often need to connect to a remote database. so I use a virtual private network(VPN) Client called "ShrewSoft VPN Client" , and that has some configuration. Then I use Windows "Remote ...
0
votes
2answers
2k views

MySQL File viewer/editor

I'm dealing with some very massive SQL files and I need to be able to go in and edit them. Are their any editors that work on Windows I can use? I need to be able to cut out what I don't need and ...
2
votes
1answer
7k views

How do I extract excel data from multiple worksheets and put into one sheet?

In a workbook I have 7 sheets(Totals and then Mon to Sat),I want to extract rows which have the word "CHEQ" in its cell (this is a dropdown list with two options-CHEQ/PAID)from all sheets. On my front ...
1
vote
0answers
312 views

CDX currupt index file & Windows 2003 Server

We're experiencing almost everyday database index corruption on Windows Server 2003. I wonder if it can be somehow connected with caching or other server settings. We are running an old application ...
0
votes
3answers
2k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
2
votes
3answers
3k views

Can an Excel 2007 Pivot Table merge data from different tables like a database?

I want to analyze data with a pivot table in Excel 2007. I tried to construct an easy example to explain my question below: I have a table (Table2) with data sorted by Person. I want to analyze ...
0
votes
1answer
332 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
0
votes
1answer
263 views

Why did I fail to build mariadb?

The error message is as follows: 141> Call Stack (most recent call first): 141> D:/tmp/mariadb-5.5.27/bu/cmake_install.cmake:81 (INCLUDE) 141> 141> 141> CMake Error at ...
0
votes
1answer
69 views

Did Microsoft TechNet 2005 contain Visual Fox Pro 9.0?

I'm working at a company that has an old copy of Microsoft TechnNet 2005, and I was told else where that "If you have a license to MSDN Professional (or higher) you have a license to Visual FoxPro" ...
1
vote
0answers
327 views

Info path 2003 refuses to submit - 'The form does not contain any new data to submit to the datasource'

I have this error InfoPath cannot submit the form The form does not contain any new data to submit to the datasource How can I fix this? I've made a form in InfoPath specifying an access ...
2
votes
0answers
2k views

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the ...
2
votes
1answer
19 views

searching the database objects

How can I search SQL server database to find string in any of objects name? I have a problem when testers says this and that is not working and I can not find it by it's name.
1
vote
0answers
48 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
0
votes
1answer
110 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
2k 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
584 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
2k 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
358 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
2k 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
567 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 ...
1
vote
0answers
605 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
450 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
11k 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
369 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
219 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
313 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
512 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
94 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
5k 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
504 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 ...