Access to MySQL

What This Book Will Cover

MySQL is the world's most popular open-source database and a strong choice for web-focused Access migrations. This book covers the complete migration process, from installation through reconnection and troubleshooting.

Includes MySQL Workbench migration wizard walkthrough, Bullzip Access to MySQL usage, manual migration with Python scripts, MySQL-specific SQL dialect differences, ODBC Connector setup, and performance tuning for workloads that were designed for Access.

Planned Contents

• MySQL editions and hosting options (Community, Enterprise, cloud services)
• Installation and initial configuration
• MySQL Workbench migration wizard walkthrough
• Bullzip Access to MySQL — quick migration for simple databases
• Manual migration using Python (pymysql, SQLAlchemy)
• Data type mapping: Access to MySQL
• MySQL SQL dialect differences from Access
• ODBC Connector setup for Access front-end
• Storage engines: InnoDB vs. MyISAM (and why it matters)
• Character sets and collation (the UTF-8 trap)
• Performance tuning for typical Access workloads