====== Legacy MySQL drivers =====

This page references deprecated legacy drivers for MySQL. Please refer to [[v6:database: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 **[[v6:database:mysql|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 =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|mysql|
^Data Provider|mysql)|
^Status|Obsolete((This driver will be removed in ADOdb version 6))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|
</WRAP>
This driver uses the PHP original mysql driver and only provides support to non-transactional tables such as MyIsam.
 
  * It cannot be used with the PHP 'Improved' MySQL driver. 
  * The PHP driver is deprecated as of PHP Version 5.5 and will be removed in PHP version 7. 
  * This driver is deprecated as of ADOdb version 5.20 and will be removed in ADOdb version 6.0.


-----------------------------------------------
===== mysqlt driver =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|mysqlt|
^Data Provider|mysql)|
^Status|Obsolete((This driver will be removed in ADOdb version 6))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|
</WRAP>
This driver uses the PHP original mysql driver and provided support to transactional tables such as InnoDB. 

  * It cannot be used with the PHP 'improved' MySQL driver. 
  * The PHP driver is deprecated as of PHP Version 5.5 and will be removed in PHP version 7. 
  * This driver is deprecated as of ADOdb version 5.20 and will be removed in ADOdb version 6.0

--------------------------------
===== mysqlpo driver =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|mysqlpo|
^Data Provider|mysql)|
^Status|Obsolete((This driver will be removed in ADOdb version 6))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|
</WRAP>
This driver duplicates the functionality of the mysqlt driver and is not maintained. It will be removed in ADOdb version 6.0
------------------------------------------

{{tag>MySQL deprecated}}