During migration using OIL in windows I ran across the error of an Undefined constant MYSQL_ATTR_COMPRESS.

I checked first the php extensions and made sure PHP_PDO_MYSQL was enabled. It was.

It appears that FuelPHP has some pretty powerful configurations. And after translating a google search page from Japanese to English found out that you can disable the Compression of PDO. This allowed me to use the migration. But is only a blind eye to it. If anyone knows why this happens and has a fix, please comment below. For those stuck add the following to your /app/config/development/db.php:

return array(
   'default' => array(
   'connection' => array(
      'dsn' => 'mysql:host=localhost;dbname=fuel_db',
      'username' => 'root',
      'password' => 'root',
      'compress' => false  // ADD <-- This to turn compression off
    ),
  ),
);