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)

3
votes
2answers
1k views

Where Are Databases Located - MySQL File Location

I just installed a CRM application with a MySQL database. I thought I new the name of the database but I can't find it. Now I am trying to perform a mysqldump but I don't know the name of my ...
0
votes
1answer
1k views

Looking for Firebird GUI [closed]

I use phpMyAdmin to manage all of my MySQL databases and SQL Management Studio Express to manage my MS SQL databases. Now I need to start working with Firebird, and I'm looking for a tool along the ...
2
votes
2answers
158 views

What is the easiest way to apply database functionality into my daily life? [closed]

let me try to explain it by listing some of the things I want to do: Submit random thoughts, notes, facts, and to-do tasks of any sort and at any time. Tag each of these submissions freely. Manage ...
2
votes
3answers
1k views

Cannot Attach Database in SQL Express More Than Two Directories Deep?

I have a database in one of my Visual Studio Express projects. I want to attach it to my local SQLEXPRESS instance so I can run aspnet_regsql on it and add the membership database. When I select ...
1
vote
1answer
739 views

Virus cleanup + dying drive = XP Automatic Updates crashing in esent.dll

Background I'm doing system recovery on an old WinXP SP1 system brought to me on suspicion of virus infection. After taking preliminary backups, I used MalwareBytes to detect and clean the infection. ...
1
vote
1answer
445 views

Advise on VMWare hardware requirements and host OS

I'm a newbie developer wanting to learn a bit about Virtualization (from the IT point of view, not theoretical/academic). What I'd like to do: Prepare a machine Install VMWare or VirtualBox ...
0
votes
1answer
794 views

Problem with creating table on phpMyAdmin database

I'm running a phpMyAdmin Database on my web package on a 1and1-hosted server. I've managed to set up a database in the control panel, have uploaded all to root/phpmyadmin and changed the ...
1
vote
1answer
1k views

How do you create a mailing list with Lotus Notes?

I have a list of users of an application stored in an SQL database. I'd like to be able to email these people with useful information. Two parts to the question. How do I send queries to an SQL ...
3
votes
1answer
62 views

Need data on disk drive management by OS: getting base I/O unit size, “sync” option, Direct Memory Access

I want to ensure I have done all I can to configure a system's disks for serious database use. The three areas I know of (any others?) to be concerned about are: I/O size: The database engine and ...
2
votes
4answers
7k views

Program to view and edit fixed width text files? [closed]

I'm looking for a program that can view and edit text files that contain data in a fixed width format. The files contain no carriage returns. I've tried viewing them in excel but the import process ...
4
votes
1answer
951 views

Read data from separate CSV file in OpenOffice Calc

I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that ...
7
votes
5answers
10k views

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
10
votes
3answers
12k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
1
vote
4answers
3k views

Small database recommendation (free) [closed]

I need a small database for handling some stuff ... nothing too big, up to let's say 1000 entries. Problem is the last time I used a database of some kind, was round', oh I don't know, 1995 ... ...
3
votes
7answers
2k views

Small database for scientific papers

What small database for scientific papers can be recommended? I just need a small way of handling a list of a few hundred (maybe 300 tops) scientific papers. I have author (often more than one on one ...
3
votes
5answers
1k views

Is there a better way to organize my downloads?

I'm a download pack-rat and have a large collection of downloaded files including software, music, videos, books, magazines and research papers. I'm looking for a better way to manage all of it. ...
1
vote
2answers
787 views

Installation of MS SQL Database 2005 on Windows XP Home Sp3 fails with no specific error

I am trying to install MS SQL Database 2005 on Windows XP Home SP3. It fails giving no reason ("Database failed to install"), then exits. I had already installed MS SQL Database Express Edition 2008 ...
1
vote
3answers
1k views

What is the equivalent of MSSQL to Open Source

I want the equivalent of MSSQL to opensource DB?
2
votes
2answers
1k views

OS X alternative to Filemaker

We're a small office (20 people) on OS X that needs to replace our old Appleworks databases with something that's a little more future-proof. We have the problem where something like Filemaker is a ...
1
vote
3answers
15k views

.pdb file viewer or reader tools?

I have a lot of files in .pdb (as in a Palm Pilot Database) format, major of them downloaded, but until now I can't using or read what the inside, so I looking for how to read, view the .pdb file ...
7
votes
4answers
562 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
1
vote
4answers
4k views

Copy a SQL Server 2008 database verbatim

I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another. How do I do that?
3
votes
2answers
4k views

Incremental Backup for PostgreSQL 8.3

I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, ...
22
votes
4answers
63k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
2
votes
0answers
442 views

Create view based on table in MS VISIO 2003

I'm working on a physical ERD in Microsoft Visio 2003, and I want to create some views based on only one table. Right now I've having to manually add all the columns from parent table. Is there a ...
1
vote
1answer
663 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
2
votes
1answer
666 views

How can I decrease the size of Thumbs.db files?

I don't want to disable Thumbs.db files created by Windows, I just want to make the thumbnails be viewed in smaller size and even in worse quality. Is there a way to do that?
1
vote
2answers
823 views

Is there any JSP client to access/admin JDBC database?

I want a free JSP client to access/administrate my remote database through JDBC interface, it should be phpmyadmin-like, and can run within tomcat/resin container, do I have some choices? Lenik
1
vote
1answer
203 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
5
votes
4answers
7k views

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. ...
2
votes
3answers
106 views

Charity membership drive – using a laptop as a signup form

The situation: I work for a charity, and we frequently go to events where people want to sign up and learn more about the problem we work on and our work. The problem: This requires a) printing ...
0
votes
3answers
339 views

Solaris says my partition is using 100+ GB, but the partition looks empty. Where is the space being used?

I'm telnetting into a Solaris 5.9 box that's supposed to store our oracle database. I deleted the old version of the database, tried to move in the new version (the entire database is 90GB) but I ...
0
votes
1answer
61 views

migrating berkeley database from XP to linux box

I am in the process of migrating from XP to Linux (Unbuntu 9.10). I need to migrate a larg(ish) BDB database (approx 5Gb) from my XP machine to the Linux machine). The berkeley database was created ...
1
vote
4answers
1k views

What database software will open a .db5 file?

What database software will open a .db5 file? Namely the Windows Live Photo Gallery Pictures.db5 database. I'd like to see the design and also the raw table data if possible.
1
vote
1answer
137 views

What tool to build a clients database and agenda?

Background: A friend of mine wants to upgrade his computer. He is using an old proprietary tool to manage his clients files and agenda. This tool won't work on a modern OS, he could ...
0
votes
3answers
779 views

Free Database Utilities / Tools for Mac OS X

If I were using Windows and wanted to use a database I would set up a WAMP server. What can I use for Mac OS X? I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite. I would ...
2
votes
5answers
13k views

Where to store\update tnsnames.ora file when installed oracle client only?

I installed the oracle client only but was told to update my tnsnames.ora file with the info my dba sent me. But I don't have a tnsnames.ora file. On another machine with a full oracle admin install ...
3
votes
4answers
747 views

QnA Knowledge base software [closed]

I'm looking for a small software to build a knowledge base of QnA's on my local PC, like the KBs large software vendors maintain for how-to's regarding their products. Something where I can: Q: ...
0
votes
6answers
25k views

Convert Excel Text string to Time

I'm trying to Export from an OLD System that stored Time in / Time out as a text string in 24 hour time. For example 3pm, is entered as 1500 (no colon) Is there a simple way I can convert these ...
3
votes
4answers
1k views

Is there an online alternative for picasa? [closed]

Is there an installable PHP/MySQL image database system like Picasa? I want to setup a small image database for our company. It would be hosted online, so the co-workers have access from any place. I ...
1
vote
3answers
1k views

Connection problem to MySQL on another machine on LAN

I'm having trouble connecting to a MySQL database on the other machine on the same network. Could not connect to the specified instance. MySQL error number 1130 Host 'abc' is not allowed to ...
0
votes
1answer
4k views

Is it possible to have Word 2007 access a MySQL database?

What I essentially want is some way to expand my mail merge system. If an account number gets sent to a word document via mail merge, I would like some way for Word to connect to a MySQL database and ...
8
votes
1answer
18k views

What is a DDL script in the context of databases?

What is a DDL script in the context of databases?
9
votes
4answers
8k views

Linux GUI Database Manager [closed]

Does anyone Know any KDE application for working with databases in a unified way? It must support several DBs (sqlite, MySQL, Oracle). GTK apps are also welcome :)
1
vote
2answers
524 views

How do I recover my database?

I exported my database to test whether it works. I then deleted the database and then it went to the "Trash" (I'm using Ubuntu). I then deleted it from "Trash" accidently. Is there a way to recover ...
1
vote
4answers
278 views

Which is the best solution for shared database meeting these requirements?

Which solution would you recommend which has: a relational database with a user interface access for 20-50 users potentially working in parallel user authentication log of changes customizable ...
2
votes
2answers
368 views

Easily host a MediaWiki locally? [closed]

Is there a simple Wiki that doesn't use a database, but which uses syntax like MediaWiki? (eg. like Wikipedia) I want to host it locally on my PC, but have it hosted as an HTTP webserver on a ...
1
vote
2answers
358 views

Home movie database software

I am looking for (preferably open-source) software for Windows XP that will allow me to keep track of all our self-made videos. My parents should be able to operate it, so we would like it to have a ...
4
votes
2answers
2k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...
1
vote
1answer
180 views

To find ORM app for OSX

I would like to have an app for OSX which can make Object-Role Models, similar as this one. I use currently Top Coder's UML tool. However, it has some weaknesses: I cannot change the order of columns ...