MySQL Examples

MySQL has the broadest example set in the repository because it exercises the most pgferry features.

Available examples

• minimal-safe
• recreate-fast
• hooks
• sakila
• schema-only
• data-only
• chunked-resume

Start here

If the source is production and you want the least drama:

1. Begin with minimal-safe.
2. Run pgferry plan.
3. Add validation = "row_count", resume = true, and unlogged_tables = false.
4. Only switch to recreate-fast after you understand the operational tradeoff.

MySQL-only features to look for

• enum and set handling
• unsigned integer widening and optional checks
• binary(16) UUID conversion
• citext mapping for _ci collations
• native PostGIS migration for spatial columns