Contents

• Introduction
• About Data Export feature
• How to move data using Data Export
• Summary

Introduction

This article describes how to migrate data from MySQL database to any other database, for example, Oracle, Microsoft SQL Server, IBM DB2, or PostgreSQL one, using Data Export feature of dbForge for MySQL products. To illustrate it, we will move data from table actor and the query result from sakila database that exist on MySQL server to the schema SCOTT on Oracle server. To see the screenshots in full size, just click them.

About Data Export Feature

Data Export feature is part of dbForge Studio for MySQL and dbForge Fusion for MySQL products. It represents a customizable tool for data exporting …

I presented a webinar on "Developing GlassFish- and MySQL-Backed Applications with NetBeans and JRuby-on-Rails" last week.



The slides and a complete recording of the webinar are now available here.

Technorati: webinar glassfish mysql netbeans jruby …

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I originally had much longer headings for all of them.) I would also like to thank many of MySQL, PostgreSQL and Java DB colleagues, as well as to many other colleagues involved in open-source development, for having contributed to the ideas and practices behind these rules.

A) …

There are some basic, golden rules when it comes to having a vibrant community of contributors.

The following are rules I have extracted and learned based on my experience managing and working with engineers actively involved and participating in the Apache/Derby, PostgreSQL and MySQL open-source communities. These rules are also based on extensive discussions with many folks involved with the MySQL community, with the PostgreSQL community and with the Apache/Derby (Java DB) community, over many years.

Before I go through these rules, I would like to thank Marten Mickos for having suggested some of the headings for these rules. (I originally had much longer headings for all of them.) I would also like to thank many of MySQL, PostgreSQL and Java DB colleagues, as well as to many other colleagues involved in open-source development, for having contributed to the ideas and practices behind these rules.

A) …

Is there any reason for not supporting innodb_flush_method=O_DIRECT on Mac OS X? Today I wrote a tiny patch to enable O_DIRECT on MySQL running on Mac OS X, and it seems to work fine. (mysql-5.1.30-osx-o_direct.patch)

Although I do not think it is a good idea to use Mac OS X as a database server (since it's I/O system calls are slow compared to other OSes, at least until Snow Leopard is released), having O_DIRECT support would be better than none in some cases.

John Lilly, CEO of Mozilla, shares some insights and thoughts on Mozilla, and its a most interesting presentation to go through. The insights are (drizzled with some of my comments):

1. Superior Products Matter - Without excellent experience and utility, the rest is meaningless. This is true, even with MySQL - our aims and values have always been performance, reliability and ease of use.
2. Push (most) decision-making to the edges - I understand that as make sure your community has a significant voice (kind of like Wikipedia’s anyone edits policy, but there’s patrolling). He also suggests that on a regular basis, you need to have surprising innovation - things that blow people’s minds. In Mozilla’s case, there are a set of core values that everyone agrees too; …

As you may know, Open Query is entirely self-funded, which means the banks owe OQ and me money not vice versa. Things like interest rates are of little concern, which is helpful in volatile times! Of course I do rely on my bank staying in business, but that's now subject to a government guarantee in Australia so I'll just have to go with that for now ;-)

So far, OQ has not experienced much from the economic troubles. But I'll tell you about the possible encounters, since I think they're of interest and lessons can be learnt.

We give away one book to each student at a training day, that is, provided they've paid on time (basically a personalised quick payment bonus). I've got a small shortlist of decent books, but generally I've been handing out copies of …

I realize I’m running a bit late with my MySQL Conference speaking announcement this year, nonetheless yes I will be in Santa Clara again just as in 2007 and 2008. This time I won’t be doing a talk by myself or with Phil as in the last two years, but rather with Joachim Worringen from our technology partner Dolphin.

Our talk, titled Database High Availability with a Punch: MySQL with DRBD for Dolphin Express, is currently scheduled for Thursday, April 23.

Registration …

One year after Sun acquired MySQL we see the positive results of this acquisition. Things are going very well in terms of collaboration, the teams are getting closer together and share the experience and the knowledge. If you want to know how the teamwork is seen from the Sun Cluster engineers, Thorsten Frueauf and myself, you should read this.

It was interesting for us to see that this interview was well observed by MySQL customers and community members. Although the interviews were not technical, they lead to technical questions. You can get more information here.

So if you are keen to see what the MySQL community wants to know about Sun Cluster, read the blog entry about MySQL and Sun Cluster.

Detlef …

I presented a webinar on "Developing GlassFish- and MySQL-Backed Applications with NetBeans and JRuby-on-Rails" last week.



The slides and a complete recording of the webinar are now available here.

Technorati: webinar glassfish mysql netbeans jruby …