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

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

Please refer to [[v5: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 **[[v5: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 has been removed in ADOdb version 5.22.1))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|
</WRAP>
This driver uses the PHP original mysql extension and only provides support to non-transactional tables such as MyIsam.
 
  * It cannot be used with the PHP 'Improved' MySQL driver. 
  * The PHP extension 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 has been removed in ADOdb version 5.22.1.


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

  * It cannot be used with the PHP 'improved' MySQL driver. 
  * The PHP extension 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 has been removed in ADOdb version 5.22.1

--------------------------------
===== mysqlpo driver =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|mysqlpo|
^Data Provider|mysql)|
^Status|Obsolete((This driver has been removed in ADOdb version 5.22.1))|
^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 has been removed in ADOdb version 5.22.1
------------------------------------------

{{tag>[MySQL deprecated]}}