Table of Contents

Legacy MySQL drivers

This page references the legacy MySQL drivers, which are deprecated since ADOdb 5.20 and were removed in 5.22.

Please refer to MySQL for the current, supported driver (mysqli).

Migrating to the mysqli driver

If you are still using the legacy mysql, mysqlt or mysqlpo drivers, you should be planning on migrating to the mysqli driver. Support for both drivers is built into PHP up to version PHP 5.4. From an ADOdb standpoint, it is simply a case of switching from 

$db = newAdoConnection('mysql')

to 

$db = newAdoConnection('mysqli')

mysql driver

Specification
Driver Namemysql
Data Providermysql)
StatusObsolete1)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This driver uses the PHP original mysql extension and only provides support to non-transactional tables such as MyIsam.

mysqlt driver

Specification
Driver Namemysqlt
Data Providermysql)
StatusObsolete2)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This driver uses the PHP original mysql extension and provided support to transactional tables such as InnoDB.

mysqlpo driver

Specification
Driver Namemysqlpo
Data Providermysql)
StatusObsolete3)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This driver duplicates the functionality of the mysqlt driver and is not maintained. It has been removed in ADOdb version 5.22.1

,
1) , 2) , 3)
This driver has been removed in ADOdb version 5.22.1