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
3answers
401 views

Best Light Software to Manage Large Amounts of Data?

I have seen suggestions like TiddlyWiki for storing data that you want to sort out, but I like solutions like MediaWiki but I don't like how heavy it is and I don't mind if I host it up on a webserver ...
1
vote
0answers
46 views

Tools for interactive type-2 (SCD) work?

Are there any good tools for interactive type-2 SCD work? I'm looking for both analysis (e.g., "what changed between date_1 and date_2?") and execution (e.g., "update my type-2 table with this new ...
2
votes
4answers
214 views

MysqlDump Long Load Times

I am using mysqldump database > output.sql to dump all the data in a database. The size of the output file is around 3.3 GB. I am importing it using mysql < output.sql however it has been ...
23
votes
4answers
34k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
1
vote
2answers
103 views

how to search file at server

i'm newbie at linux... 1. i want to make backup database(use mysqldump) 2. copy from server(use linux-server) to client PC (use linux- ubuntu 9.0).. 3. before that i want to search that DB file using ...
0
votes
1answer
60 views

Ubuntu Server Edition

I just installed the lasted version of Ubuntu server with LAMP my goals to build my own site and database (php mysql). is there a list of all the useful commands somewhere? is there a good how to ...
2
votes
1answer
52 views

Home & Office Laptop Connection

This may be a weird question, but...I have caught my son accessing inappropriate material on my work laptop at my home. He has used my wireless hope ISP. Will that show up at work on the servers there?...
1
vote
2answers
260 views

Email correspondence history viewer: Solution for a local politician

A local (Good!) politician in my city handles nearly 200 citizens' emails each day. She has two paid assistants, but they can't handle the pressure altogether, so they've recruited volunteers to sort ...
0
votes
1answer
216 views

How do I create a postgresql user and database from a fresh install?

I just installed postgresql onto an ubuntu box. How can I create user foo with password bar and database baz, so that foo owns baz? foo is not a unix user.
9
votes
3answers
7k views

What file format/database format does Picasa use?

I am trying to figure out what file format the .db file and .pmp files are. I tried using db_dump (Berkeley DB) for the .db files, but it seems that they are not Berkeley DB, or of an older version. I ...
1
vote
2answers
394 views

MySQL storage: how to manage a grow to infinite?

I'm just thinking about how famous internet services like facebook or twitter manage fast growing databases. Which could be a solution for this kind of problem? What about ids ? I read there is a ...
1
vote
1answer
176 views

Associating multiple data with a single entry in Open Office Base

I'm trying to build a database that I can use to track prices of groceries on certain dates. My problem is that I cannot figure out how to have a single entry associate with multiple data. For ...
0
votes
1answer
753 views

How do I populate multiple records of data into a PDF form like a mail-merge?

I have Acrobat Pro, and I have a PDF with a form on it. Assuming the fields in the form correspond to a data source (like rows in an RDBMS table or xml file), I want to then print multiple copies of ...
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
161 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
747 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
447 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
817 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 config.ini....
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
958 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 ... dBase,...
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
814 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
574 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
65k 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
446 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
665 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
679 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
841 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
8k 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
341 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
139 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
783 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 ...