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)

20
votes
4answers
47k 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 ...
14
votes
2answers
8k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
14
votes
3answers
851 views

What happened to WinFS?

The most interesting feature that was ever connected to what eventually became Vista was WinFS, a revolutionary (so it seemed, at least back then) new way of storing and accessing information on a ...
14
votes
3answers
15k 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.
13
votes
8answers
29k views

Open Source alternative to FileMaker or Access?

I'm looking for an open source alternative to simple databases such as FileMaker or Access (something visual where you don't need SQL very much). I know of Base in OpenOffice.org but I think it is ...
12
votes
3answers
13k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
8
votes
2answers
7k views

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl ...
8
votes
1answer
18k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
8
votes
7answers
591 views

School Management System

I am looking for a school management system to replace a homegrown Access db. It should be able handle the following for both a Primary and Secondary school Scheduling classes Student ...
8
votes
5answers
6k views

Linux GUI Database Manager

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 :)
7
votes
3answers
5k 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 ...
7
votes
2answers
5k views

PowerShell zip file synchronously

In a PowerShell script, I want to zip a folder before deleting the folder. I run the following (I don't remember where I found the snippet): function Compress-ToZip { param([string]$zipfilename) ...
7
votes
4answers
469 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 ...
6
votes
5answers
1k views

Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm

I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am According to this article it seems it should ...
6
votes
3answers
6k 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 ...
5
votes
1answer
12k views

What is a DDL script in the context of databases?

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

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
5
votes
3answers
2k views

What are some free tools to both view and modify Microsoft Access database (.mdb) files? [closed]

The database part of OpenOffice is a bit limited. What other tools exist to work with my legacy .mdb files?
5
votes
4answers
8k views

How do I synchronize multiple Access Databases together?

I'm conducting a study, where we will be collecting data using Access. Since there will be multiple persons conducting these studies using the same structured Access DB we need to figure a way to ...
4
votes
3answers
12k views

What's the equivalent of Microsoft Access on the Mac?

I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to ...
4
votes
5answers
6k 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 ...
4
votes
3answers
544 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 ...
4
votes
3answers
10k views

Remove the password from Microsoft Access file

I have an mdb file on my computer, but unfortunately I have forgotten my password, so I can not open it now. Is there any way to remove this password or some other way to open this file?
4
votes
2answers
5k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
4
votes
2answers
4k views

How can I create a database in PostgreSQL on Windows 7?

I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database. I tried with createdb mydatabase but I got this error message: createdb: could not ...
4
votes
2answers
3k views

Can I restrict users from design view in Access 2003?

Can I prevent users from opening an access 2003 database in design view? I don't want others to be able to change structure of the tables, just add change or delete the records within the table.
4
votes
2answers
171 views

Google Maps mashup for notes/househunting

I'm house-hunting at the moment and I'm trying to geek it out er I mean streamline the decision-making process. I'm currently using google maps's "my maps" feature to store pins to properties. I ...
4
votes
2answers
1k 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 ...
4
votes
1answer
65 views

How to store processed data?

I'm working on a project involving Twitter data. I have several hundreds thousand tweets downloaded and stored in files. The data was returned in json format, and the stream consumer I was using ...
4
votes
1answer
117 views

What software should I use to display an elegant looking take-out menu on an HDTV monitor? (data pulled from local MySQL server)

My mom owns a small take-and-bake market, and she's been keeping her menu and inventory on an ugly and messy set of whiteboards behind the counter. I've developed a database that lets her check ...
4
votes
1answer
296 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 ...
4
votes
1answer
53 views

Database integration with …well with sound beep or light? [closed]

Perhaps this post major editing : I work for company which sells services online. I would like to build some kind of software bridge/integration tool which would integrate our Oracle database with ...
4
votes
3answers
3k 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 ...
3
votes
5answers
7k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
3
votes
5answers
551 views

Flexible database software recommendation [closed]

I'm a surgeon, just starting my career. I'm hoping / planning to accumulate a 30-year dataset of surgical patients, with one or several procedures associated with each patient. Each procedure will ...
3
votes
3answers
556 views

Is there a GUI interface for sqlite?

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
3
votes
2answers
773 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 ...
3
votes
4answers
641 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: ...
3
votes
2answers
571 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. ...
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 ...
3
votes
2answers
5k views

MySQL form builder like MS Access

Are there any good tools out there (don't have to be be free) that provide functionality analogous to MS Access but for non-MS databases like MySQL? I'm looking for more than just a query builder ...
3
votes
2answers
8k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
3
votes
2answers
2k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
3
votes
5answers
892 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. ...
3
votes
1answer
37 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
3
votes
2answers
421 views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
3
votes
3answers
12k views

Compare two Microsoft Access databases

I have two Access databases that I need to compare but I don't know how I can do this. I'm trying to compare the differences between both the structure and content (possibly limiting the comparison ...
3
votes
1answer
327 views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
3
votes
1answer
43 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 ...
3
votes
1answer
632 views

Purging Expired SQL Server Backups

I have set up a SQL Server Agent job to execute a backup every night at 3am. The job appends the backup to an existing backup file, and sets the expiry of the backup to expire in 7 days time. It's ...