MySQL® is a well known DataBase Management System (DBMS) that provides various types of tables for different database applications. Version 4.1.0 and above MySQL databases are spatially extended to incorporate the Open GIS Consortium Simple Features Specification for simple geometric features. The MySQL reader and writer plugin provides the Feature Manipulation Engine (FME) with the ability to read and write both attribute and geometric data stored in a MySQL database. There are two versions of the reader and writer, MySQL which includes the spatial extension and supports geometry features, and MySQL_DB which is an attribute only version which ignores geometry. Currently the table types that can be read are MyISAM, InnoDB and MEMORY.

Note that only MyISAM tables currently support geometry columns.The MySQL reader and writer are specifically designed to handle the geometric portions of the data when present and are optimized for non-geometry or attribute processing when no spatial columns are present. The MySQL reader and writer communicate directly with the MySQL C API interface for maximum throughput. This chapter assumes familiarity with MySQL, the table types, column types, OGC geometry types, available server daemons, indexing mechanisms and connection parameters.

Please note that MySQL functionality that only exists in the MySQL road map and not in practice such as integration of the Spatial Reference Systems (SRS), spatial metadata tables, spatial operators, server side cursors and views were considered but are not currently integrated into the MySQL reader for FME.

FME has been “MySQL ®Network™ Certified” against the MySQL Pro certified binary version 4.1.10a. MySQL Network is the only MySQL version certified for FME; users are encouraged to migrate to MySQL Network. For more information, please see the MySQL home page at: http://www.mysql.com/

Download