Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 35 Next 5 Older Entries

Displaying posts with tag: Migration (reset)

How-To: Guide to Database Migration from MS Access using MySQL Workbench
Employee_Team +1 Vote Up -0Vote Down

Edit: added sample table output in MySQL

MySQL Workbench 6.2 introduces support for MS Access migration. This tutorial should help you get your Access tables, indexes, relationships and data in MySQL.


Because MS Access ODBC drivers are only available for Windows, migrating from it is also only possible from Windows. As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network.

MS Access stores relationship/foreign key information in an internal table called MSysRelationships. That table is protected against read access even to the Admin user, so if you try to migrate without opening up access to it, you will get an error like this:

[42000] [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission
  [Read more...]
Big Data Integration & ETL - Moving Live Clickstream Data from MongoDB to Hadoop for Analytics
+1 Vote Up -0Vote Down
June 16, 2014 By Severalnines

MongoDB is great at storing clickstream data, but using it to analyze millions of documents can be challenging. Hadoop provides a way of processing and analyzing data at large scale. Since it is a parallel system, workloads can be split on multiple nodes and computations on large datasets can be done in relatively short timeframes. MongoDB data can be moved into Hadoop using ETL tools like Talend or Pentaho Data Integration (Kettle).


In this blog, we’ll show you how to integrate your MongoDB and Hadoop datastores using Talend. We have a MongoDB database collecting clickstream data from several websites. We’ll create a job in Talend to extract the documents from MongoDB, transform and then

  [Read more...]
Porting from Oracle to MySQL
+0 Vote Up -0Vote Down
A potential customer asked my about porting her application from Oracle Database to MySQL.

I always try to start with the "why" (a dear friend bought me this book, recommended: http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).

She said "cloud!". I said "OK!".

I conducted a short research, found many things in many places all over the place, brought them to a nice email I sent her back and then thought I'll post it here and make it public as it might be useful for us all. If you feel that I missed something, add comments, send feedback.

These are the leading tools to do the actual migration of the data structure, data export/import, sprocs, triggers, etc.:
  • MySQL Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
  • MySQLYog can be used to migrate:

  •   [Read more...]
    MySQL 5.6 GTIDs: Evaluation and Online Migration
    +0 Vote Up -0Vote Down

    A colleague and I have been looking at GTID on MySQL recently and you may be interested in the blog post that results from that. You can see it here. http://blog.booking.com/mysql-5.6-gtids-evaluation-and-online-migration.html.


    Webinar Replay & Slides: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    March 13, 2014 By Severalnines

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.


    Special thanks to Seppo Jaakola, CEO at Codership, the creators of Galera Cluster, and to Johan Andersson, CTO at Severalnines, for their presentations and the live demo.


    Webinar topics discussed: 

    • Application use cases for Galera
    • Schema design
    • Events and Triggers
    • Query design
    • Migrating the schema
    • Loading initial data into the
      [Read more...]
    Mixing databases usually not optimal
    +0 Vote Up -0Vote Down

    Dan McKinley (Etsy) wrote an [IMHO] insightful article Why MongoDB Never Worked at Etsy.

    First off, it’s important to realise that it’s not a snipe at MongoDB – it’s a fine tool.

    The lessons are related to mixing multiple databases in a deployment (administration and monitoring overhead) and the acknowledgement that issues of schema design, scalability and maintenance need attention regardless of which brand or technology you pick for your database. That comes back to the old insight that migrations are rarely worth it (regardless of what you migrate to what).

    I think these are indeed important considerations as they have a major impact on the ongoing costs of your entire environment (production as well as development and testing) – these days we

      [Read more...]
    Video Tutorial: Setup a Restricted SQL Server Account for Migrations with MySQL Workbench
    Employee_Team +0 Vote Up -0Vote Down

    Some users have asked us what is the minimum set of privileges that your Microsoft SQL Server user needs to successfully migrate databases from SQL Server using the MySQL Workbench Migration Wizard. Even though we don’t execute any query that alters anything in your source RDBMS servers, it’s never a bad idea to add an extra security barrier around it.

    In short, you need the VIEW ANY DEFINITION permission for the server and the CONNECT and SELECT permissions for the database(s) you want to migrate. But to make this easier for you, we have created a video tutorial showing how to create a user with these permissions using the Microsoft SQL Server Management Studio.

    How-To: Database Migration from Sybase Adaptive Server Enterprise using MySQL Workbench
    Employee_Team +0 Vote Up -0Vote Down

    In this tutorial I’m going to show you how to migrate your Sybase Adaptive Server Enterprise databases to MySQL.

    As usual, we’ll start with a couple assumptions:

    • You have MySQL Workbench 6.0 installed.
    • You have a running Sybase Adaptive Server Enterprise database somewhere in your network. I’ll be using the pubs3 sample database that Sybase distributes with Adaptive Server Enterprise 15.
    • You have installed the Sybase Adaptive Server Enterprise ODBC drivers in the same PC where MySQL Workbench is running. The ODBC drivers are distributed with the Sybase Adaptive Server Enterprise SDK and included in the Adaptive
      [Read more...]
    Replicate from a MySQL Server into a Galera Cluster
    +0 Vote Up -0Vote Down
    June 28, 2013 By Severalnines

    This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE:


    In this example we have the following hosts:


    read more

    How-To: Database Migration from Sybase SQLAnywhere using MySQL Workbench
    Employee_Team +3 Vote Up -0Vote Down

    In MySQL Workbench 6.0 two new additions have been made to the supported RDBMS sources list in the Migration Wizard: Sybase SQLAnywhere and SQLite. In this tutorial I’m going to show you how to migrate your Sybase SQLAnywhere databases to MySQL.

    As usual, we’ll start with a couple assumptions:

    • You have MySQL Workbench 6.0 installed.
    • You have a running Sybase SQLAnywhere database in your local computer (i.e. the computer where you are running MySQL Workbench. I’ll be using the demo database that Sybase distributes with SQLAnywhere 12.
    • A running MySQL Server instance with proper user access is available and you are able to connect to it from MySQL Workbench. The Migration Wizard supports MySQL versions from 5.1 onwards so make sure you have a supported
      [Read more...]
    Summertime Percona MySQL training update
    +1 Vote Up -0Vote Down

    Now that June has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team.

    Summer is the time to brush up on those critical skills needed to ensure all systems are ready for the holiday shopping season.

    In addition to our revised courses, that I talked about in a previous post, we are also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application

      [Read more...]
    Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac
    Employee_Team +3 Vote Up -0Vote Down

    In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?

    It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can’t use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them

      [Read more...]
    How-To: Migrate PostgreSQL databases to MySQL using the MySQL Workbench Migration Wizard
    Employee_Team +6 Vote Up -0Vote Down

    MySQL Workbench 5.2.41 introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. As of Workbench 5.2.44 you can migrate databases from Microsoft SQL Server, PostgreSQL and Sybase Adaptive Server Enterprise. It also provides for generic migrations, i.e. migrations from other RDBMSes that are not explicitely supported, provided that they have a well behaved ODBC driver. More on this in an upcoming post…

    Additionally, you can use the Migration Wizard to perform MySQL to MySQL database migrations, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.

    We have already described in a previous post how to use the

      [Read more...]
    MySQL Workbench 5.2.41 GA + Migration Wizard Available
    Employee +3 Vote Up -0Vote Down

    The MySQL developer tools team announces the availability of version 5.2.41 of the MySQL Workbench GUI tool. This version has significant improvements in several parts of the tool and also includes the new Migration Wizard plugin.

    The new Migration Wizard presents an easy to use GUI for migrating databases from third party products to MySQL. In this initial release, support for Microsoft SQL Server is included, in addition to other products that support ODBC, such as PostgreSQL.

    Other improvements include:

    • More than 100 bug fixes
    • Code completion in the SQL Editor (beta)
    • Better handling of schema synchronization in modeling
    For a full list of issues fixed in this release, see    [Read more...]
    How-To: Guide to Database Migration from Microsoft SQL Server using MySQL Workbench
    Employee_Team +3 Vote Up -0Vote Down

    MySQL Workbench 5.2.41 introduces a new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as well, using its generic RDBMS support. Additionally, you can use it to perform MySQL to MySQL database copies, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.

    So let’s get our hands dirty and run through the Migration Wizard in order to migrate a Microsoft SQL Server database to MySQL. In the rest of this post I assume that you have:

    • A running SQL Server instance in which you have proper access to the database you want to migrate.
      [Read more...]
    Converting MS Access to MySQL with relationships
    +1 Vote Up -0Vote Down

    I have used tools like MySQL Migration Toolkit (*) and Bullzip’s Access To MySQL utility, both do a excellent job but without relationships. We can spend a lot of hours to identifying and creating relationships until now:

    I have write a VBA script to identify MS-Access relationships and create MySQL code with SQL-CREATE sentences, it will be useful after migration process using any free tool:

    'Put this function in new/existing MS-Access module.
    ' Version History:
    ' 2014-02-09 - Seamus Casey
    ' a modification to Ivan's handy Access to MySQL relationship/constraint generator
    ' changes include:
    '  1) skip Access system tables (TableDefAttributeEnum.dbSystemObjec)
    '  2) add support for cascading updates/deletes
    Public Sub printRelations()
        Dim sql,
      [Read more...]
    Latest New Whitepapers in the IOUG On-line Library – 11-Jan-2012
    +1 Vote Up -0Vote Down
    Current White Papers for the Oracle Professional Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate In this paper we will review Oracle GoldenGate’s capabilities and how it can be used to achieve zero downtime migration and consolidation to Oracle … Continue reading →
    Quickly and efficiently migrating hundreds of servers from MySQL to MariaDB
    +3 Vote Up -1Vote Down

    Via SpamExperts:

    SpamExperts has their own anti-spam filtering cloud which is provided as a software-as-a-service (SaaS) model. In addition they have an e-mail security product which they install, update and monitor on-site. Most of SpamExperts’ anti-spam technology has been developed in-house and makes extensive use of the MySQL database. All clients contribute in real-time to their filtering effectiveness, so they have many different data flows that are handled by MySQL. Replication is used to synchronize the data between the systems in a cluster and to push data feeds in real-time. The SaaS cloud is replicated

      [Read more...]
    Video: Netflix's migration to AWS cloud
    +0 Vote Up -1Vote Down
    Found this video regarding Netflix's migration to Amazon's AWS cloud very informative. Enjoy!
    Cloud Migration Whitepapers
    +0 Vote Up -2Vote Down
    Amazon's AWS team has published a series of whitepapers covering various scenarios for migrating into AWS cloud infrastructure. Links to these whitepapers are provided below for your convenience:

    - Migrating applications to the AWS cloud
    - Migrating web application
    - Migrating batch processing applications
    - Migrating backend processing pipelines
    Why mysqldump is converting my tables from InnoDB to MyISAM?
    +5 Vote Up -0Vote Down

    First of all: mysqldump is not converting tables. It is something else. Here is the story:

    One of my clients had a case when they were migrating to a new mysql server: they used mysqldump to export data from the old server (all InnoDB) and imported it to the new server. When finished, all the tables became MyISAM on the new server. So they asked me this question:
    “Why mysqldump is converting my tables from InnoDB to MyISAM?”

    First of all we made sure that the tables are InnoDB on the old server. It was true.
    Second we run “show engines” on the new server:

    | Engine | Support | Comment

      [Read more...]
    YAPCEU 2010 – Day Two…
    +1 Vote Up -0Vote Down

    After enjoying the excellent hospitality of our host here in Pisa (6 courses) we were ready for our second day at YAPCEU 2010 here in sunny Pisa.

    Larry’s new catch phrase “My Language is a four letter word” was the ‘Buzz word’ for today. We settled down to some very interesting talks, the highlight for me being Tim Bunce’s talk on using Devel::NYTProf to Optimize your code. Tim first gave us a quick and dirty overview of optimization which covered the basics of where to start and what to look for he followed up with real examples of Optimizer output and than wrapped up with a few before and after results on an optimization effort.

    The rest of the day was dedicated in my opinion, to the future of DBs in with Nelson Ferraz giving an excellent presentation of his concepts for using Perl as to glue for a Data Warehouse application. Next on my agenda,

      [Read more...]
    Datetime & Timestamp manipulation / migration explained
    +0 Vote Up -0Vote Down

    Are you doing some datetime manipulation or maybe you are migrating from some database technology to MySQL or possibly using milliseconds?
    Here is an example on how to go about it:

    Say you have the following date: MAR 16 2008 09:12:51:893AM
    SELECT DATE_FORMAT(STR_TO_DATE('MAR 16 2008 09:12:51:893AM','%M %d %Y %h:%i:%s:%f%p'),'%Y%m%d%k%i%s.%f'); --> 2008031691251.893000

    What if its PM rather than AM
    SELECT DATE_FORMAT(STR_TO_DATE('MAR 16 2008 09:12:51:893PM','%M %d %Y %h:%i:%s:%f%p'),'%Y%m%d%k%i%s.%f'); --> 20080316211251.893000

    Ok so this is just simple string manipulation where:
    %M is the month name
    %d is day number
    %Y is the year
    %h is the hour
    %i is the minute
    %s is the second
    %f is the microsecond
    %p is the

      [Read more...]
    Log Buffer #182, a Carnival of the Vanities for DBAs
    +3 Vote Up -0Vote Down

    This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick!

    This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.

    This week was also the Hotsos Symposium. Doug’s

      [Read more...]
    Migrating MySQL latin1 to utf8 – Character Set Options
    +1 Vote Up -0Vote Down

    Continuing on from preparation in our MySQL latin1 to utf8 migration let us first understand where MySQL uses character sets. MySQL defines the character set at 4 different levels for the structure of data.

    • Instance
    • Schema
    • Table
    • Column

    In MySQL 5.1, the default character set is latin1. If not specified, this is what you will get. For example.

    mysql> create table test1(c1 varchar(10) not null);
    mysql> show create table test1\G
    Create Table: CREATE TABLE `test1` (
      `c1` varchar(10) NOT NULL

    If you want all tables in your instance to always be a default of utf8, you can changed the server variable

      [Read more...]
    Migrating MySQL latin1 to utf8 – Preparation
    +0 Vote Up -0Vote Down

    Before undertaking such migration the first step is a lesson in understanding more about how latin1 and utf8 work and interact in MySQL. latin1 in a common and historical character set used in MySQL. utf8 (first available in MySQL Version 4.1) is an encoding supporting multiple bytes and is the system default in MySQL 5.0

    • latin1 is a single byte character set.
    • utf8 is a 1-3 byte character set depending on the size of the character. NOTE: MySQL utf8 does not support the RFC 3629 4 byte sequences

    MySQL variables

    MySQL has a number of different system variables to consider, the following is the default representation in MySQL 5.1

    mysql> show global variables like '%char%';
      [Read more...]
    Free Migration and Windows Clustering Webinars Tomorrow
    Employee +0 Vote Up -0Vote Down
    We've got another round of free Windows-centric webinars coming up tomorrow:

    Migrating from SQL Server to MySQL (North America)...covering the fundamentals of why and how to migrate, plus an apples to apples feature comparison. Register here (http://www.mysql.com/news-and-events/web-seminars/display-443.html)

    Windows Server 2008 Failover Clustering with MySQL (EMEA)...Mike Frank will run through step by step how to set up a development environment with minimal cost/effort that implements Windows Clustering and MySQL. Register here (http://www.mysql.com/news-and-events/web-seminars/display-452.html)

    Finally, check out LiveTime's presentation next week where they will demonstrate the methodology and toolset they use to perform free SQL Server to MySQL migrations for their customers. Register here (http://www.mysql.com/news-and-events/web-seminars/display-466.html)
    Free Webinar: Migrating from Microsoft Access to MySQL
    Employee +0 Vote Up -0Vote Down
    Join us for a free webinar tomorrow where we will present the fundamentals of migrating a sample application from Microsoft Access to a MySQL back end. We will be giving the presentation twice, at 14:00 Central for EMEA and 10:00 Pacific for North America. To register, visit here (http://www.mysql.com/news-and-events/web-seminars/index.html).
    50 things to know before migrating Oracle to MySQL
    +0 Vote Up -0Vote Down

    A while back I was at a seminar on migrating database applications to MySQL. A lot of the attendees were Oracle users. Based on their questions, comments and conversations during lunch, I made the following list of things Oracle users need to know about migrating to MySQL. Most of these are “gotchas” that would be contraindications or require some thought about a workaround.

    Note: this is not meant to be MySQL-bashing. Some of these limitations are going to be fixed in future versions of MySQL, but they generally apply to current GA version 5.1. Some things are possible to achieve by choosing one particular way to use the server, at the exclusion of other things (e.g. Cluster rules out foreign keys, spatial data types rules out transactions). I am posting this list at the request of some Oracle DBAs who asked me to produce it

      [Read more...]
    review: High Performance MySQL 2nd Ed.
    +0 Vote Up -0Vote Down

    I just finished reading the recently released 2nd Edition of High Performance MySQL by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz & Derek Balling.  I’ve posted a review here on Amazon.

    Wow, that’s quite a list of authors, but when you look at the material, you see why.  This book is a very indepth look at the MySQL server.  Intended for the intermediate to advanced DBAs and developers who want to know the inner workings of the server, as well as how to use many of it’s advanced features.

    For instance the chapter on replication was quite good.  Given that you probably setup replication in five minutes, and are wondering weeks or months

      [Read more...]
    Showing entries 1 to 30 of 35 Next 5 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.