Since the last few versions and especially since 5.0.23, the mysqldump command includes new and very important bug fixes.

I'd like to mention three of them that I was affected by:

Bug 16878 (fixed in 5.0.19, 5.1.8): Dump of triggers
Bug 17201 (fixed in 5.0.23, 5.1.12): mysqldump sometimes creates database twice
Bug 18462 (fixed in 5.0.23): mysqldump does not dump view structures correctly

After an interesting question I'm posting here a simple description of how to place your MySQL data on another drive, if you got a server with multiple disks this can really benefit performance.
The picture is this, you have installed MySQL server in the usual C:\Program Files\MySQL\MySQL Server 5.0\ folder, but you have another drive D: and you want to place your data there, you'll create three folders there:

D:\MySQL DataDir\ which will contain MyISAM tables (.frm, .MYD, .MYI files) and also InnoDB tables definitions (.frm files)

D:\MySQL InnoDBDatafiles\ which will contain InnoDB data (ibdata1 etc. files)

D:\MySQL InnoDBLogfiles\ which will contain InnoDB logs (ib_logfile0, ib_logfile1 etc.)

this will be accomplished by:

1. creating those folders …

Just stumbled over this article, which might come in handy for our Microsoft Office users out there: "Using Excel to analyze MySQL data" by Jason Gilmore explains how to set up the MySQL Connector/ODBC and connecting to a MySQL database using Microsoft Excel.

If you're a Linux user, this article on NewsForge covers a similar topic, using OpenOffice.org

to connect to a MySQL Server.

Update: Thanks to Guillermo Roditi for pointing out that both links pointed to the same article - now fixed. Sorry about that.

Everyone using Innodb tables probably got use to the fact Innodb tables perform non locking reads, meaning unless you use some modifiers such as LOCK IN SHARE MODE or FOR UPDATE, SELECT statements will not lock any rows while running.

This is generally correct, however there a notable exception - INSERT INTO table1 SELECT * FROM table2. This statement will perform locking read (shared locks) for table2 table. It also applies to similar tables with where clause and joins. It is important for tables which is being read to be Innodb - even if writes are done in MyISAM table.

So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason is - replication. In MySQL before 5.1 replication is statement based which means statements replied on the master should cause the same effect as on the slave. If Innodb would not locking rows in source table other transaction …

The MySQL GUI tools team has released an updated bundle of our popular graphical tools including:

• MySQL Administrator 1.2
• MySQL Query Browser 1.2
• MySQL Migration Toolkit 1.1
• MySQL Workbench 1.1

The latest Migration Toolkit 1.1 now includes support for migrating from Sybase as well as Oracle, Access, SQL Server and, in fact, any database with a JDBC connector.  The team has also been focusing on improving the quality of all the tools and eliminating some of the bugs that confounded users earlier on.  (With more improvements to follow in the next couple of months.)  Check it out!

• MySQL: Graphical Tools
• MySQL: …

Database administrators hate to upgrade their databases. At MySQL, we like to think that we have been early to recognise this, and we have given more or less unlimited support to even very old releases, on a multitude of platforms. However, this has not been without cost to ourselves.

Many of our users know that the cost of maintaining several releases is high. We have thus been asked to clarify our support lifecycle policy. After long internal discussions, that were not always easy, we are now pleased to say that we have an explicit support lifecycle policy. It addresses the timeframes we will provide updates and continued support for current and older versions of the MySQL server.

Keeping older versions alive for a long time is appreciated by our community and our customers alike. However, we are no longer …

The Term Tagging

The popular feature of 'tagging' content is nothing new. The average netizen should have encountered it by now. Tagging was made popular by sites like del.icio.us and flickr, where users can attach free-form strings, so-called 'tags' to their bookmarks and images. The viewer can then use these tags to navigate through one or more user's contents and locate related content.

Scientific Background

The most-cited work on tagging is this research paper from HP, which starts categorizing tagging as 'folksonomy' (folk taxonomy) in contrast to the conventional term taxonomy. A taxonomy is usually a categorization of content according to a hierarchical and exclusive tree of attributes, while the folksonomy is …

By nat

I spent the week before Where 2.0 driving between Berkeley, San Francisco, Palo Alto, Mountain View, and Sunnyvale. One of the companies I met with was Meebo, an instant messaging startup in Palo Alto. Elaine, one of the three founders, is co-chair of the Javascript track at OSCON this year. Read on to learn how persistence pays off, why they make me feel old, and how their users helped them internationalize the site ...

Who

The company was started by three friends: Sandy Jen, Elaine Wherry, and Seth Sternberg. They're Stanford alumni, but all had jobs and worked on Meebo in their spare time. Meebo's actually the third incarnation of the company: they tried backup software, then p2p file sharing, and finally IM. They'd get to a point where they realized "this just isn't going to work" and moved on to …

Here are some pictures from first UG meeting in Denmark.

In my previous blog entry I described how to install a Pre-configured version of the Pentaho BI Platform. That entry concluded with testing a few out of the box samples to verify that the BI Platform is working correctly.

In this entry I will discuss some Pentaho (PCI) post-installation tasks. All these are also described in the Pentaho Quick start Guide.

Running the PCI as a server

A demo environment with samples is nice, but it's even nicer when you can offer the samples right at the fingertips of your audience. Suppose you want let a business play around with some of the samples: you certainly do not want to force them to crawl behind your demo machine. That would be like going to a restaurant and find out that they've only got one plate to eat from, so that all the customers need to queue …